Creating formula field based on another text field and a sequential number
In my table i would like to have field say designno. that takes value from another text field and append it together with an autogenrated sequential number. How can i do this ? I tried it using text ...
You have come across something which is a little involved but can be done.
Mark was right about the Record ID# not having been created yet so what to do?
Well we can create a formula that concatenates the pieces we wish to put together and then a form rule to fire when the record is created that puts that formula into a local scala field. Temporarily we are using 000000 as the Record ID#. Next a Pipeline wakes up, recognizes that the key field has 000000 contained and it fires to go back and update the key field to its new value.
We need a Pipeline that recognizes the record's creation and fires to write the new formula value into the key field.
It is a lot but the following video goes through the process of setting it up.
We cover topics like this during out daily M-F "Office Hours" webinars held at 1pm Eastern. These are open Q&A sessions where we model possible solutions to business challenges. https://quickbase.com/webinars/.
When you are adding a record, there has not been a Record ID# created so we have to use a temporary stand in to satisfy that a key field has to be unique. So we concatenated the first 3 letters of the company name with 6 zeros in a formula. When the record is saved a form rule moves that temporary key value into the Key Field. This will remain as the key field until the Pipeline updates it with the new knowledge of the records Record ID#.
Feel free to pop into any of my, "Office Hours" webinars held M-F at 1pm Eastern time and we can discuss further.
