Hello - I have a list of tasks in my spreadsheet and I want Appsheet to generate UNIQUE() as key column. Currently the ID column is blank. Under data, I have set ID column formula = UNIQUE(). But when I save, the error message tells me that I cannot have a formula as key.
These articles says that Appsheet does support UNIQUE() as a way to generate pseudo-keys, but the system is telling me I cannot have a formula. I’m confused. Please help, thank you!