I am building an app and when a user create a new entry I auto compute a column (client_code) from the content of a column (client_id). Here is an example of what I would like:
client_id = 8, client_code = HL2020-008
client_id = 18, client_code = HL2020-018
client_id = 158, client_code = HL2020-158
I can easly make the concatenation (“HL2020”&client_id) however, I would like to format the number “8” in “008”. So far, I made it with ifs blocks (if client_id<10, if client_id<100, if client_id<1000…) but I was wondering if there was a easier way of doing it.
Thank you very much,