Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoWhoa, you mean to edit the formula? Crazy ask and I'm thinking that there must be a better way to have this be table driven and have the Automation just update a field for Related Project Manager or something. Maybe if you explain your use case I can suggest another approach.
But if you are technical, and only a bit crazy, then maybe a crazy ask like that is not completely crazy. Using a Pipeline and the new set of RESTful APIs, you can probably edit a formula, but even if that was technically possible that sounds like a lot of heavy lifting as opposed to a different designed for how the User is determined.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
But if you are technical, and only a bit crazy, then maybe a crazy ask like that is not completely crazy. Using a Pipeline and the new set of RESTful APIs, you can probably edit a formula, but even if that was technically possible that sounds like a lot of heavy lifting as opposed to a different designed for how the User is determined.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JennaOdom
5 years agoQrew Member
Actually, I believe I can just use a user field to make the change.
I am trying to say when a text multiple choice field equals a certain choice, change the user field to a certain user. I have started the automation trigger, but the action doesn't allow me to see a drop-down of the list of users to choose from.
------------------------------
Jenna Odom
------------------------------
I am trying to say when a text multiple choice field equals a certain choice, change the user field to a certain user. I have started the automation trigger, but the action doesn't allow me to see a drop-down of the list of users to choose from.
------------------------------
Jenna Odom
------------------------------
- MarkShnier__You5 years ago
Qrew Legend
OK that makes more sense. Does the Automation allow you to type in an email address? I have not tested that myself.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- JennaOdom5 years agoQrew MemberThis is the action:
ID is equal to the value ID Trigger: Loans ID
and then below that: field = assignee LS2 from CRM, source = type a value, value = specific email address
Does that logic make sense?
------------------------------
Jenna Odom
------------------------------- MarkShnier__You5 years ago
Qrew Legend
yes, I think that should work.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------