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

(T M) #1

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

#2

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) #3

Thank you SO much @Lynn ! Much appreciated!