List Manager Forum

select and insert value from another list

User Henryxml 2024-03-10 15:20:42

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

Moonsoft support 2024-03-11 09:12:48

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

User Henryxml 2024-03-17 14:41:55

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

Moonsoft support 2024-03-18 08:17:21

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

User Henryxml 2024-03-18 15:38:26

You are right its confusing. Sent Screenshot to helpdesk. Regards HM

User Henryxml 2024-03-20 15:32:42

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

...
List Manager

Build different lists for your site

Buy now!
...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!