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