cori_parrish1 - profile

cori_parrish1 · Sep 06, 2024

i'm trying to make a formula to pull out the last name from a field that sometimes has full names in it & sometimes does not. i found this formula in a very helpful Airtable blog:TRIM(MID(SUBSTITUTE(Employer," ",REPT(" ",LEN(Employer))), (3-1)*LEN(Em...

cori_parrish1 · Apr 04, 2024

i have a zap with a Find Record step in Airtable. the step is set up to create the record if one is not found. for creating the record, i have text in a multi-select field that corresponds to one of the multi-select field options. however, when the z...

cori_parrish1 · Apr 06, 2023

this is probably the dumbest question.i have a table with a list of organizations (Members table) and a single-select field that tells me whether they are members or not.i have another table with a list of organizations that have sent someone to a tr...

cori_parrish1 · Feb 03, 2023

hi friends! we are an organization that provides online trainings. i have a base with registrations in one table and a unique attendance list in another table. the other table has a list of all the trainings.so the registrations table is all the regi...

cori_parrish1 · Oct 21, 2022

i am using a step in an automation that i’m hoping will allow me to add a related record to a field that already has related records in it. the prior steps in the automation are picking out which record i want the script done to. i am brand new to sc...

cori_parrish1 · Sep 07, 2024

omg, thank you thank you!!

cori_parrish1 · Sep 06, 2024

found an answer about the title case, which is that Airtable doesn't do that currently, and that this helpful tool can adjust the data: https://community.airtable.com/t5/show-tell/field-tweaker-script-block-for-in-place-transformations/td-p/89313stil...

cori_parrish1 · Apr 19, 2024

thanks so much for the reply! it looks like it stopped happening, so i don't know if one of the things i tried worked or there was some weird backend glitch that got resolved. weird! but thank you so much for trying to help me!

cori_parrish1 · Apr 07, 2023

thank you so much for your reply! because you said it should work, i went back & copied data out of the matching fields & pasted them into another doc, to make sure they were identical. turns out my import had added weird spaces between some of the w...

cori_parrish1 · Feb 03, 2023

i figured it out!! it was failing when the person had a training in their list that had commas in the title, so it was trying to make a new record of the info between commas. i fixed it by switching from using name of the related record to record ID....

User Statistics

User Activity

Help with SUBSTITUTE() formula

zap creating blank multiple select field option

find records automation not finding by name

problem with automation that sometimes works & sometimes doesn't

Scripting help - add related record to a field that already has related records

Re: Help with SUBSTITUTE() formula

Re: Help with SUBSTITUTE() formula

Re: zap creating blank multiple select field option

Re: find records automation not finding by name

Re: problem with automation that sometimes works & sometimes doesn't