Notifications
Clear all
How To
10
Posts
2
Users
0
Reactions
6
Views
Topic starter
I have an array of linked records from an Airtable table named “Prospect emails” which is linked to a table called “Prospect and Sales”. My goal is to extract data from the source table, “prospects and sales”, and populate cells in Google Sheets, with each record occupying a single row. In my current test, I have four records. The process correctly places the Record IDs in the first column, but then it populates the subsequent fields with data only from the first record, instead of the data corresponding to each respective record ID.
Thank you kindly
Posted : 17/03/2024 10:50 am
Hi there,
I observed that you've utilized "Property name" within Google Sheets, which is an array. This action will consistently yield the initial element of the array. To assist you further, could you please share more details? A comprehensive Loom video would be greatly beneficial.
Should you need any further support, please feel free to contact us.
MSquare Support
Visit us here
Youtube Channel
Posted : 18/03/2024 3:21 am
Topic starter
Appreciate your response and feedback. I'm uncertain about the root cause of the issue. The array contains the record IDs from the “Prospect and Sales” tab in Airtable that are associated with the triggering record in “Prospect email”.
Thanks for your assistance.
Posted : 18/03/2024 7:59 am
Topic starter
I believe I need to map the other fields within the array, but it doesn't seem to permit that.
Posted : 18/03/2024 8:00 am
Try to hardcode the required data, for example: {{20.value}}, if you are retrieving data after an iterator module.
Posted : 18/03/2024 8:15 am
Topic starter
Hi, thanks, are you referring to hardcoding values directly into the spreadsheet?
Posted : 18/03/2024 8:30 am
No, if you're unable to map the data within the module, we can hardcode the necessary information. Before proceeding with that, please verify if you are receiving all the required data.
Posted : 18/03/2024 8:36 am
We're pleased it was successful, and we're happy to assist!
Posted : 18/03/2024 9:49 am