Hi! I have a form to fill, I want to fill or scan the first field, and then automatically fill in other fields from the lookup in another table. I don’t want to show the other fields before the first field fills out. how can i to that? Thanks!
You can use Show_if with a proper condition to hide the other columns
as long as the first mandatory column is blank. You could use ISBLANK() function.
Note that Show_If may affect a column’s visibility if UX > Options > FORMS > Apply show-if constraints universally is ON.
As an alternative to Show_If, you could instead consider Editable_If.