I’ve got a button called “Invite to Spar 2” which appears on the each of the detail pages on my app. When a user clicks that button, I want a new row to populate on a tab called “Invitations” on my Google Sheet. The new row should consist of 2 values, 1 in column A and 1 in column B. I want the value in column A to be the current user’s name and the value of column B to be the name tied to the details page where the user clicked the button.
I’ve currently got a Zapier set up that performs the action in column B perfectly, however the value in column A is always blank. I’ve tried changing the Zapier inputs for column A to different user-associated and detail-page-associated values. The user-associated values are always blank. The detail-page-associated values always flow through.
Use a button with ‘show form’ action.
Pass the current user’s email as the value for column 1.
Use the name from the detail screen as the value for column 2.
I don’t want the user to have to input any data–I want them to be able to click the button and exactly the functionality that I initially described occurs: a column on a google sheet is populated with certain values. I don’t believe the ‘show form’ action will work here for that reason.
Hi Thinh–I will still need a way to associate the current user in order to correctly pass that value. Unless I’m missing something, the only way for me to pass a value associate with the current user, is to use the functionality built into GlideApps to select a user-associated value. (I.e. Values with this icon: ) To me, this really seems like a bug.
) To me, this really seems like a bug.