Thanks for both assistance. I had solved the problem. I use the arrayformula in spreadsheet as “=ArrayFormula(“C” & Text(SEQUENCE(MAX(ROW(Customer!A2:A)*(Customer!A2:A<>”"))-1),“000000”))"

Thanks for your advice. My scenario is generating Customer like C000001. The function above can provide ID in number format. If in spreadsheet, I used “TEXT” function, not like “Sequence” function, it will not be copied in new record. If in AppSheet,...

I’m a newbie in here. Your Tips are helpful. But How to update the Text Column in spreadsheet? I used the Text function in spreadsheet. It is not working. I tried to use initial value in appsheet, but no luck. Thanks in advance. Richard