Question

Updating multiple columns in Google Sheets based on Glide form answers?

  • 20 March 2022
  • 1 reply
  • 234 views

I’m trying to create a super simple app with Glide and Zap that lets me record fertilizer sprays throughout the year. I’m using a form from glide to input the info in a google sheet and gathering daily weather data in another worksheet. The records need to have both weather and spray info in one place. 

So I have one worksheet that has Daily JSON updates with weather, and another with the form answers from the app. There’s row Ids on everything, and the spray info updates nicely. The weather I thought would be fairly easy to update, because its always the same row A (the information changes daily - it might make a difference in record history but I don’t know yet, haven’t been able to test) 

But I haven’t been able to grab any information from the weather worksheet and put it into the spray record sheet. When I do the “lookup spreadsheet row in google sheets” I get the “Bargle. We had trouble getting a matching spreadsheet row. :-(Error details:
Nothing could be found for the search.”  

The sheet looks like: 

So Row 2 is updated every day. 

The spray Record sheet so far looks like this: 

 

The first row where it actually worked is when I used the additional value option and used 8.4 to look up the values. But a static value won’t work every time since the weather changes daily.  Also the other values were just “value in column A” Value in column B and not the actual inputted information. 

Closest I’ve come is just making a formula for a static row but sheets inputs it as something like =’Weather!$C$2 and that little apostrophe is all sorts of trouble. 

 

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +11

Hey @stumpystumped, welcome to the Community!

Hmm, it sounds like you’ve got two different Zaps that are adding information into separate Google Sheet worksheets that you want to have combined into a single worksheet in the same row is that correct? 

If so, I’m wondering if it might be easier to have a worksheet that uses the IMPORTRANGE function for Google Sheets to import the data from the separate worksheets that the Zaps are connected to. That should allow you to combine data from the separate worksheets into that single worksheet. You can find out more about how to use IMPORTRANGE here: Docs Editors Help > IMPORTRANGE

Hopefully that will do the trick! :relaxed: