Español
English
Forum
List Manager Support
List Manager supportForums
Public write access is disabled. Please login
select and insert value from another list 10.03.2024 15:20
I have got 2 lists. One List "Client", second list "Nationality". In list Client I got the field Text Nationality. Here I would like to select one of the values ( example Spanish| German...) from the list "Nationality". Anyone How, Please? Regards HM
Re: select and insert value from another list 11.03.2024 09:12
Hi,
you can configure the field nationality at the client list as an option list, and then recover the possible values dynamically using the data/values->sql query . Place there the right query to recover the set of options from the other list, something like
select youfield from nationalitytable
...and you should see its values available to select at the main list.
Hope this helps, regards
Moonsoft Team
www.moonsoft.es
you can configure the field nationality at the client list as an option list, and then recover the possible values dynamically using the data/values->sql query . Place there the right query to recover the set of options from the other list, something like
select youfield from nationalitytable
...and you should see its values available to select at the main list.
Hope this helps, regards
Moonsoft Team
www.moonsoft.es
Re: select and insert value from another list 17.03.2024 15:41
Dear Moonteam
thank you for the help. Aim using SELECT '*' FROM Nationality database table, as the columfield from the list doesnt work. Probably my lack of knowledge. Is there any chance to get the Colum Name in list view on top of the selected value. Looks a bit strange,as anywhere else is it on top.
Regars and Thanky you for you always great imput HM
thank you for the help. Aim using SELECT '*' FROM Nationality database table, as the columfield from the list doesnt work. Probably my lack of knowledge. Is there any chance to get the Colum Name in list view on top of the selected value. Looks a bit strange,as anywhere else is it on top.
Regars and Thanky you for you always great imput HM
Re: select and insert value from another list 18.03.2024 09:17
Hi,
sorry but we think we don't fully understand the question. You do have to use a query from Nationality table, that you can set as the dynamic content of the field typed 'option list'. But not sure where do you want to show the column name, every column name should show at the header of the table, can you please provide further details for solving this question? You can place a private ticket at the helpdesk instead if you need to add any screenshot that may be of hepl.
Thanks ,best regards
Moonsoft Team
www.moonsoft.es
sorry but we think we don't fully understand the question. You do have to use a query from Nationality table, that you can set as the dynamic content of the field typed 'option list'. But not sure where do you want to show the column name, every column name should show at the header of the table, can you please provide further details for solving this question? You can place a private ticket at the helpdesk instead if you need to add any screenshot that may be of hepl.
Thanks ,best regards
Moonsoft Team
www.moonsoft.es
Re: select and insert value from another list 20.03.2024 16:32
Helpdesk quick and prof, that is what they sent and it does work!! Happy
"
ok, now we see the issue, thanks. In fact, labels for select inputs are placed on top, just like the rest of the fields. So for having the result we can see at the screenshot, there must be some style at your template that is overriding the default bootstrap styles. You can confirm changing for a while the template and see if the labels are placed properly then. In this case, you will need to correct your css, adding any custom class required to get the desired result. For this purpose, you have available the 'css' option at the main options of the list, where you can type any style to be added. For ex, but you could try
select{
width :100%;
}
"
regards HM
"
ok, now we see the issue, thanks. In fact, labels for select inputs are placed on top, just like the rest of the fields. So for having the result we can see at the screenshot, there must be some style at your template that is overriding the default bootstrap styles. You can confirm changing for a while the template and see if the labels are placed properly then. In this case, you will need to correct your css, adding any custom class required to get the desired result. For this purpose, you have available the 'css' option at the main options of the list, where you can type any style to be added. For ex, but you could try
select{
width :100%;
}
"
regards HM