Ask the Community

I want to separate the following text in different columns :Column A : @Ben11//test-bug//Feb 22, 2024 3:54pm UTC//Budget//Test again//Test again//ModerateColumn B : @Ben11Column C : test-bugColumn D : Feb 22, 2024 3:54pm UTCColumn E : BudgetColumn F : Test againColumn G : Test againColumn H : Moderate

HiI am currently developing. a custom extension.I want to do external authentication on adding the extension.How can i do this?.Should i have to configure the the authentication url and token url somewhere for airtable to do external authentication or should i have to do it manually.please anyone help me with this...Thanks in advance 

I have a payroll base that tracks timesheets and commissionable transactions for our employees. It includes the following linked tables:EmployeesTimesheetsThe Employees table includes information for name, address, email, etc. Additionally, there is a Straight Time (ST) Hourly Rate field. We have thousands of records in the Timesheets table from daily entries submitted by employees. The submissions simply consist of:Employee NameStart Date/TimeEnd Date/TimeFormula fields calculate the number of hours worked. To calculate ST Gross Pay, a lookup field displays the ST Hourly Rate from the Employees table. That is multiplied by the number of hours worked.We recently decided to give an employee a raise in his ST Hourly Rate. My problem is that if John has a ST Hourly Rate of $20 and I change it to $21 then, based on the present calculations in the Timesheets table, all my historical records reflect the ne

My client has a team of several Creators and one Owner. They want to make an Interface that is only viewable to the Owner. When I create a new Interface and choose not to share with users (I click "Not Now" on the dialogue box shown below), then I go to Manage Permissions, it shows that all Creators have permissions to the new Interface. I can't figure out a way to remove access to Interfaces for Creators. Is this even possible? Or do they need to be downgraded to have permissions set for them? 

Hi!I have a countdown for our warranty cases, which needs to be completed in the 45 days or less. Our customer fills out the Form, and the countdown stars when the Form is submitted. So the first field is "Form date" DATETIME_FORMAT(CREATED_TIME(), 'D. M. YYYY')The second field is "Days" DATETIME_DIFF(TODAY(), {Form date}, 'days') And the third field is "Countdown"45-{Days} This works fine, but the problem is, that when the status is "sent" or "refund" the countdown don't stop. So the point is, that I want to know how long one case was open. I can also use just one status, let's say "complete" but now I stumble upon one problem.I don't have a specific date field for the end of the case (it depends on the case - some wants refund, some wants exchange or repair). So in this case I have two date fields (date

Generally, I've been very happy with Airtable's documentation and what's available in the community.  Not so much with this issue.  I see posts ALL OVER the community about people needing to query a table or view and filter their results (like a typical WHERE clause in SQL).  This is one of the most common questions/issues I see, and yet the support from Airtable staff on providing very clear example code for accomplishing this is between abysmal to non-existent.  I'm no genius, but I'm fairly bright.  Trying to figure out the exact syntax for accomplishing this from the info available is way to difficult!  Come on, Airtable!  Help us out!I'd like to see a new section that supplies plenty of specific script code samples for the most common query filtering, such as...1) A basic string field "where FIELD = 'Some value'"2) When multiple fields need to be included . "where FIELD1 = 'value' AND FIELD2 = 'somevalue'"3) When yo

I have been testing Process St for documenting my tasks/processes to delegate to others. It is a great tool that lets me create the steps on a left navigation and then add text/images and videos to each step. I was curious if there might be a way I could do this in Airtable. I am stuck because I can’t include text and pictures or videos on the same field. Here is an example one I did using Process St. app.process.st

Due to the deprecation of the API keys, you won't be able to connect your Airtable with your Typeform. Since personal access tokens don't work you are not able to advance. Typeform will repeatedly ask you for your API key which you can't create anymore.How can this be resolved? Hope someone can help, thanks. 

