Transform value from database

Wappler General How To
#1

Hello

How do I change an id coming from the database like 1 to 00001?

#2

There is no such integer like 00001.

You can transform ID coming from DB to text and add whatever you want.

#3

You can use the Data Formatter - Text Pad formatter to add characters in front.

image
image629×635 34.4 KB

Just make sure the 0 is entered as string:

aa.pad(5, '0', 'left')