I was referring to the below - what happens if you swap those actions so that the Set Column Values comes first?
Bid Proposals Helper is a Single Row table that has the value of the Final JSON which is what I’m trying to set in my user profile row. So it won’t help if I swap.
One discrepancy I notice is, although there are 2 records in Bid Proposals, when I click on the Data below, initially I see only 1. Sometimes I see both. Not sure why.
One point that I missed to mention is, I “Show new screen” and map it to Bid Proposals table when the user clicks on Verify & Send email button. It’s not a form screen.
So you are trying to get a value from the relation and write it to the user table? I see you have a relation, which is a link to an entire row but I don’t see any Lookup columns to retrieve any specific column values out of the relation.
2 Likes
Jesus! What was I thinking, How on earth did I miss that? 
Thank you sooo much @Jeff_Hager !
1 Like
@ThinhDinh - I made decent progress with invoking the zap where I send the JSON Payload and the number of JSON Objects in it as 2 values to my Zap.
I wrote a 3 step Zap where I use Code by Zap (using Python) where I put the objects in a dictionary and then invoke Send Outbound email by Zapier.
I’ve a problem sending this JSON Payload to my Zap as when I trigger the action from my Glide app and look at the Zap run, the value corresponding to JSON Payload doesn’t seem to be present. I tried to pass a lookup column, then changed to a Single value column, a text column. No luck!
My Zap definition from Glide:
This is that single value column that I set in my Zap trigger:
And when I click on the button that triggers this Glide action in my app, It calls the Zap and fails there with the following:
Though I pass 2 values, in the zap output only Value 2 is passed.
Anything catches anybody’s eye?
Just to test the zap, I tested the entire step by hardcoding the same JSON in my Code By Zap test and it neatly picks up each JSON Object and sends an email as I expect to.
This is my code test in Zap:
This is my Email step in Zap:
@ThinhDinh - This one is complete now. With Trigger Webhook suggestion that you gave on the other thread, I was able to complete this step.
I shall very soon write a post on how to perform sending multiple personalized emails in one click of a button using Zapier. Once done, will share it here as well. Thanks much for all the help!
3 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.