Skip to main content
Solved

Make.com / Integromat returns Airtable’s internal ID instead of value (text)


  • Participating Frequently
  • 6 replies

 

Hello,

I'm trying to connect Airtable to make.com and gets records to fill document with Microsoft Word Templates.

The problem is returned data by Make.com. I'm getting something like this "recn3V..." instead of value from Airtable that should be a name of company. 

Thanks in advance 🙂

Best answer by Dimitris_Goudis

Hey @mvr222 ,

this is because the field with the company's name is a linked to field so make displays the record id from the table where you store company's name. 

One option is to create in your current table a formula that will display the name of the company and then use this field on make. Your formula would be: {Nazwa Firmy}. 

If this doesn't work please let us know. 

 

View original
Did this topic help you find an answer to your question?

10 replies

Dimitris_Goudis

Hey @mvr222 ,

this is because the field with the company's name is a linked to field so make displays the record id from the table where you store company's name. 

One option is to create in your current table a formula that will display the name of the company and then use this field on make. Your formula would be: {Nazwa Firmy}. 

If this doesn't work please let us know. 

 


  • Author
  • Participating Frequently
  • 6 replies
  • May 9, 2023
Dimitris_Goudis wrote:

Hey @mvr222 ,

this is because the field with the company's name is a linked to field so make displays the record id from the table where you store company's name. 

One option is to create in your current table a formula that will display the name of the company and then use this field on make. Your formula would be: {Nazwa Firmy}. 

If this doesn't work please let us know. 

 


Thank you, but I made new column with formula and still this same (scrennshots) 😞 

 


  • Author
  • Participating Frequently
  • 6 replies
  • May 9, 2023
mvr222 wrote:

Thank you, but I made new column with formula and still this same (scrennshots) 😞 

 


These screenshots I mean 🙂


Dimitris_Goudis
mvr222 wrote:

These screenshots I mean 🙂


Hey @mvr222 ,

Please open your make scenario and run only the module "Get record" from Airtable. Then open the output and look in those results. Please let me know if that works.

Thanks 


  • Author
  • Participating Frequently
  • 6 replies
  • May 9, 2023
Dimitris_Goudis wrote:

Hey @mvr222 ,

Please open your make scenario and run only the module "Get record" from Airtable. Then open the output and look in those results. Please let me know if that works.

Thanks 


You mean that?


Dimitris_Goudis
mvr222 wrote:

You mean that?


Hey @mvr222, yes


  • Author
  • Participating Frequently
  • 6 replies
  • May 9, 2023
Dimitris_Goudis wrote:

Hey @mvr222, yes


I made new scenario, and made new column with mentioned formula again, and now if i try to insert that is empty 😞 

 

  • Author
  • Participating Frequently
  • 6 replies
  • May 9, 2023
Dimitris_Goudis wrote:

Hey @mvr222, yes


For now the value in airtable on record "Firma" displays, but on the make.com it doesn't and its make by formula {Nazwa Firmy} (screen3)


Dimitris_Goudis

the problem seams to be on your make settings. based on your screenshots seams that you dont work on the same airtable table... 
The formula must be in the table from where you request data in "get record" module 


  • Author
  • Participating Frequently
  • 6 replies
  • May 9, 2023
Dimitris_Goudis wrote:

the problem seams to be on your make settings. based on your screenshots seams that you dont work on the same airtable table... 
The formula must be in the table from where you request data in "get record" module 


You were right, my stupid mistake. I was wrong about views and table (nvm).

Anyway your suggestion about create a formula helped a lot. Thank you so much! 

Have a nice day 🙂

 

Reply