Hello people i have this question
i have a form that load some information
when i wrote the userid and look up the field. the others fields cédula,localidad get a value from a Report Query like this
ca_fdSetTextFieldValue(ca_fd.formId, 'lookup_localidad', result[0].localidad);
but this dont happen with the select(yellow) how can i do this? how can i set a default value to the select
note:the select isn´t static this use a "variable de informe"
Thanks for your help
Good Morning John.
Please check on the below explanation and let me know your findings.
The form is constructed in such a way that (the value of) a designed text-field serves as input for a lookup component.
Meaning that the content of the look-up list is based on the content of the text-field.
Which in turn means, that no input is to be entered in the look-up field itself to determine the content of the look-up list.
And it is to say that You can have either or.
Meaning that when you have the current setting(taking the userid from the pre-populated form-field <form_texffield_id>),
$({'userid':ca_fdGetTextFieldValue(ca_fd.formId, '<form_texffield_id>')})
you can open the dropdown list by hitting the down-arrow-icon in the list the corresponding data-query rows will then appear.
OR
You let the look-up content depend on what you type in the look-up itself.
With this set in the form: $({'<dataquery_where_column>':_val})
With this setting, you can enter data in the form's look-up component itself to retrieve another list of rows.
To have BOTH is not supported/will not work.
It is supported to enter 'data' in the lookup field and get the corresponding list to be shown.
In combination with the data object/query: WHERE userid like '%%%user_id%%%'
Then you can enter (a part of) the userid and the list-content will adapt accordingly.
Kind regards, Louis.