Appsheet Running Formula

[desmond_lee]

Hello Expertise

Anybody knows why there is a repeating running number at RIGHT(“000000”&([_RowNumber]-1),5) Appsheet formula? See the repeating T00037_NP011_05/18/2022 08:38:40 & T00037_979_05/18/2022 11:46:34. I joining the pure number with a text ID i.e. [REPORTER ID]. I think this is the problem after ID NP011 (Text) submision another a pure number ID 979 submiting cause appsheet to get confuse these are 2 types of format entry if I am not wrong.

Appsheet Formula : "T"&RIGHT(“000000”&([_RowNumber]-1),5)&"_"&[REPORTER ID]&"_"&[TIMESTAMP_REPORTED]

Thanks

[Aurelien]

Hi @desmond_lee 

I have no idea of why this isn't working. According to your screenshot, I would consider writing instead:

"T"&RIGHT(“000000”&([ROW]-1),5)&"_"&[REPORTER ID]&"_"&[TIMESTAMP_REPORTED]

 Mostly, I would avoid any expression that relates to row or row number, because it is unstable for a key-column.

Here is a post about that:

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Serial-Numbers-If-You-Must/m-p/286300

You might prefer using UNIQUEID() instead.

For reference:

https://help.appsheet.com/en/articles/2357317-uniqueid

[desmond_lee]

How do I put convert all entry in text at the string [REPORTER ID] column? 

"T"&RIGHT(“000000”&([_RowNumber]-1),5)&"_"&[REPORTER ID]&"_"&[TIMESTAMP_REPORTED]

[desmond_lee · Accepted solution]

Let me try this and see it works or not.

"T"&RIGHT(“000000”&([_RowNumber]-1),5)&"_"&TEXT([REPORTER ID])&"_"&[TIMESTAMP_REPORTED]

[Aurelien]

"How do I put convert all entry in text at the string [REPORTER ID] column?"

If your column type is Text both in your spreadsheet and your app editor, it should be ok.

[desmond_lee]

Its works !