Back to limesurvey.org

Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

CAMPOS DE TEXTOS ESTATICOS

  • yuleidis
  • yuleidis's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 months 3 weeks ago #265058 by yuleidis
CAMPOS DE TEXTOS ESTATICOS was created by yuleidis
Ayúdenos a ayudarle y complete cuando corresponda:
Su versión de LimeSurvey:   url=https://community.limesurvey.org/]LimeSurvey Community Edition   Versión 6.2.11+231007 [/url
Servidor propio o alojamiento de LimeSurvey: Alojamiento de limesurvey
Tema/plantilla de la encuesta: fruity
=============== ====
buenas tardes,  tengo un inconveniente con esta matriz, no se como ponerle los campos de textos de las columnas
SQ001(ID vendedor),
SQ002(SK empresa),
SQ003(VENDEDOR) Valores estaticos que NO SE PUEDAN MODIFICAR.
Y en la colunma SQ004 me permita  ingresar una fecha en el encabezado y las filas que se le puedan ingresar solo valores numericos .
me puede ayudar por favor gracias 
Attachments:

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 months 3 weeks ago #265059 by Joffm
Replied by Joffm on topic CAMPOS DE TEXTOS ESTATICOS
Please, write English in this part of the forum!
Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

  • yuleidis
  • yuleidis's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 months 3 weeks ago #265062 by yuleidis
Replied by yuleidis on topic CAMPOS DE TEXTOS ESTATICOS
Your version of LimeSurvey: url=https://community.limesurvey.org/]LimeSurvey Community Edition Version 6.2.11+231007 [/url
Own server or LimeSurvey hosting: limesurvey hosting
Survey theme/template: fruity
=============== ====
Good afternoon, I have a problem with this matrix, I don't know how to put the text fields of the columns
SQ001(Seller ID),
SQ002(Company SK),
SQ003(SELLER) Static values ​​that CANNOT BE MODIFIED.
And in column SQ004 allow me to enter a date in the header and the rows that can only be entered numeric values.
Can you help me please thank you
Attachments:

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 months 3 weeks ago - 5 months 3 weeks ago #265063 by Joffm
Replied by Joffm on topic CAMPOS DE TEXTOS ESTATICOS
Hi,
what exactly is your problem?

I don't know how to put the text fields of the columns

Where do the texts come from?
Don't you know how to insert the texts?
Or fon't you know how to make them unchangeable?

For the second two quick solutions.
1. Do the same as in the "Rango cartera" example. Extend it a bit.

2. Use an array(text), insert the texts by a previous equation like
Code:
{Q2c_Y001_X01='1234567'}
{Q2c_Y001_X02='1'}
{Q2c_Y001_X03='José Ramón Mercedes S.A.'}
 
{Q2c_Y002_X01='222222'}
{Q2c_Y002_X02='3'}
{Q2c_Y002_X03='INTEGRAL'}
 
{Q2c_Y003_X01='98765'}
...
If the source of these texts are previous questions you have to use them
{Q2c_Y001_X03=Q1_SQ004}, or something like that.

Set the first three columns to "readonly" by this script.
Additionally here the alignment of each column is set.
You have to do it for each single cell.
Code:
<script type="text/javascript" charset="utf-8">
   $(document).ready(function() {
     $('input[ name="{SGQ}Y001_X01"]').prop('readonly', true).css('text-align', 'right');
     $('input[ name="{SGQ}Y001_X02"]').prop('readonly', true).css('text-align', 'center');
     $('input[ name="{SGQ}Y001_X03"]').prop('readonly', true).css('text-align', 'left');
 
     $('input[ name="{SGQ}Y002_X01"]').prop('readonly', true).css('text-align', 'right');
     $('input[ name="{SGQ}Y002_X02"]').prop('readonly', true).css('text-align', 'center');
     $('input[ name="{SGQ}Y002_X03"]').prop('readonly', true).css('text-align', 'left');
 
     $('input[ name="{SGQ}Y003_X01"]').prop('readonly', true).css('text-align', 'right');
     $('input[ name="{SGQ}Y003_X02"]').prop('readonly', true).css('text-align', 'center');
     $('input[ name="{SGQ}Y003_X03"]').prop('readonly', true).css('text-align', 'left');
...
});
</script>

And the script to adapt the column width you know already.
 

And your second question.
No. the header is a header, not on entry field.
You can insert the actual date - as I did here - by {date('d.m.Y')}
Or you preset the actual date into a additional column, so that the respondent can change it if necessary.
Up to you.

And the "only numerical" entries?
Either validate with something like "
(is_empty(Q1_Y001_X04) or is_numeric(Q1_Y001_X04)) AND (is_empty(Q1_Y002_X04) or is_numeric(Q1_Y002_X04)) AND ...

Or use an input mask (you already have the links and examples)

Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 5 months 3 weeks ago by Joffm.

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 months 2 weeks ago - 5 months 2 weeks ago #265065 by Joffm
Replied by Joffm on topic CAMPOS DE TEXTOS ESTATICOS
Hi, another idea.
Why not use a simple question of type "multiple numerical"?
In the subquestion text you can design the ID and name and then there is only one entry field with a numerical input.

Or question of type "multiple short text"?
Here you can use an input mask with thousand separator and additionaly you can have a first question with a date
 
Here a sample
 

File Attachment:

File Name: limesurvey...73_J.lss
File Size:48 KB


Joffm

Sorry, Copy/Paste mistake.
Third row should be "VENDEDOR" of course.

And another layout - also only a bootstrap table in a card
 
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 5 months 2 weeks ago by Joffm.

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
5 months 2 weeks ago #265073 by DenisChenu
Replied by DenisChenu on topic CAMPOS DE TEXTOS ESTATICOS
If you need any number of vendor (and date) : gitlab.com/SondagesPro/QuestionSettingsT...ionSpreadsheetSurvey

You need to open a support ticket to have it on limesurvey.org cloud hosting
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.

Please Log in to join the conversation.

Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source