Generate a sequential reference for entries

Get Help
1

Hi community

I am new to Fibery.

I would like to have a field that automatically generates a sequential reference number (as in GW001, GW002 … GW999) for entries in a database.

How do i go about this please?

Thanks in advance

2

Can you use the automatically-generated “Public Id” field?

3

"GW" + Right("00" + [Public Id],3)

4

@Chr1sG 's suggestion would be the formula of a new Formula Field you can create in the DB.

5

Perfect guys - sorted it out. thanks for the immediate help.