Jan 20, 2024 02:53 PM
I create 'multiple select' field to store multiple functions of my product. When I do automation to google docs, the information in this field is grouped together into one field.
Current format in google docs is
value 1, value 2, value 3
Any method to present the value each line?
value 1
value 2
value 3
Also, the product image can't be automated into google docs through airtable automation. How can I fix it? Tks.
Jan 20, 2024 06:01 PM - edited Jan 20, 2024 06:25 PM
1. To make each value of your multi-select field show up on new lines, you will need to create a formula field in Airtable with this formula:
SUBSTITUTE(
{Your Multi Select Field Here},
", ", "\n"
)
Then, use that formula in your automation.
2. Airtable's Google Docs automations don't support sending images to Google Docs. You would need to do this using Make's Airtable Automations and Make's Google Docs automations.
There are many, many different ways of setting this up, but the screenshot below will show you a very quick & easy example of how to set this up in Make:
If you've never used Make before, it can be challenging to learn for the first time, which is why I’ve assembled a bunch of Make training resources in this thread.
For example, to instantly trigger a Make automation from Airtable, check out this thread on instantly triggering a Make automation from Airtable using a webhook.
And Make even created an entire Make Training Academy here.
i also give live demonstrations of how to use Make in many of my Airtable podcast appearances here: https://www.youtube.com/watch?v=SbH9iE5ncCk&list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1
p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld
Jan 22, 2024 02:17 PM
@ScottWorld I'm experiencing this very problem.
Can you give me more information on this?
1. To make each value of your multi-select field show up on new lines, you will need to create a formula field in Airtable with this formula:
SUBSTITUTE(
{Your Multi Select Field Here},
", ", "\n"
)