Hello! I made a super simple app to track exp...

T_M
Participant I

Hello! I made a super simple app to track expenses. It’s just 4 colums: Date, Item, Amount and Type.

The problem is, right now my Key column is the Date column which won’t work because there will be multiple entries on a given date.

So my question is, what would be the best type of key to use for this “Key” column?

Also, I don’t want it to be visible on the app so is there a way to keep it hidden?

Thanks in advance! Tim

0 2 294
2 REPLIES 2

Lynn
Participant V

Hi +Tim Murphy , just insert another column, call it Unique ID or similar and set its initial value to UNIQUEID(). You can mark that column as the key and

hidden in the column editor. data>columns.

T_M
Participant I

Thank you SO much @Lynn ! Much appreciated!

Top Labels in this Space