Forum Discussion
vijaysingh
Qrew Cadet
Thanks Mark..
I will try the Remainder option as table to table import won't work in my case ..
Also another quick question if you can help - Was trying to create an automation to populate a TEXT field which is also a Primary Key in that table..This column was made PK as need to join another table using this column. Column value could be derived by combining another 2 columns in the same table so no need to make it for manual entry for the users to fill in.
Here is the challenge-
Initially i thought of creating an action where if a record is added in that table then modify this column with another formula field (contains calculated PK value), but i don't see this PK column in the modify section to get formula field value assign to it.
Later i though of creating 2 actions, add a record with PK column value from formula field and delete the already added record (PK column was set to populate with default value).. This works but then i am unnecessarily creating an extra record here which is triggering other actions too..
So thought of checking if there is a easy way to create an automation to update the PK column from a formula field.
Thanks,
Vijay
------------------------------
vijay singh
------------------------------
I will try the Remainder option as table to table import won't work in my case ..
Also another quick question if you can help - Was trying to create an automation to populate a TEXT field which is also a Primary Key in that table..This column was made PK as need to join another table using this column. Column value could be derived by combining another 2 columns in the same table so no need to make it for manual entry for the users to fill in.
Here is the challenge-
Initially i thought of creating an action where if a record is added in that table then modify this column with another formula field (contains calculated PK value), but i don't see this PK column in the modify section to get formula field value assign to it.
Later i though of creating 2 actions, add a record with PK column value from formula field and delete the already added record (PK column was set to populate with default value).. This works but then i am unnecessarily creating an extra record here which is triggering other actions too..
So thought of checking if there is a easy way to create an automation to update the PK column from a formula field.
Thanks,
Vijay
------------------------------
vijay singh
------------------------------
MarkShnier__You
5 years agoQrew Legend
Automations, Actions and Webhooks all fire after the record is saved. The only way to pre-populate a field is using form rules, as they can populate a field at all times and also "when the record is saved".
So if the data entry is manual on a form, then you can use a form rule, alternatively, your solution sounds like it would work, save the record with a temporary Key fields and then use an Automation to recreate the record with a correct Key field and then delete the temporary one.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
So if the data entry is manual on a form, then you can use a form rule, alternatively, your solution sounds like it would work, save the record with a temporary Key fields and then use an Automation to recreate the record with a correct Key field and then delete the temporary one.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- vijaysingh5 years agoQrew CadetMy solution is working - recreate the record with a correct Key field and then delete the temporary one
Just that there are couple of other actions on a delete and new entry in the table and those are being triggered due to this which i don't want if a record is added/deleted after this automation run. If there is anyway to handle this?
I had tried the form way of handling this but it didn't work. Here is what i had used
Secondly, i can see automation is getting turned off automatically. Is this because of Error count is increasing or any other reason.
------------------------------
vijay singh
------------------------------- MarkShnier__You5 years agoQrew LegendOn the form uncheck that checkbox at the bottom of the screen shot. That should fix the form rule. I also typically include a Condition in the form rule to only fire when those two values are not already the same.
As for the other Automations firing, you could flag the record initially created by the Automation so that you could then add a filter to the other Automations to not trigger on those ones.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- vijaysingh5 years agoQrew CadetThanks Mark for quick responses .. Will try both the options you suggested.
Any update on other question i mentioned- Secondly, i can see automation is getting turned off automatically. Is this because of Error count is increasing or any other reason.
------------------------------
vijay singh
------------------------------