This content has been marked as final. Show 4 replies
What I mean is form should show the layout dynamically from the country table.Do you want to show each selected country in a different column across the width of the form? If so, you need to limit the number of countries they can select.
I think to create layout with each country 230 times is not a good practice.
Or could you show each selected country and the data for that country in a new row in a block? That would be much easier.
Please explain more what you need to display and how it should be displayed, for each selected country.
I would create a block based on your countries table, then you can show as much records as there are in teh table. Make the staus-column a checkbox with value 1 when checked and value 0 when unchecked. The you simple have to issue a COMMIT_FORm to save the changes.
The only problem is... What if two users want to check different countries? Then updating the status-column won't work.
I have to show user all the 230 countries.They might select around 20 countries for which they want to see some data.
So I have to show them all the countries in the layout.
layout will be something like this-
Australia |_| (Check box)
Afghanistan |_| (Check box)
Denmark |_| (Check box)
Norway |_| (Check box)
UK |_| (Check box)
USA |_| (Check box)
Zambia |_| (Check box)
How can I show this in a canvas from country table where all the country name are there.
Do it as i described in my previous post. Build a tabular block based on your countries-table and issue an EXECUTE_QUERY. Make the itemtype of your status-column "Checkbox".