Generate a sequential reference for entries

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

1 Like

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

2 Likes

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

3 Likes

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

3 Likes

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