Hello everyone,
I have created a form that lists company files. Each company has its own form and each form contains a sub-form.
In the sub-form, I created several lines containing one country per line and in the same sub-form the columns ( around ten) are data.
However, it happens that for some companies there is no data for some columns, which implies that column remains empty.
Thus, imagine a sub-form for a company can have 3 columns: one with the name of the country, one with the country’s GDP and one with the country’s political risk. There are countries for which the GDP information is available but for others it is not the case. So, whether GDP cell is empty in all the lines, I would like to hide this column and leave only the columns which contains data.
The question is:
=> Is it possible to display the columns automatically whether the cell is empty?
In fact, I want the form columns that have no data to be hidden, but I can't make a filter in the request columns because otherwise it applies for all lines, and the data available is not the same for all of them.
I hope it’s clear enough and you’ll can help me !
