Forum Discussion
vijaysingh
Qrew Cadet
My 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
------------------------------
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__You
5 years agoQrew Legend
On 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
------------------------------
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
------------------------------- MarkShnier__You5 years agoQrew LegendYes, if you have too many error it will turn off the Automations and send you an email saying that it did that. I'm not sure exactly the defination of "too many". It has to do with too many over a given period.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- vijaysingh5 years agoQrew CadetI am able to achieve this by automation firing by setting up the flag value ..
But it didn't work using the FORM rule without checkbox selection also.. Not sure if we can not assign a formula field value to the PK column using automation.
Here is the logic for formula field- It's combination of "Milestone Name" value with "Related Batch" using operator "_" Related Batch is being decided based on another field..
[Milestone Name]&"_"&
If([Milestone Level - Benavides] = "Batch",ToText([Related Batch]),
If([Milestone Level - Benavides] = "Project",[Related Project],
If([Milestone Level - Benavides] = "Site",ToText([Related Site])
)))
------------------------------
vijay singh
------------------------------- MarkShnier__You5 years agoQrew LegendDo you have that formula field on the form? I have found that calculated fields need to be on the form to have them update
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- vijaysingh5 years agoQrew CadetNo. It was not their on the form.. I added and it worked.. Thanks for all your help Mark . Appreciate it
------------------------------
vijay singh
------------------------------