Formula evaluation for column values in UX>Localize

[Erwin_John_Arag]

I wanted to hide the Save or Submit button depending on some column values.

In UX>Localize, I created formula:

IF(
AND(CONTEXT(“View”)=“Create_PIS”,ISBLANK(PIS_records[Consent statement response])), " ",
“Submit”)

This will check if the user is in a certain view and column ‘Consent statement response’ is blank. Then Submit will be hidden.

However, it seems that it cannot read the column value while the form is still active and not technically submitted. Any workarounds?

The submit button should only appear on the last page of the form, or if all required fields have already been filled.

[Marc_Dillon]

Erwin_John_Aragon:

IF(
AND(CONTEXT(“View”)=“Create_PIS”,ISBLANK(PIS_records[Consent statement response])), " ",
“Submit”)

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…

---

---

Regardless, you should probably be pursuing data validation, instead of trying to hide the submit button on your Form.

help.appsheet.com

Valid_If Column Constraint

How to check if a given form input is valid based on its type.