I've successfully created a webhook via the Airtable API using the following json: { "notificationUrl": "https://mycallback.app/", "specification": { "options": { "filters": { "dataTypes": [ "tableData" ], "recordChangeScope": "tbla....." } } } } It seems to work in the sense that my callback URL gets called.  Right now all I'm doing is logging the request body that is sent back to my endpoint and it seems to be missing all the important data about what has changed.  This is what I get back: { base: { id: 'app6......' }, webhook: { id: 'achnoA6.....' }, timestamp: '2024-02-22T23:46:02.849Z' } ANy idea what I did wrong or what I should be doing to get the details of what field changed.  I see the change in the UI and I've tried making the change in the UI as well as via code using an Airtable libr

I have a string of text in one column that i'd like to separate into individual columns. For example: Row 1: K, 1st, 2nd, 3rd, 4th, 5th, 6thRow 2: preschool (ages 4+), K, 1st, 2nd, 3rd, 4th, 5th, 6th, 7th, 8thRow 3: ages 3+, preschool (ages 4+), K, 1st, 2nd, 3rd, 4th, 5thFor my existing Row 1, I want a formula that will return each in its own column:K1st2nd3rd4th5th6thAs you can see, the length of characters isn't consistent, but the comma consistently separates the fields I want. How can I use the comma to separate out the text? I've found a way to extract the text before the first comma (LEFT({selection 4}, FIND(",", {selection 4}) -1), but can't figure out the re

For my small business, I have three levels of information I'm trying to manage. I have (a) the human client, (b) their pet, and (c) the services that they want for their pet. Each human can have multiple pets, and each pet can have multiple services. The projects themselves occur at the pet level, since one human might come back multiple times with different pets, and all the services for a pet occur at once. A pet will not come back for more services again in the future, so it makes sense that we could consider "pet" to be the main unit of analysis (sorry, I'm a social scientist by training, forgive my lingo). A big part of my work is thinking about how I complete tasks by what services I need to do in any given day; in other words, Spot might need Service A, Service B, and Service C done, and I care about knowing what services I've already done and what I still need to do for Spot. Although Service A is always "Service A" for every pet, the price for Service A changes depending on

My table has 3 fields:One field is country selection - e.g. USA, EU, Canada..One field is product - e.g. table, chair, cabinet...One field is supplier - e.g. supplier A, supplier B, supplier C. Does anyone know how to set rules/conditions in SAME field of airtable FORM INTERFACE at below scenarios?  Scenario 1 - select USA and table, filtered option is supplier AScenario 2 - select EU and table, filtered options are supplier B and supplier C I am not familiar "add condition" or "add condition group" in form filtering. Pls. advise if you know how to do it. Thank you.   

I spent a couple of hours experimenting with Google Colab and the Airtable API to figure out how to create a new table that includes a singleSelect field.I'm sharing the example I needed but couldn't find.This example illustrates how to structure the JSON to define a new table with the following field types:a number field (with precision)a singleSelect field (with and without predefined options),a singleLineText fieldHere is the example I needed: # Define the data payload for creating the new table # This example demonstrates how to structure the JSON to create a new table in Airtable, # including different field types such as "number", "singleSelect", and "singleLineText". data = { "description": "Table description", "fields": [ { "type": "number", "options": { "precision": 0 }, "name": "Number Field Name" },

I have setup an automation to create a new event in Google Calendar. I need it to be an All Day event however, the automation does not create it as such. Instead it is adding an arbitrary time to the event, in this case 12pm.I am using the same Date field from my table as my Start and End times and the date format in the table does not include time. I am also including the same Date field in the All Day Event option when configuring the automation.Does anyone know how to create an All Day event in Google Calendar through an automation?(I do not want to make the Start Time 12:00am and End Time 11:59pm, it does not create the same type of formatting that an All Day event has on GCal.)

Hi hi.I'm stumped. I set up a ridiculously basic automation for a client to send an email at a scheduled time. It's set up as follows:Trigger: at 9:00am on the 15th of the monthAction 1: Find Records that match a condition (billingStatus = Bill By Month)Action 2: Using the records that were found in Action 1, send one email per record. Each email has my client's email address as both the bcc: and the Reply To email. The Run History shows that earlier today, the automation ran once and 4 emails were sent. But my client got 6 emails! 2 were correct and only were sent once = yay; 2 were sent to the same email address twice - one with the right information and one with the wrong information = boo. So it's not happening every time to every email.The attached multipleEmails picture tries to tell the story of what my client sent me using yellow and blue arrows. The emailExample picture shows a redacted view of the automation run history: each cl

