How to stop new rows while adding information to spreadsheet?
Howdy, y’all.
Can anyone help me figure out how to stop this from happening? I am trying to get a single user’s information to be collected in a single row.
I’ve tried both Insert Row and Update Row, and all of my Fields are named appropriately (I believe). Can anyone show me a simple walkthrough? I’m new to using ManyChat, and I likely need to have my hand held through this.
Additionally, any idea why the “Worker Experience” column will never show any input data? Perhaps this is a symptom of the same issue affecting this creation of a new row for each user input; but again, I am not sure.
Thank you in advance!
Isaac
Page 1 / 1
Hey, Issac/ @TepatWork!
Could you send a screenshot of your Google Sheet Action? There's a huge chance that the problem lies there.
For example, this is how it must look to work as yuo expect:
You'll use the Update Row action
The Lookup Column acts as an ID. And this must be stored to the contact in some Custom Field or you use some system field to use as ID (in the image below, I have a column called IG_User that receives the Instagram username (if no exists) or updates the corresponding columns (if it exists).
I don't see something that works like an ID in your table.
Following this logic, it should work and update the data instead of always creating new lines.
Hope this helps!
Hi Fabio,
@fabio.gaulke
Thanks for jumping on to help me with this. I believe I implemented your changes correctly, and yet the problem persists. I seem to be missing something. As requested, here’s a screenshot of my Google Sheets Action. This is an updated version of the Google Sheets Action, based on your suggestion. I’ve also attached my flow, so you can see what I’ve done; and perhaps I’ve misused the function.
As well, you will note that my spreadsheet now has a “oWorker - ID]” column. This was in response to your mention for the necessity for an ID on the table, but it has only blank cells with no formatting.
Finally, the problem with “ Worker - Experience]” not being added to the spreadsheet persists, and I’m at a loss as to why.
Please forgive such a long response, I’m still trying to wrap my head around how this program works.
Thanks again in advance,
Isaac
I figured it out. Thank you very much for your assistance.
Hi, @TepatWork!
Glad you've got it working!
The problem was here:
The Lookup Value will be used to search if it exists in the Lookup Column.
In this case, it was looking for the Workers Location at the Workers Name column.