Automations

Hi When I run my Automation to Update a record it changes the membership Number. In My row I have a unique membership number, But when sending the link to the member for updating when the form is returned the information is updated But it also changes the persons Membership number. How do I stop that

Pabbly connect is a platform that works like Zapier. It can create new record, update record or delete record. I have a record which has a linked field i want to update. I cannot “Add” records in this field using Pabbly but instead i always replace the old record and substitute it with the the record. Any idea? Thanks

I have created a form that is prefilled, Once submitted, I would like to share the form with the person submitting it so they can edit or add information they may have left out. I have managed to get an automation to work that updates the record thanks @Vivid-Squid I sent the form link to a friend who filled it out and submitted no problem. I then sent the URL for them to up date via whatsapp. When they tried to open it on the cell phone they were directed to the play store to get Air table. Is there away around this? Many thanks

Hello, I was wondering if there is a way to split a single pdf into multiple pages using Airtable. For example, if I add a 20 page pdf to Airtable, is there a way to have 20 rows of single page documents in Airtable automatically without uploading them separately? Any assistance would be greatly appreciated. Thanks!

Hello guys! As far as I can tell there is no way to include a page designer page in a email automation at least natively inside of airtable. Is there some other way to do this? With external tools and such?

Hi everyone, I need you regarding my project. Indeed, it composed of a web app, a mobile app and Airtable. My question is : How do I send messages (notification or just communicate) between a web app and an mobile app? To explain a little bit more, the database is the same for the web app and the mobile app BUT the final users of those aren’t the same. So, let me give you an example : I’m the user on the web app. I’m choosing a person with his email, writing a message such as “hello”, then I’m clicking on a button “SEND” and after that, when I use the mobile app, I’m connecting and I have the message “hello” on my account. Is it possible to do that ? If so, don’t hesitate to give me tutos or other topic regarding my project. Thanks in advance. Kind regards

Hi, I am using this formula and it isn’t implementing the decimal places from my {Refill / lowest price} column, which in itself is set to 2 decimal places: "Lowest cost per " & {Unit} & " based on: " & “£” & {Refill / lowest price} & " for "& {Lowest cost option} It is bringing back things like the following; “Lowest cost per wash based on: £5.3 for 24 capsules (fragranced)” If I go to formatting it gives me “Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.” But is there any way to ensure it ‘pulls’ the number with both decimal places? Thank you!

Hi again all, So I have start date column & a status column. I would like an automation where once a start date has been met it changes the status from ‘not ready’ to ‘ready’. The only options I can see are if its today, but then if goes past this, will it incorrectly change the status again?

I’m using an Airtable form to allow employees to register for trainings. I have created the form and it’s been working fine for me. I already have an automation that automatically sends them an e-mail with the class they signed up for, but I’m trying to modify that automation so that it sends them all of their “registered classes”. I have the automation working fine for this. I’m using a find records to look a condition for when someone’s name shows up. It sends an e-mail of the list of classes in a grid fine, but for some reason they aren’t organized by date like they are in the view. I feel like I’m missing one small detail. Any help would be greatly appreciated. How do I get these to show up in order of start date?

I have about 500 air table records with protected slack attachment links. I want to somehow either extract these attachments, or make the links publicly accessible for externals. Is there an existing script for this?

Hi there - I’m a bit stuck if I can do this with Airtable and definitely can’t get it to work with Zapier, so wondering if you can give some insight… Here’s what I’d like to have happen: Member joins program and chooses a 6-month payment plan Their 1st payment gets imported into AirTable 5 automatic records for their subsequent monthly payments get created so I can track projected revenue I thought I could do this in Zapier by using the date modifier (of adding +1mo to the current payment date), and although it imports, the date is left blank. Is this a formatting issue? Any other ways to do this with Zapier? Can I do this with Airtable instead? Trying to keep it as simple as possible!

I want to automate this but I’m not sure on the setup, maybe this isn’t the best place to ask, but here we go… I work in a university career center, we use Airtable to manage a student-alumni matching process. Alumni opt-in to be on the list, students can request a connection (OPEN the process), we facilitate via some automated emails, students (ideally) report on the outcome to CLOSE the process, rinse, repeat. I would like to create a way to limit the number of OPEN requests that any one student has at a time. The unique ID for students is their email address, but we can only collect that via anonymous form because FERPA. So I don’t think we can have a linked table of students to use a count field, unless that can be dynamically created and updated behind the scenes. So, how can I setup AT so that each time bucky.badger@wisc.edu submits the from, it will count how many existing requests with that same email address match certain conditions and then flag somehow so we pause the new re

