Prevent data entry

Hola Comunidad de AppSheet

I have a main table, “entradas_encabezado,” and a dependent table, “entradas_detalle.” They are related by the ID_entradas.

The form displays the main data, and below it is an action button to fill in the data from the dependent form.

How can I prevent the user from adding data from the dependent form without filling in the data from the main form?

Thanks!!

Please take a look at the following post thread , suggested in the “AI Suggested Topis” of your post.

Basically, make the child table’s system generated reverse reference column to show only if the (required ) fields in the parent form are not blank.

So in your case, the show_if of the reverse reference column can be something like
AND(
ISNOTBLANK([Cliente],
ISNOTBLANK([Almacen]),
ISNOTBALNK([Comentario])
ISNOTBLANK([Any other column(s) in the form you want to include])

)

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.