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

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?

0 6 355
6 REPLIES 6

tony1
Participant V

@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”).

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.

tony1
Participant V

@Stephen_Mattison Good recommendation

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

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

tony1
Participant V

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

Top Labels in this Space