To start with, thanks to everyone that’s helped create such a great app building platform.
I can’t share the original app due to personal data, but here is a demo app.
I’m trying to use the top ‘-’ (hyphen) option in a choice component in the edit view, to clear the cell and save the result as empty. I have multiple (4) choices the user can make in this particular edit screen.
I can select ‘done’ to save if all but 1 are cleared, but not if all of them are as I often require. ‘Done’ is greyed out when they are all cleared, even though the ‘required’ option is not selected.
I tried using ‘delete item’, but this clears the WHOLE row in the sheet, not just the 4 cells i need, breaking functionality. Plus, even if that worked, it would be confusing wording to the user.
Is this a bug or am I doing something wrong? Is there a solution anyone can share?
I would be grateful for any help anyone can give.
P.s. What does the hyphen option in a choice actually save to the sheet? An ISBLANK function doesn’t return true, but it looks empty. Would be useful to know for future formula creation (mmmm, formulas )