UNIQUEID removed when saving

[shimodabt]

I want to use UNIQUEID to generate an ID as an initial value for a time sheet application.

The ID field initial value field get back to blank after I save the app after adding UNIQUEID() in the initial value field. Any reason why I am having this behaviour?

[Steve]

Please post screenshots from before and after.

[shimodabt]

[Steve]

The app editor is telling you exactly what’s wrong. What don’ you understand?

[shimodabt]

I am really sorry to bother you with my rookie question @steve. You must be looking for meaningful challenges today. I understand from the message that there should not be a formula in the spreed sheet. To make sure it is the case I have deleted and recreated the column in the spreadsheet but I am getting the same error.

[Marc_Dillon · Accepted solution]

shimodabt:

To make sure it is the case I have deleted and recreated the column in the spreadsheet but I am getting the same error.

Unless you Regenerated as well, you’ll probably also need to go into that columns definition and delete anything out of the Spreadsheet Formula field.

[shimodabt]

Interesting. It seems a formula was still present in this field after I have deleted and recreated the column and regenerated the table structure. Thanks @Marc_Dillon for pointing the field for me!

[Marc_Dillon]

Try turning the Editable flag on for [ID].

[shimodabt]

Thanks @marc_dillon for this suggestion. Unfortunately it does not work complaining about the sheet formula.