Hi guys, I need help because have an issue because with a Gmail > Send email automation… On the technical part it works quite well! However since I’ve been using this Automation, my collaborators are telling me that my emails are received in spams! Internally, that’s not a problem because they added me to their ‘not spam list’ but it is a huge issue as I use them for recontacting my leads and clients… Do you know what I can do ? Thanks in advance!

I have separate registration lists for a series of events we are running. I would like an automation to combine the registration lists when a new record is created, so that this list is the definitive list of all unique attendees at every event. If the same attendee appears in multiple registration lists, I would like a singular record to be created, but I would like their multiple select attendance field to say they are attending both events. E.g. Daniel attends Event 1 and his record is created in the combined registration list table and his attendance updates to Attending Event 1. Daniel then signs up for event 2. His registration already exists in the table so rather than creating another record for him, the multiple select field for attendance updates to say Attending Event 1, Attending Event 2.

Hi, I have a base including 900 hotels in different cities. I have another base including 1200 attractions in different cities. On the website frontend I’d like to show nearby attractions and distance to the specific hotel. I don’t have any issues with calculating the distance between 2 locations. I was wondering how I can show only attractions in the same city for a hotel. Thanks for your help. Ata

Lets say we have 10 tasks assigned to 10 people, which are meant to do the tasks in order. When Person 1 finishes his/her task, I want to send a notification to the person 2 that Person 1 is finished and his/her task2 is ready and waiting for him. The difficulty I am facing is that the automation is within the same row. For example: Buy Vegetables Person A Done Wash Vegetables Person B To Do Cut Vegetables Person C To Do When Person A clicks on Done, Person B should receive an email that his task is waiting. Since these inputs are not in the same row, I am facing toubles with the trigger and action.

for (let d in daylist) { await currentTable.createRecordAsync({"Actual Date": daylist[d], "Assignee": [{id: assigneeID}]}) }; Is there any reason why the above snippet works in Scripting Blocks and not in the Automation Script? (assigneeID is a input.config record id from automation trigger) Err message is: Error: Field “flduSGLFu8QyJ6n9l” cannot accept the provided value at main on line 22

I got as far as selecting my records - but it won’t let me insert them. This is the last step before I can test the email. Why won’t it let me insert the selected records ?

I have set up and automation to email a client when their job is marked as done, and it is working. However, I just want to make it more intuitive if possible. Currently - When marked as done and there is an email in the ‘client email’ field there is an email generated, in the email I reference job title, notes etc (all pulled from data in the table) I would like - 2 emails set up, email ‘a’ gets sent if there is a url in the url field filled in the job. email ‘b’ gets sent if there is NOT a url in the url field in the job data. Hopefully I am explaining that correctly. So I know how to do the automation, I have one working well, I just want some more detail and not sure how to add the additional conditions, or if I need two automations set up and only the one matching the specific condition would be triggered.

Good morning, I’m discovering the automations, with sending an email when a record matches a defined condition - so far so good. But the little problem (or limit I should say) is that I have multiple tables with many entries, and I’d like to add some details to the email sent: at least the table / base name, and ideally some way to identify the concerned record, with for example the first or second column value. Do you think it’s possible, please ? Thanks in advance for your help, Regards. Nicolas Caplat

Hello everyone! I have recently experienced this error with my automations is this something to do with gmail? It has been going on since today at 8:27 am (EST). Does anyone know anything about this?

Hello, I have records being created from users on a public form. These records involve Event Dates. My email automation is using that Event Date to trigger reminder emails (1 week before the Event) and other triggers, like the day after the Event. The only problem is these triggers are happening just after midnight, which is not ideal. I don’t want to send emails that late/early into the night. But that is when the records “show in view” using filters. I can’t figure out a way to delay these automations, and, I can’t manually go in and adjust the time for each record since these are created from the users themselves through the form. Any ideas??

Automation is setup too append a row to a Google Sheet. All of the values (text, dates) will populate within the sheet row, except for the numerical score values when the automation is running. However, if I run test automation with the same record, the numeric value will populate into the column. The scoring numeric values in AirTable are single select based on automated triggers to specify to a certain score. I have tried changing the column data format on the google sheet with no success. I have tried to change the triggers as well as adjusting the value lookup but still will not work unless I run a manual test. Any ideas on what I maybe missing?

Trigger is the priority here Triggers: When Contract(status) is moved from Active Rental, Rent to Own Active, AA Auckland to Returned or Swapped Cars & Bond Transferred Contract status has many option and I want only to run the automation when above scenario triggers not for all the option. Do this: - Change vehicle status from Hired to Available? in Car/Vehicle Table

I added new data to my table and wanted to use that as a field in my automation but when I add this in there is no value against the field. The only way I have managed to get the values in is duplicate the automation but this seems like a very long winded way to just get a new data field into my automated email. Any ideas?