ENUM or Yes/No type that will input result into a different value

[lrackevin11]

Hi Good day!

I badly need help. How can I create this type of selection that will result into a data that will be recorded as "For Approval" and "Rejected". If the Approve button is saved, the result in the database should be recorded as "For Approval" and "Rejected" for reject?

[dbaum]

In your data source, create another column and in AppSheet enter in the column's App formula property an expression that returns the value you want. For example:

SWITCH(
 [Status], 
 "Approve", "For Approval", 
 "Reject", "Rejected", 
 ""
)