# "Add row" Zapier not bringing in user profile data

**URL:** <https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551>\
**Category:** Report a Bug\
**Created:** [September 30, 2020, 3:30am UTC](https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551 "2020-09-30T03:30:56Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![C\_Fitz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/c_fitz/32/14436_2.png) [@C\_Fitz](https://community.glideapps.com/u/C_Fitz)\
**Post date:** [September 30, 2020, 3:30am UTC](https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551/1 "2020-09-30T03:30:56Z")

</div>

My app’s URL: [https://go.glideapps.com/app/k9nW8HCBywCLuDryKgga](https://go.glideapps.com/app/k9nW8HCBywCLuDryKgga)

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.

Can anyone help?

-CF

 ![Screen Shot 2020-09-29 at 8.30.21 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c4b6a356f956919948d1a139b87d0ba8f0b793e2.png)

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [September 30, 2020, 12:27pm UTC](https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551/2 "2020-09-30T12:27:24Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![C\_Fitz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/c_fitz/32/14436_2.png) [@C\_Fitz](https://community.glideapps.com/u/C_Fitz)\
**Post date:** [October 3, 2020, 8:24pm UTC](https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551/3 "2020-10-03T20:24:38Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 3, 2020, 10:15pm UTC](https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551/4 "2020-10-03T22:15:36Z")

</div>

Can you try making a template of the user value as a column in the source sheet of the page you’re viewing, then pass that to Zapier instead?

---

<div class="post-metadata">

**Author:** ![C\_Fitz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/c_fitz/32/14436_2.png) [@C\_Fitz](https://community.glideapps.com/u/C_Fitz)\
**Post date:** [October 5, 2020, 5:29pm UTC](https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551/5 "2020-10-05T17:29:46Z")

</div>

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: ![Screen Shot 2020-10-05 at 10.29.28 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1debfb56551fea2eda8e4418fc12775bcb90130c.png) ) To me, this really seems like a bug.

---

<div class="post-metadata">

**Author:** ![C\_Fitz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/c_fitz/32/14436_2.png) [@C\_Fitz](https://community.glideapps.com/u/C_Fitz)\
**Post date:** [October 5, 2020, 5:35pm UTC](https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551/6 "2020-10-05T17:35:15Z")

</div>

Here’s a screenshot to show what the google sheet looks like after triggering the Zap/clicking the button a few times on different pages.  
 ![Screen Shot 2020-10-05 at 10.31.26 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5dde78c213ab9155fff579cf6053c792c5c355a4.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 6, 2020, 1:07am UTC](https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551/7 "2020-10-06T01:07:02Z")

</div>

The template column allows you to select a user-associated value. Can you try and let me know?

---

<div class="post-metadata">

**Author:** ![C\_Fitz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/c_fitz/32/14436_2.png) [@C\_Fitz](https://community.glideapps.com/u/C_Fitz)\
**Post date:** [October 6, 2020, 2:23am UTC](https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551/8 "2020-10-06T02:23:52Z")

</div>

Ahh, I didn’t know what a ‘template column’ was but I just implemented it for the first time and it worked! Thank you!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 8, 2024, 6:04am UTC](https://community.glideapps.com/t/add-row-zapier-not-bringing-in-user-profile-data/16551/9 "2024-05-08T06:04:55Z")

</div>


