Ask the Community
Recently active
Hola! Hi! i'm new using Airtable! so, everything in my code was ok but when i try to do a Update Records, i have problems with patch. I have all permissions in my token, i write well the sentence to change, but appear this:
When I @mention someone on Interphase and they get an email notification to link them to the base to see the comment, is there a way to link them to the Interphase via that notification? I’m running into a bit of trouble with @mentioning someone and they’re taken to a gridview instead of the Interphase view. My gridviews and my interphase shows different fields so when they’re taken to a grid view, they don’t see the necessary information/fields.
Hi,I have created a prefilled Airtable Form.Whenever I click on the link from my Airtable Base, it opens the form and prefills the form with all the desired information (including line breaks, see image below).The trouble begins, however, when I try to use this exact same URL in an Email Automation (see image below).The link is displayed properly in the email (see image below).However, the linebreaks no longer work (see image below). This makes the text unreadable. It's an important part of the process, so if anyone can help out it's very much appreciated!
Hi there,Is there any method to write a POST request with the filterByFormula parameter within the request's data, while also applying a sort? I've attempted to add the 'sort' parameter within the request data payload but I'm encountering parameter validation issues. I also tried to append on the 'sort' as a URL query parameter but it isn't being applied to the data correctly.
I would love to have Airtable help me to map out the prerequisites for an academic program but I'm having a little bit of trouble. Imagine a list of courses - some are required for the program, some are electives, etc... Many of these courses have prerequisites. For example, before you take course F, you have to have already taken course B.If it were that simple, I'd be able to use the flow chart extension to map everything. Unfortunately, it gets a little complicated when prerequisites include multiple courses and even "this OR that" cases. For example, "before you take course F, you must have taken both course A AND course B OR you must have taken course C". I tried to use different fields for each case with an "or". For example:Multiple Linked Field 1 includes "Course A" and "Course B" records.Multiple Linked Field 2 includes "Course C" record. This would indicate that you must take Course A AND B OR Course C. The problem I'm having is getting Airtable to map this out
Hello everyone!I ran into a problem which I currently have no idea how to resolve.I have a script using an API call which logs the user into external system. This is not an automation script, but the script from a scripting extention. This is because fetch() function behaves differently and only passes authentication data when used in scripting extention. I can run the script pressing a field button in a grid layout.Data grid:Now I need to provide the user with an interface button that would finally resulted with logged in state. But this seems not as easy as it can be imagined. It is not possible to directly call a script with a button action as it is only capable of running an automation script, not scripting extention.Interface:However, using an interface button I can change the state of a checkbox field of the same record where the field button is, but I do not get the idea how to bind these two so when I tick a checkbox the filed button would be pressed. As far as I know a field b
Hi,I have a multiselect field containing topics. It is a linked field to another table and each topic might contain a comma within its value. I need to prefill a form with that data but I find Is it possible or do I have to remove the commas within the field values?Example of topics:Agricoltura, Ambiente e Territorio, Calamità NaturaliPolitiche per il Lavoro, Formazione Professionale e Servizio CivileCulturaFormulas I tried:This only fills the first topic: CONCATENATE( IF( "Prefilling [Form Preferenze] view in [Contatti] table in base with id 'appYSPQbVoKOqpys7'", "https://airtable.com/appYSPQbVoKOqpys7/shrVvuD1tVKS88IiG" ), CONCATENATE( "?prefill_" & ENCODE_URL_COMPONENT("Temi di Interesse"), "=" & ENCODE_URL_COMPONENT({Temi di Interesse} & "") ) ) If I try to remove the comma+space, it doesn't work for the topics that have that inside them: "&prefill_" & ENCODE_URL_COMPONENT("Temi di Interesse"),
Does anyone else here use softr and is noticing severe lagging and slowdown in the app after oauths were implemented? When we confronted Airtable, they told us that:to summarise, there are actually 2 limits on the api call5 calls per second per base5 calls per second per user/integration pairand it is the second one that softr is having issue handling. Any suggestions on:1. what alternatives to softr are out there that have existing integration with airtable2. screw airtable altogether due to these new limits -> find an alternative
Hello,I want to send a slack message each time "Tag 1" is updated. But if 5 rows are updated, it will send me 5 times the same message. How can I solve it? Thank you,Emilie 🙂
Hello --As of this morning, when my team logs onto any interface with search enabled (on a grid), it is almost instantly searching the table for that user's email. I do not have "Viewer's records only" selected, and when I am in the editor view the search bar is blank. It's almost like it's trying to treat the stored information from the user's browser as a login (note: it is happening across multiple browsers).It has happening across multiple interfaces and interfaces that pull from multiple tables. I don't know if this is a known issue, or if there's some global setting I didn't know about that I've accidentally toggled.Thank you 🙂
I'm trying to automatically populate emails depending on team member names.So if "John Smith" then in this column "john.smith@email.com" ""And if "Kate Jones" then "kate.jones@email.com" ""etcetcetcfor about 30 team members. I can get the first formula to work but how do i do it for multiple? Tried this but didnt workIF({Name} ="x", "email x"IF({Name} ="y", "email y", ) )
I have 5 non-value fields that indicate if a person has paid an application fee or not. The fields are: 180 GBP, 210 GBP, 240 GBP, 270 GBP, and 300 GBP. If a person has paid, it will say "Completed" under the column that they have paid. It will say "Not Started" if they have not paid. For example: If person A has paid the fee of 240 GBP, it will say "Completed" under that column, and it will say "Not completed" under all of the other monetary columns. (it was not my idea to organise it this way, it is just the way it has to be!)I would like to add a formula field called "Paid" that can identify if a person has paid (Yes or No) based on the statuses of the 5 monetary value columns. I want it to recognize that if 1 of the columns in a row is "completed" that the "Paid" value will be "Yes."Does anyone know if this is possible? Please see photo attached for an example of how the fields are laid out, and a sample "paid" field.
So I have a table called "Dealerships" and a table called "Services". Each record in "Services" has a date, an amount, and a link to "Dealerships". I'm creating an interface that will aggregate these, so I can know the amount that came from each "Dealership". I know I can do this with a Rollup, but the problem arises when I try to use a Filter element in the Interface.I have a "Dashboard" page and a "List" element sourced from "Dealerships". This list contains both the Dealership name and the rolled-up amount.I need the user to be able to select a date range via a Filter and have the Rollup be updated to only add up the services that match those dates. I haven't been able to find a way to do this. The closest I came to a solution was to use 2 levels in the List, which actually DOES filter the services in the 2nd level but does NOT change the value in the Roll-up accordingly.Any guidance would be greatly appreciated. Thanks!
Greetings, I have a zip code field that's either 5 digits or 9 digits. I need a formula to display the zip code as either 12345 or 12345-6789 depending on the content of the field. I know How to write the beginning of the formula, I do not know how to write the if 9 part. I have IF({Zip Code} <6,{Zip Code}, Need to describe the 9 digit code with a dash.)Anyone have a thought on this? I am using a number field for the zip code. Is this the correct field to use?Thanks, Scott
I’m trying to figure out the best way to send single send sorts of emails to people in my database.I’ve tried using the built in segmentation tools of typical mailing list software, but my needs are much more variable and ultimately at the end of the day it’s soooo much easier to just put together my list in Airtable via filters. And then I could fill in the little extra info I need from there into a templated email of some sort. I really only need to send a few sentences of info. Is this something I could feasibly do? I assume using sendgrid or similar?
I created a staff scheduler with a series of automations that copies a shift (Workday Date and Start/End Times, Location linked field, employee linked field, notes) to a future date based on 4 checkbox fields (creating a shift 1, 2, 3 and 4 days in the future).While the tool works great, I started receiving an error with only ONE location linked field every time I try to copy a shift. The error reads as follows: 'Creating the record failed due to insufficient permissions.' I have tried several fixes, including creating a duplicate of the location in question in the parent table and cutting and pasting pertinent information and linking fields about that location into the new record. I am completely stumped and as it is impossible to reach Airtable directly anymore, I figured I'd turn to the forums.Thanks in Advance!
It would be awesome if Airtable added 'This Year' and 'This Month' to the filters. This way, I could create a view of records, like expenses or invoices, that apply to this month or year. I'm actually surprised this is not already a feature. It seems like it would be a simple addition.
I am unable to view Getting Started webinar. Each time I click on it, it takes me to registration page. I can't even find an email address to contact AirTable. The bot is worthless. Please help, thank you. https://www.airtable.com/lp/resources/webinars/get-started-airtable-od
As per the attachment, I have created an automation with multiple steps starting with a form being submitted and ending with an email being sent to the customer who submitted the form.The email body requires data from the previous steps of the automation to be updated.The problem is that it seems the automation doesn't run in sequence (each step following once the previous one has been complete), rather all steps run simultaneously. This causes the email body to be missing data, because the final email is being sent before the records have been updated according to the previous steps.Am I doing something wrong?
Hello!I have the following bases tables:- Team- Emails Teams has records of people grouped by single select types of teams (Management, Development, Operations).Emails has email records that is populated by a form. The form asks for, among other things, the group it is to be sent to. This is a separate field not linked to the team field in Teams. Once the email has been approved, i have a trigger when the status of the email submitted is "good to go".I would like to know how to go about automating sending an email when that is done, to the defined group of people. e.g. Team "Management" is selected on the email submission form, once approved the an email sends to that group.Appreciate any help 🙂 PS: Is there a way to manually send an email from airtable? Perhaps it can be modified to send when a different form is filled out, with say subject line, body, etc.
Is there a way to put parts of a formula (while writing or editing it) on separate lines, like in a visual editor, to better organize? It works when I cut and paste, but I can’t figure out how to do it in the box. Any suggestions?
Hi All, I'm trying to use a linked record to pull up the TRT of an asset that's listed out as a full timecode, extract just the hours and minutes and put that into a duration field. I've gotten so far as to pull the hours and minutes but when I set the automation to fill the duration, because it's not reading the text as seconds, it's coming in with the wrong duration. I haven't been able to get datetime_parse to convert the text to time. I can sense there's an easier way to do this that I'm just not landing on but nothing I've tried has worked.
Hi all! Here's what we're trying to do, and what we tried that isn't working:What we're trying to do: (example table: https://airtable.com/appKiBFGhHOgFeXf2/shrrTAISY39Rx8mL5)We run an exam, and have two tables:test_takers - each person who is taking an examexam_instances - each instance of an exam, 1:1 linked to test_takers.In other words, a single test taker could take an exam multiple times, generating multiple exam_instancesWe would like to store the status of the exam (e.g., not started, started, passed, failed) in two places:In exam_instances - each instance will have a single exam_statusIn test_takers - each test taker will roll up the "maximum" of those statuses. For example: if someone starts the exam twice and passes the second time, so one entry in exam_instances has the status 'started' and the other has the status 'passed', the entry in test_takers linked to each of those exam_instances should be only 'passed'.In other words, it doesn't matter how many times some
Hello everyone,I have used scripts a lot in the Automations pannel. However, I'd like to create more user friendly experiences using the Script Extension.Upon creating my system, it appears that buttons that trigger script extensions can not be run from an Airtable interface. Can anyone confirm that? Is there a way to create better experiences directly in the interface pannel by allowing users to follow a set of actions as defined in those scripts? Can it only be run from the data pannel?Thank you very much,Simon
Hello all,I am new to Airtable. I am building automations but have no idea of scripting.Maybe someone can help me with my issue.I have 3 tables:1. Projects (here I group linked operations)2. Operations (these are all operations)3. Products (these are products which are included in operations.4. BOM (bill of material for invoices)Project is linked to operations via PROJECT_ID.Operations is linked to Products via PRODUCT_ID and projects via PROJECT_ID.Products is linked to BOM via PRODUCT_ID.I want to have this kind of logic:When record is created in operations, with operation type "Sales", where product is not empty,I want to search all entries for this product in BOM table, and copy all entries to Operations table, with link to the same project.Is it even possible? Any help on how to do this kind of stuff?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
