How to debug and error between Airtable and Google sheets?

[Trager]

I have an Airtable data base which backups data into the a google sheet to avoid having to upgrade to another tier.
It used to work however I suddenly have gotten an error, which I don’t know where comes from or how to debug.

Any possibility anyone will know hat this means

" Error
Validation failed for 1 parameter(s).

• Collection can’t be converted to text for parameter ‘1’."

It happens when it hits the google sheet and I’m not sure what to do about it. Any help will be hugely appreciated.

[ImMichaelCannon]

Hi @Trager. A collection implies that there’s an array or other non-string value coming into Google Sheets. Look at your Airtable output to see what looks different.

Then you can reformat that information in Google Sheets using a join to create a CSV or other format.

[Trager]

Hi @ImMichaelCannon, thank you for this.
Is there a way to see in Make what is a string and what is an array?

In the below i assume the what is in my X column is an array and whats in my Y column is a string. Or is that not correct?
When you said use a Join did you mean what I’ve done in the Z column?

Thanks again for your help.

[ImMichaelCannon]

Hello @Trager;

For Make, you can tell an incoming variable is an array or collection by the [] appended to the variable. Like that 1.Internal shade color[] of above.

So X and Y above are arrays. And Z because of the join is a string.

Also, you might consider putting a comma , before closing join so you get a CSV format back.

[Trager]

Thank you for this @ImMichaelCannon this is very helpful,
Do you know what the difference is between my X & Z as the square brackets in the Y is apart whereas in Z they’re part of the full name?

[ImMichaelCannon]

Hiya @Trager; I’m not confident, but I think [] means simple array, and […] means multidimensional array.

[Msquare_Automation]

Hi @Trager
If you can share the output bundle of airtable "search " module, we can demonstrate on mapping each value.

How to Share Input/Output bundles

To obtain the input and output bundles for each module:

1. Run the scenario or retrieve it from the History tab.
2. For each module, click the white speech bubble located at the top-right corner.
3. Select “Download input/output bundles” from the dropdown menu.

This will allow you to download the necessary data for further analysis and sharing.

Method 1: Attach a Text File

1. Copy the output data.
2. Paste the data into a text file.
3. Attach the text file to your ticket.

Method 2: Direct Sharing

1. Use the direct sharing option available in the reply section. Please refer to the image below for guidance.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

[Trager]

Thank you for your detailed reply @Msquare_Automation

My scenario looks like this:

I tried to upload the .txt file but it’ll only allow me to add images.
I tried to add as preformatted text but the output from module 1 is too long to be within 3200 characters per post…? Any ideas how to get around this?

[Trager]

I wonder if any one else would know how to debug my scenario?

[samliew]

While it’s tempting to continue an existing thread with an accepted answer, a more effective approach would be to start a new topic for your new question. It helps other community users to respond to your query, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy.

The “New Topic” link can be found in the top-right of the header:

Thanks!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.