I am having a problem connecting 2 records on different table. I made an illustration below.
Here is the scenario, process flow: Reference Table, User Table, Template Table.
Create Reference
Create a User then connect it to Reference (this works because in the form there is a name field which is working on pipe (Tadabase Rest API - Filter by a Single Field) and the option to select a form is available.
Create Template
This template has a child record, I used the pipe (Tadabase Record Utilities - Import Child Records) to copy the child record.
In the Template record, I created a Text Formula Field (Template ID) and upon creating the Template, I need to connect the User to the Newly Created Temlate and vice versa.
So connected the User to the Template is ok, however, connecting the newly created template to the user is not working.
I believe the issue that you’re encountering is the connected field of the tax formula. Based upon how Tadabase runs record rules, table, rules, form, rules, etc. the text formula field is not being an updated since it’s been a run at the same time as everything else.
I believe the issue that you’re encountering is the connected field of the tax formula. Based upon how Tadabase runs record rules, table, rules, form, rules, etc. the text formula field is not being an updated since it’s been run at the same time as everything else.
Not knowing exactly what you’re attempting to execute. This may be a example of usingmake.com or some other external platform to be able to run sequentially the build out of your different forms and records.
Not knowing exactly what you’re attempting to execute. This may be an example of Make.com or some other external platform to be able to run sequentially the build out of your different forms and records.
Typically, you already have users created and assigned them to a record, but it sounds like you’re attempting to create a record and then create a user, and then create a child record of the original record. This becomes complex in logic and one of the classic reasons of why using an external platform such as Zappier or Make will aid in sequentially running your activities.
I may need a bit of clarification because I’m not fully understanding the issue with the text formula field. The main problem is:
- User gets connected to the Template
But I can’t get the newly created Template to connect back to that User
I’m doing this all inside Tadabase and was hoping it could be done without Make/Zapier. Is the reason it’s failing because the Text Formula field (Template ID) does not update fast enough when the record rules run? And if so, is there a workaround directly inside Tadabase, such as delaying a rule, triggering an update, or using a different field instead of a formula?
Just to confirm the flow:
Create Reference
Create User and connect to Reference
Create Template
Copy Template child records via pipe
Connect User to Template (ok)
Connect Template back to User (this part is failing)
If you have any suggestions on how to do this internally within Tadabase before using Make.com or Zapier, I’d appreciate it.