Ask the Community

My base has a field formatted for URLs. When I use automation to send the URL for a given record, how do I make that reference a clickable link in the email? It looks like I should be able to do that with Markdown, but I haven’t figured out the details. Thanks in advance!

Привет! Ищем специалиста по разработке CRM систем (Airtable или аналогичные инструменты). Нужна консультация. Как вариант - отдадим проект опытному ноукодеру. Пишите в телеграм@zarinaayupova стоимость консультации, портфолио

I need to send a gmail via an automation that I need to format the body with a script as there's a lot of data I need to collate and format.  Is it possible to have a step that runs a script (I have a team acct), populates a long edit text on a record as a formatted email body, with urls etc, then on the next step of the automation gmail that field?It seems like it'd be "yes", and I'm going to try it out tonight, but if there are any warnings or cautions anyone has to offer, I'd love to hear it.Thanks.JeffEDIT:  As I was working on this adding the long text field to my table, it got me thinking that I might just create a new table called "gmail" that I populate with all the particulars, and then have a separate automation that sends those gmails out and updates the row with the status and date/time sent.  Nuts?

I've been working with scripts and have been loving it.  I know the answer to this is probably no, and would be nice to have, but not a huge thing but....Is it possible to have a some common functions that I write shared across other scripts I use in my base?  I can continue to just copy/paste them in the scripts I need.   I know it goes against the ethos of low-code, I just have a few I use a lot.

Hello - I have another frustrating issue with regard to using the output.set function.I am able to access a list of records from a query using  output.set("Record List", query.recordIds), but as expected it only outputs a  list the record ID strings.What I want the output.set list to output is a list of values from the query result.  Put differently, I am trying to build a list of records, and have the output  be a list of the cell values.Once I have that list, I plan to pass it to a repeating group automation step.I am not understanding what I need to do to prep output.set to output a list of cell values.  // query for every record in "User Accounts" let table = base.getTable("User Accounts"); let view = table.getView("Unlinked Member Script"); let query = await view.selectRecordsAsync({fields:["User ID","User Login"] }); //this outputs the list as record ID string; output.set('Member Lis

Alright, I've watched all the YouTube videos I can, and have looked in here for help and I'm still stuck.Problem I'm Trying to SolveAs an interior designer/home stagerI want a "shopping" page of available inventorySo that I can click a button and select and item for a jobI have a grid set up, which includes all the inventory we own for staging homes. I also have a gallery view of that table. What I want to be able to do is have one of our non-technical interior designers come to the gallery and see only the available/in-stock items, I haven't tried tackling that part yet, but it seems easy enough. The part I'm stuck on is I want them to be able to click a button and add it to an order or "shopping cart" if you will. They can just scroll through, click a button for the items they want and in the end, end up with a list of all the inventory items we need to pull to stage a home. Is this possible?

I'm looking for a way to make accessing and working from an Airtable Task list more efficient.I've got an Airtable base with a table of Tasks that are grouped into Projects.  It's been great for prioritizing tasks and getting things done.  It works great inside Airtable.  But having to open Airtable, go to my workspace, select the appropriate base then view is pretty cumbersome for viewing a To-do list.Is it possible to create shortcuts on my iphone to specific views?Are there ios apps that play well with airtable where I could sync a specific view to a to-do list? (Bonus points if I don't have to subscribe to yet another service)Am I missing some obvious functionality of airtable and making this harder than it has to be?

Hi,Is there ways to (i) force an email address collected through a Airtable form and to (ii) convert an email address coming in from an external system to lower case?We use Airtable as a CRM/ERP system, hence we register contacts and events for those contacts (for the purpose of this question). The first touch point is an Airtable form, after which the contact is directed to a Calendly event. The one piece of information connecting these inside Airtable (and a basis for a lot of automations) is the contact's email address.Yesterday I debugged an automation, and realised it had not found the right contact due to a capital case beginning of the email in the contact's data. Had not thought about these (naturally) being case sensitive.I see that one can user lower() in formulas, but would not want to use several "parallell" fields/columns for this. I tried to use lower() to encapsulate the data field in the automation, but that didn't seem to work.

TLDR: Can you have an automation trigger that is a scheduled date be changed by data in a record?I was telling a friend about airtable and she asked me how hard it would be to have a notification email go out based on data in her record(s).  She was thinking about using airtable to define different appliances and systems in her airbnb's, and wanted to define data for an HVAC system (there may be several) that has air filters (of which one system may have 1 or more) and have the reminder be sent after say, 3 months.  If she doesn't get around to changing it until month 4, she wants to have the form allow her to say "yes, changed on this date, remind me again in another 3 months" Of course, that's the human talk description, I know it would actually be checkboxes and dropdowns.  She may change one sooner if she had lots of clients, but she doesn't want the notification "every 3 months", but rather, every 3 months after her last change.