I’ve just started diving into Airtable and have successfully setup our Jira Cloud instance and synced the data into a base. This seems relatively useful, however not being able to update fields and sync them back is quite a big drawback. Are there any workarounds to this? Is this feature anywhere on Airtable’s roadmap?

Hi. Sorry, but I'm struggling to know how to do this. After my automation sequence, I want to update a date field with todays date to show when the automation ran. I've searched hard here, but I cannot find a way to do this. I've tried a formula in the chosen field to update, but formulas don't seem to be accepted in the 'update record' module.

Hi everyone.I'm helping a teacher to manage student's lessons.Let me tell the need:There are lessons that students have to assimilate.Each student is in a group.Each group has courses.During this course, teachers note progress for in lesson for students (students are following different lessons in the same course).A teacher should be able de note easily the student's progress.It should be possible to check the global progress of each lessons for students.I don't know how to do it, I tried different architecture with no success.Please, could you help me?

Hi everyone, a coworker and I are designing a new AT system to help our communications team manage content production, marketing campaigns, and individual tasks related to both content and campaigns. To solve for multiple needs and use cases, we're thinking of creating a standalone base for each one of those buckets (content, campaigns, tasks) and using two-way syncing to make sure they're all talking to each other. The issue: When our team leaders create a new campaign in base 1, they also want to create new pieces of content (stored in base 2) and assign that content to team members as part of that new campaign. They want to be able to fill all that information out in the same place. Is it possible to design an interface form (or just a form in the data layer) in base 1 that could be used to fill out both campaign info housed in base 1 *and* content info housed in base 2? And if so, could someone show me how? 

Hi, my interface was working fine before (like a couple of weeks ago).I created an interface where I can add a "payment" to a given "instalment".As you can see in the screenshot : allow users to create new records is activated.But in reality, I cannot... To me this is a bug... How do I report this for a (fast) fix please ? 

Hi guys, I'd like to share a section of views (these 14) is there a smooth way to do this without sharing all of them individually?I don't really want to share the whole base as there are tables with sensitive info in themAny and all help appreciated!

Hello, I am trying to set up an automation that is sending out all our Purchase orders as an email via a shared distribution list.I can link my account, but I do not have the option to choose the "send as" Example: me@test.com  is my account and I also have access to the procurement@test.com distribution list. I log into my account in the "send email via gmail" automation, but after that it is linked to my private email. I can choose the distribution list as a sender via Zapier, but I would like to cut that out. Thanks for any help and advice

Hello All,I wish to create an if formula which will return a Month Year result based on if a date falls on or between two dates.For example, if date A is on or between date X and date Y then return Month YearThink along the lines of budgeting and expenses:if Paid Date is 01/02/2024 (Date A)and because Date A is on/or between 15/01/2024 (Date X) and 14/02/2024 (Date Y) (Budget/Expense Period)Then return January 2024 (because January period is 15/01 to 14/02)

Hi Everybody! since start of the year I've noticed a change in the behaviour of one automation, that is causing me a lot of trouble.In a table I've a formula field that generates the ID necessary to link the record to another one in another table. The automation copy this formula field in the link field and the association is done. The link field as the selection limited to a specific view. Up until recent, this automation as worked very well, but now is not selecting the linked record only in the specific view, but outside of it.Sadly in the table that need to be associated, there some ID that are identical, so the association is not correct anymore. For this reason the selection on the link field on the first table was limited to a specific view, and it worked just fine, but now is not the case anymore.I know that the better solution would be to change the formula that generates the ID of the second table, so that they are unique, but this h

Hello everyon, so I have created this project management based on the template. I have got around 10 people in the group and how can I do that when each person logs into that base it will show tasks by name individually? Cuz for now you have to do it in condtions