I would like to create a connection between a Cognito entry and a Google sheet row.
I managed to build the new entry link between Cognito and Google sheets but now I want to update a changed field from Cognito to update the field in Google sheet.
Moreover I would like to know if its possible to have an entry from Cognito to be connected to a specific row in Google sheets (lets say entry Project 1 from Cognito is connected to Google sheet row Project 1 with all the fields following in the following columns.
Does anyone know if this is possible?
Thanks.
Rutger
Welcome to the Make community!
To be able to know which row to update, you’ll need to use a search module to get the row number containing the data you want to replace. Can you see which Google sheets search module would help achieve that?
samliew – request private consultation
Join the unofficial Make Discord server to chat with us!
1 Like
Hi Samliew,
Thank you.
I wouldn’t know how to achieve this. Could you give me an advise in the right direction?
Rutger
The available search modules for Google Sheets are:
Which one do you think will return a row number based on what you’re searching for, and give that a try.
If you need further assistance, please provide the following:
- screenshot of module fields
- output bundle of tried module
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
1 Like
thanks again, here are my screenshots.
This is what my form looks like in Cognito:
This is what want to achieve in Google sheets:
This is what a submitted entry looks like:
So my Client and Project fields are the ID for a project. I managed to create a row line in sheets after a submisson but I would like to have (for instance) change the date of a Client Project entry after a submission in Cognito and have the Google sheets update the Date field of that specific Client Project.
Hope I made myself clear.
Welcome to the Make community!
Yes, that is possible. You’ll need a minimum of three modules:
Give it a go and let us know if you have any issues!
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
1 Like
I’ll look into this.
One question, is it correct the first module is ‘watch new entries’ instead of a ‘watch updates’?
thanks fo all your help.
Yes, you did say you’re watching a new Cognito entry right?
1 Like
No that part has been done.
its more about changing an entry after submission:
So my Client and Project fields are the ID for a project. I managed to create a row line in sheets after a submisson but I would like to have (for instance) change the date of a Client Project entry after a submission in Cognito and have the Google sheets update the Date field of that specific Client Project.
Hope I made myself clear, sorry for the mix-up
In that case give Watch Updates a try – I don’t have Cognito Forms to test it on so I’m not sure what that module outputs.
1 Like
I will have a look, thanks for the help.
No problem, glad I could help!
1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
others can save time when catching up with the latest activity here, and
- allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
Links
Here are some useful links and guides to help you get started and learn more on how to use the Make platform, apps, and app modules —
General
Help Center Basics
Articles & Videos
Feature Requests & Suggestions
samliew – request private consultation
Join the unofficial Make Discord server to chat with us!
1 Like
