I have a very complicated form with many connected fields that is awesome! I can see all that connected data from the form in the details view or the grid view when I switch on those connected fields. Lovely. I want that connected data to move to a new row in google sheets. Unfortunately flow only moves the data entered directly into the form or table for that form. I want to also move the connected data.
Here is a simplified example.
In my form these three connected forms appear.
organization (connected fields include organization name and corporate website)
organization location (results depend on organization selected. Fields include location website, physical address, location phone, location email)
employee (results limited to organization location selected. Fields include name, title, employee email, employee phone, etc.)
In the the form’s table record the results would look like
organization = Bob’s Tool Hut3.
location = Smithsville
employee = Rene Robinson
The • details view of grid view could include all that chewy connected goodiness
Hi Lou,
I haven’t tried Flows yet, and would typically use Make.com, but could you use a number of Text Formula fields on the form’s record to pull through the relevant values from the conected record types. So a TF field for Organisation Website, another for Organisation email and so on. Then all of the values you want are on one record and you should be able to add them to your G Sheet row.
Hope that makes sense / helps!
Hi @LouBru - I saw your post yesterday and have since seen that my good friend and colleague @Hugo has jumped in to offer some advice.
I decided this weekend, that I would set up a simple application to see if I could get this working using Flows. Like Hugo, I’ve been using Make for many years, so I thought I’d build it in Make first to ensure I got it working and then transpose the steps to Flows. I have managed to get it working in Flows, up to the point where I need to map the data to the Google Sheet, and I get an “undefined” message on the field mapping.
I have reached out to both John Karas and Ranasha Chittick (Ro) for assistance. I have also booked a session with Ro on Tuesday to see if it’s me doing something wrong. I appreciate that there are some subtle differences between Flows and Make.
As Flows is still very new, there may be a learning curve that I need to go through. I’ll circle back here once I have more to share. If you’re interested in seeing the Make scenario working, let me know and we can connect. I’m happy to walk you through the logic, which is the same for Flows.
Make scenario and Google sheet results All data shown below is fake and created by ChatGPT
Hi Karl,
What an amazing start to my Monday - thank you for your reply. I watch your videos! So this feels like a celebrity appearance. Thank you for your wonderful thoughts and assistance. I would certainly like to make Knack flows work vs. Make - but I appreciate your providing the how to and I will explore that today along with Hugo’s clever work-around with the text formula fields. I am pulling this all to google sheets and then letting autocrat take over from there to generate documents and email them. It is a huge project with about 50 fields of data to pass through via connections if possible.
“I have managed to get it working in Flows, up to the point where I need to map the data to the Google Sheet, and I get an “undefined” message on the field mapping.” From your quote - it seems like you are able to grab that connected data and that’s exciting. I hope to understand how you are pulling the connected data through a table.
And thank you for escalating to John Karas and Rahasha Chittick. I feel very heard and helped by this community!
I used the text formula to build a full address in the table and made it the primary display.
New Field - Location Formula:
(paragraph tag){Location Company.site name}(close paragraph tag)(paragraph tag){site address}(close paragraph tag)(paragraph tag){site website}((paragraph tag)(paragraph tag){site email}(close paragraph tag)(paragraph tag){site phone}(close paragraph tag)
in Google Sheets it looks like this with all the tags included.
(paragrah tag)Bobs Tool Hut(close paragraph tag)
(paragrah tag)111 West Main, Smithsville, OR 97000(close paragraph tag)
(paragrah tag)http://www.BobsToolHut.com(close paragraph tag)
(paragrah tag)info@BobsToolHut.com(close paragraph tag)
(paragrah tag)1-800-Bob-Tool(close paragraph tag)
without the paragraph tags it is a hot mess of information and unusable when I bring it across via Autocrat to merge a document with the column tags. I don’t see a way to remove the tags or incorporate them behind the scenes.
Thanks for the idea - thought you’d want to see the results.
Hi Lou,
glad you had some success even ifnot the final result you were looking for.
I’d give Make a go - it really is the go-to for this type of thing for the majority of the Knack community for a good reason. Especially if Carl can’t get it to work with Flow; he’s probably among the most experienced Flow users I’d guess as a Knack early adopter / pioneer!
And with Make you’d probably not even need the G Sheets element (unless you need it for something other than something to sit between Knack and Autocrat). Happy to help with this if you like.