Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 13, 2018 11:47 PM
Sorry if this has been asked before. Is it possible to add logic such as. IF column X is “yes” then populate a autonumber column, ELSE leave blank? Thanks.
May 14, 2018 12:19 AM
An auto number field is pre-populated.
What you will want to do is to create a new column eg “auto 2” to achieve the functionality you are wanting
The column “auto 2” will be of type formula.
The formula will be
IF(X=“yes”, AutonumberColumn, “”)
Where AutonumberColumn is your column of type “auto number”
You will also want to probably hide the column “AutonumberColumn” in your view
May 14, 2018 03:20 AM
Cheers, thanks for that.
That method does mean though that the Autonumber column will increment up even for records that don’t satisfy the IF statement though - any way to avoid this?
The scenario I am thinking about is for assigning bib numbers at a sporting event from one member database (as in not all members will be attending the event). Its useful for me to not have the autonumber increment up for members not attending since then I don’t have to print so many bibs.
I’ve played around adding the autonumber column in a filtered view but autonumber still populates all records in the table.
Thanks for your help and suggestions.
May 14, 2018 06:53 AM
The easiest way to accomplish what you want is, when you are ready to print bibs,
'Save'
.'Save'
.This will causes the autonumber field to be regenerated. Since the table has been sorted to list attending members first, they receive numbers beginning with 1,2,3..'
. Do whatever you do to print the bib numbers (export them, print using the Page Designer Block, etc.).
If you are using the autonumber field for something where you need some sort of persistence, create a second autonumber field called {Bib}
that you can rewrite for each event.
May 15, 2018 04:10 PM
Cheers, I’ll do that - thanks for your help.