Solving Make.com User Issues: Pulling Dynamic Scripts from Airtable

Have you ever tried to pull dynamic scripts from Airtable that use variable names from inside Make.com, but it's not working? You're not alone. This is a common problem that many Make.com users face. But don't worry, we've got a solution for you.

The Problem

Let's say you're storing scripts in Airtable, like the example below:

Hey, {{3.memberFirstName}}! Nest:Space here. Just a friendly heads-up, we sent you an email asking for a 5-star Google review.

You're pulling 'Messages To Send' from Airtable once a day, and if a message includes the script above, you're assuming that it will auto-populate the “memberFirstName” variable (which is pulled from Airtable and stored in a ‘Set Variables’ action. But it's not working. When the text message gets sent out with the above script, it looks exactly like the script above and is not injecting the name even though the variable is pulling the right data.

The Solution

With the help of a couple of the coworking space members, we were able to solve this! One of the changes we made was instead of putting the Make variable in an Airtable cell, we used [[memberFirstName]]. Note: “\” is used to escape the brackets. Then we used the Make ‘Text Parser - Replace’ tool to grab the script and replace [[memberFirstName]] with the first name variable we set up in the Make scenario.

Troubleshooting Tips

If you're still having trouble, make sure you're using the correct syntax for your variables. Also, double-check that your variables are being pulled correctly from Airtable and stored in the ‘Set Variables’ action.

Conclusion

In conclusion, pulling dynamic scripts from Airtable that use variable names from inside Make.com can be a bit tricky, but with the right approach, it's definitely doable. Remember to use the correct syntax for your variables and to use the ‘Text Parser - Replace’ tool to replace your variables in your scripts. Happy making!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.