Hi. I created an app that has a column which ...

Hi. I created an app that has a column which generates control numbers. Basically it works by concatenating the first three letters of the user email address, and the value of another column which counts how many requests the user has made. Basically if my email address is mikey@gmail.com and I am creating my third request, the control number should be MIK3. It works so far but we have a user with the email address mark**@gmail.com, what happens is appsheet converts the control number into a date. For example his first request, MAR1 is converted into Mar-1 in the back end(database) which just comes out as numbers in the front end. Is there any possible workaround to this without changing the ctrl number format? Thanks in advance!

0 3 321
3 REPLIES 3

Set the column type to โ€œPlain Textโ€ on your spreadsheet and it should do the trick.

@Aleksi_Alkio wow itโ€™s so obvious but I didnโ€™t notice it. Thank you so much Iโ€™ve been getting frustrated for hours about this!

Youโ€™re welcome

Top Labels in this Space