Best answer

How do I keep my commas when importing into Airtable?

  • 14 November 2023
  • 11 replies
  • 61 views

Userlevel 1

Hello all,

 

I have a Cognitoform that is being used to transfer student and testing information into an Airtable. The part that I am having issues with my student names (Lastname, Firstname). Whenever I run the Zap it is removing my comma and making the names two different values. I have included my Zap script below and the issue is at the bottom.

 

id

recwd5ZsqGkXtkcnh

createdTime

2023-11-14T13:47:04.000Z

fields

Request Number

81

Requested Period

1

reckY93KMqrbaprQe

Focus

Assessment

Assessment Link

https://www.cognitoforms.com/ArchbishopHobanHighSchool/_2324TutorAssessmentRequestNEW#b4cJ9a0LKIA_p4TSz0K8S0GawCbGHvwBITgEtBADynU$*

Requestor

Teacher

Student

1

rec76ccpONb8SiVN7

2

recW0S3nufHIg2kMo

Course Name

testing

Time Allocated

45

ReservedDate

1

2023-11-08

Assessment Directions

label

Directions

url

https://www.cognitoforms.com/ArchbishopHobanHighSchool/_2324TutorAssessmentRequestNEW#b4cJ9a0LKIA_p4TSz0K8S0GawCbGHvwBITgEtBADynU$*

Cancel or No-Show

label

Cancel or No-Show

url

https://airtable.com/shr81ywO9hrX2UJNc?prefill_Appointment=81&prefill_Status=Cancel

Check-In Student

label

Check-In

url

https://airtable.com/shr150j9WjdsBgNl0?prefill_Appointments=81&prefill_Checked%20in=1

Check-Out Student

label

Check-Out

url

https://airtable.com/shr81ywO9hrX2UJNc?prefill_Status=Attended&prefill_Appointment=81

Check-Out

label

Check-Out Student

url

https://airtable.com/shr81ywO9hrX2UJNc?prefill_Status=Attended&prefill_Appointment=81

Student Name

1

Swindell

2

 Christopher

 

How I want it to look: Swindell, Christopher 

 

 

If anyone has any idea on how to make the two names come out on 1 line I’d appreciate feedback. I already tried to convert to string, convert to text, and convert between the two in a two step process, but nothing seems to be working for me. 

icon

Best answer by Troy Tessalone 14 November 2023, 17:31

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

11 replies

Userlevel 7
Badge +14

Hi @Brady_P 

Good question.

Please post screenshots of these:

  • the DATA OUT from the Zap trigger step related to the name fields.
  • how your Airtable Zap step is configured.
  • the Airtable field(s) type being used for the names (from Airtable)
Userlevel 1

 

Userlevel 7
Badge +14

@Brady_P 

Student Name is an array with line items.

 

Userlevel 1

So, how would I be able to convert that to a single line with a comma separating the values? 

Userlevel 7
Badge +14

@Brady_P 

We would need to see screenshots of these:

  • how your Airtable Zap step is configured.
  • the Airtable field(s) type being used for the names (from Airtable)
Userlevel 1

 

Userlevel 1

 

Userlevel 1

 

Userlevel 7
Badge +14

@Brady_P 

Try this trick:

Put double quotes around the mapped variable, which will make Airtable interpret the array instead as a string.

e.g. “[STUDENT]”

 

Userlevel 1

You’re a life saver! Appreciate the help!!

Userlevel 7
Badge +6

That’s awesome @Brady_P! Big thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