Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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. 

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)

 

@Brady_P 

Student Name is an array with line items.

 

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

@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)

 

 

 

@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]”

 

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

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! 🤗

Terms & Conditions