Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Enum list not letting me add a value?

Hi guys - 

I have two relevant tables: DB_Transactions and DB_Rules. The data sources are Google Sheets. Within DB_Transactions is a non-identifying column, PayeeName. Within DB_Rules is a column "NewPayeeName". 

In a form for DB_Rules, I would like NewPayeeName to be a dropdown with the values from DB_Transactions[PayeeName], with the ability to put in a value that is new/not in DB_Transactions[PayeeName]. 

This is the configuration of the field: 

1billyfw_0-1724595047930.png

But in the Form, it won't let me add a new value: 

1billyfw_1-1724595133364.png

1billyfw_2-1724595155947.png

When I click "Done" I return to the form but the field is blank. 

Any help would be greatly appreciated. Thanks a lot!

Billy

 

Solved Solved
0 4 362
1 ACCEPTED SOLUTION

Instead of valid_if , please try moving the expresion to suggested_values setting.

Valid_if imposes hard constraint whereas suggested_values imposes soft constraint that will allow the user to add new values as well.

View solution in original post

4 REPLIES 4
Top Labels in this Space