In one of ENUM field, I have only one ENUM va...

(rajoj maharjan) #1

In one of ENUM field, I have only one ENUM value “Complete”. But if the Condition is true, the field should appear(which I did it) and Field is must and if not, this field should not appear and “N/A” value should be stored automatically in google sheet.

How do I do that?

(Tony Fader) #2

@rajoj_maharjan I don’t quite understand the logic you’re trying to get at.

But usually in these scenarios, it’s best to create two separate columns. The first column would be what is displayed to the user (in this case, a single button that says Complete). The second column would use an App Formula to compute the value you want to store based on it. Maybe something like IF([Your Enum Column] = Complete, Complete, “N/A”).

(Stephen Mattison) #3

Why not set up more choices like Not Started, In Progress, Delayed. This will allow much more detailed and useful data, sorting/grouping in your app and Sheet.

(Tony Fader) #4

@Stephen_Mattison Good recommendation

(rajoj maharjan) #5

@Stephen_Mattison This field optional but when condition is true, engineer must preform that task. Thanks for suggestion.

(rajoj maharjan) #6

@tony Sounds better… I will give a try… Thanks for the suggestion.

(Tony Fader) #7

@rajoj_maharjan Also, make the second column hidden (since it’s for your eyes only)