valid_if problem

[bolognesiedalla]

Hello everybody. I’m used to filtering values ​​using the valid_if field. In this case I would like the [TERRENI] column to show the values ​​based on the value selected in the [CLIENTE] column. this is the compilation of the [LANDS] column

my problem is that if a customer does not have TERRENI yet, the [TERRENI] column does not appear, but this is a mandatory data. in this case “Bolognesi Piero” already has some lands created. While “MODELLI” has no land created in the registry

In addition, some fields of the following tab (COLTURE - INTERVENTI) have compilation formulas that depend on the selected [LAND] value.

1.How can I prevent the user from filling out the rest of the form before having selected the [TERRENI] column?

2. how can i prevent the land field from disappearing from the form? Ideally it would be left with the empty dropdown choice where you can click the “add” action directly from here

I hope I was clear. thank you

[Suvrutt_Gurjar]

@bolognesiedalla

1.How can I prevent the user from filling out the rest of the form before having selected the [TERRENI] column?

You could include show_if in the Page Header show columns of COLTURE and INTERVENTI tabs as follows

ISNOTBLANK([TERRENI] )

This show_if will prevent the tabs COLTURE and INTERVENTI being shown till the user selects at least one value in [TERRENI] field.

@bolognesiedalla

2. how can i prevent the land field from disappearing from the form? Ideally it would be left with the empty dropdown choice where you can click the “add” action directly from here

The add on choice will show if the enum/enumlist field is not composed of values by Valid_if expression. Since you are using Valid_if in the field [Terreni], the field will not show, if the selected customer does not have land in lands table.

I believe there are no straightforward workarounds to get what you are looking for in this case.

[bolognesiedalla]

I followed your instructions for the 2 tabs. Then I added a column of type show, with the writing “to continue the compilation it is necessary to create at least one land in COMPANIES> details”. thanks a lot