Forum Discussion
KirkTrachy1
Qrew Assistant Captain
Hi Aswin:
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/.
------------------------------
Kirk Trachy , Senior Solutions Consultant
QuickBase | 603-674-5454 M | ktrachy@quickbase.com
------------------------------
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/.
------------------------------
Kirk Trachy , Senior Solutions Consultant
QuickBase | 603-674-5454 M | ktrachy@quickbase.com
------------------------------
AswinBabu
4 years agoQrew Member
This is a good solution. Will try it out
--
Regards
Aswin Babu