I'm using automation.I want to automatically add comments to the record when updating certain fields, but I can't..What should I doAnd. I keep failing to get records... I caught when record updated with trigger... let table = base.getTable("Your Table Name");let recordId = input.config().recordId; if (!recordId) {throw new Error("Record ID가 정의되지 않았습니다.");}let record = await table.selectRecordAsync(recordId);let fields = ["fields1, fields2, fields3"];let changes = [];for (let field of fields) {let oldValue = record.getCellValue(field); // let newValue = record.getCellValue(field); /if (oldValue !== newValue) {changes.push(`${field} 값이 ${oldValue}에서 ${newValue}로 변경되었습니다.`);}}if (changes.length > 0) {output.set("changes", changes.join("\n"));} [Error]ERR

Hello, I am making a recurring weekly checklist, and I would like the Kanban Stacking view to change with the day. So today is Wednesday, I would like all my Wednesday tasks to be first and Thursday next, and Tuesday to be last. Unfortunately the stacking option only allows for alphabetical order. I’m trying to think of a formula that would be dynamic and would assign the row a “1” if the due date falls on today’s weekday, and assign a “2” for tomorrow’s weekday, and so on. I’m not sure if that makes sense. That’s just one thought, if there is an easier way I’d love to know.

I need to create a simple function that checks a value, compares with it with another value in a record.I have the interface setup and have created a record in the table that the user can update. I have a button that runs an automation to run a script and completes the check. What I cannot seem to do is update the user to say wether or not the check has passed or failed.I cannot use output.text as this isn't available in automations, only the scripting extensions. AFAIK you can't open a dialog box from the automation script either. The only way I can think to achieve it is to add a field to the table called "Dialog" in the table and then update that display that in the interface? But that seems _really_ clumsy.My question isA: Can I run a script extension from a button on an interface? B: Does anyone have a better idea of how to achieve this?

Hi guys!!!I´m trying to set up an automation which could find some records under determined circunstances. Then update a couple of fields and finaly open an Airtable URL which is contained on a field and is different for each record. Everything works quite good, except que the URL openenig which i have no idea how to make it happen. I guess it would be through a script, and should be so complicatyed, but i have no idea how to start. Thank you in advance for your time.

I recently completed my Certification for Airtable Builder. Are there any builder specific certs that are more advanced than this offered by Airtable Academy?I couldn't find any, but presumed some of the aficionados on here might have helpful guidance.Thanks!

Dear Airtable,I would like to figure out how to keep the public from downloading my members personal information when I publish in Universe. I need to disable "Copy Base", and I want to disable 'download csv' in each table/grid sheet.I must be missing something simple, assuming Airtable isn't intentionally making public customer data. I have the Business level subscription.Thank you.

I have a base of students that I've just shared with my 5 co-teachers as Editors. (We have done this in previous semesters, so this is a clone of a previously used base.) They've received the invitation and can open the base, but two of them have reported that they cannot see any of the records. On my end, everything appears fine.Suggestions? Solutions?Thank you.Vlad Morosan

Hi, New to Airtable, I work in Local Government in the UK and whilst I think the product would work well for some projects I need to understand where data is hosted. Under our Government rules any data I store in the cloud has to be on UK based servers. Most cloud providers we work with offer some kind of location specific hosting of data. I cannot find any information about whether Airtable is able to offer this? Thanks in advance

Use Airtable Record URL in email notifications...any way to link to that record in Interface rather than data view?

In the last 2 weeks my enter function has stopped.If I open a record and type txt into a cell I used to be able to hit enter and create a new line. This has stopped yet I have no issues with any other software and the enter function when typing txt

Hello! I want to generate some HTML code using a Lookup function and I've been running into a weird issue. Each HTML button is defined in a table, then is combined like such in a Lookup function:<a href="/water-coaster/192/" style="text-decoration: none;" title="Go to this water coaster"> <span style="background-color: beige; color: black; padding: 10px 20px; border-radius: 50px; font-size: 16px; font-weight: bold;">Montanha Russa Aquática - Thermas dos Laranjais</span></a> , <a href="/water-coaster/281/" style="text-decoration: none;" title="Go to this water coaster"> <span style="background-color: beige; color: black; padding: 10px 20px; border-radius: 50px; font-size: 16px; font-weight: bold;">Acqua Coaster - Thermas Acqualinda</span></a>Unfortunately, there is a pesky comma that Airtable adds in between the two blocks. I tried using a second column with the formula  SUBST

Hi there! I’m writing to ask how we can create a multiple choice grid on Airtable forms. I really love airtable, but need to collect information similar to this: Any tips/suggestions you have is greatly appreciated. Thank you!

I have a database where the first table is the registrations, then I have four more tables with their own forms. I want people that registered in the first one, to find their name in the other forms instead of filling it out again. So what I need is for the the name of the records from the first table (registration), to automatically populate a dropdown menu in the other four forms. Do you know an automation to do that?

I am working on a service workflow that would require me to send estimates for projects. I can set up an automation to send a single estimate at a time but Im struggling to find a way to send multiple estimate in a single automation to a client with multiple project requests.

Jumping in for anyone who finds this thread in the future -I have created a (Free) python script that allows you to download your attachments,you can read the code I wrote on github https://github.com/garygng/Airtable_python. Wish you guys like it  and give me a  Kudo👍 

I have an API script like the below. This works fine as a scripting Extension (right panel) but when I place the script into an Automation Script step, Airtable gives the error "ReferenceError: FormData is not defined".Any ideas why it would work in one place but not the other? const myHeaders = new Headers(); myHeaders.append("Authorization", apiKey); const formdata = new FormData(); formdata.append("file", fileBlob); const requestOptions = { method: "POST", headers: myHeaders, body: formdata }; let postResponse = await fetch(apiUrl, requestOptions);