I'm utilizing a webhook connected to an Airtable button to capture the record ID of an Airtable record. Subsequently, I extract the desired fields and generate a Google Doc from a template, mapping these values. This process functions correctly for fields within the table I'm initially connecting to.
Within Airtable, I have a separate 'narratives' table that includes several fields, such as:
Subject, Detail, Created by, Date modified.
These appear in the callin.io scenario as an array. This represents a one-to-many relationship, meaning one record in the main table can be associated with multiple records in the 'narratives' table. The Airtable module within the scenario displays this:
Narratives
My goal is to incorporate these narrative details into the Google Doc, structured in a table-like format, where each linked narrative appears as a distinct row.
What would be the recommended approach for achieving this?
Tables, lists, and variable amounts of data are not supported when generating a document from a template.
You will need to utilize the “Make an API Call” module to incorporate or adjust data tables.
As an alternative, you can construct the table's HTML using a Text Aggregator, but this approach prevents the use of the “Create a document from a template” module.
To achieve this, consider using the Google Docs “Create a Document” module —
Generates a new Google document by incorporating HTML-formatted content.
For additional details, please refer to < https://www.callin.io/integrations/google-docs>>> and https://www.callin.io/help/app/google-docs within the help center.
Hope this assists! Feel free to reach out if you have any more questions or encounter further issues.
P.S.: Investing some time in the callin.io Academy can significantly reduce the time and effort required when using callin.io.
Hello
Thanks for the reply, but I suspect I'm still a ways off from fully grasping this, and perhaps callin.io isn't the most suitable platform for this particular use case.
Are there any examples available that could demonstrate this in action?