Ask the Community

Hi,I have two tables, one of tasks and one of tenants.In the table of the tenants I have a column of the end date of the tenant's contract.I want to automate that at the beginning of each month (on the 1st of each month) I will create a RECORD in the table of tasks with the task of renewing the tenant's contract only if the date of the end of the tenant's contract is a month later.For example, if today's date is October 1st, I want to create tasks for each tenant whose contract ends in November.Is it possible?

I tried many workarounds, but none did actually work. What I am trying to achieve: cell one has orders (700, 1000, 3000, 400)cell two has sizes (M, XL, L, S)cell three "Joint" should display 700M, 1000XL, 3000L 450SI tried many formulas and scripts, the closed I came to was: ARRAYJOIN(size & orders)but this only displays MXLLS700;1000;3000;400 Maybe somebody has an idea - thank you very much!

Hi Communauty.I have a lot of trouble with Airtable's restrictions and business logic. I have a paid Teams space in which I build my clients' projects. Once finished, I want to transfer ownership of a database and its related automations to my client. 2 questions :1- Obviously, I cannot transfer ownership of a base. Should I transfer my entire workspace where I have my personal bases and those of other clients? ! Is it correct ?2- To transfer ownership of a workspace, I think I have to create an "Owner" user who will be billed to me? But if the new owner makes a paid subscription, what should I do to avoid paying on my end?Thanks for your help. Airtable's sales department must have really racked their brains. With such difficult to understand operation, I am seriously considering switching to Baserow which is more readable.

But I can't figure it out to make this happenIt's a registration form.  We use it for a specific location, every other month.  I'm trying to reduce some of the manual overhead by trying to auto populate each record as it is submitted with the current event - which is a linked field = from a sync table.Problem is - the automation doesn't seem to support this - like it does for select fields.How I am setting it in the form is kludgy Any suggestions - I'm open to hearing them

Hi everyone!I have a form for a warranty claim. Once customer submit it, the data is visible in table "RMA" for approval. I have another table named "customers" ("Stranke" in my language) which is linked to the table RMA and where I have a list of all customers (so that I can quickly see how many request or warranty cases specific customer have). I managed to automate that once the form is submited, it automatically create that customer in the table customer and link it to the RMA table. Now I stumbled upon one problem. If I have the same customer submitting the form multiple times, it always create a new one. So I have duplicated customers. Does anyone know how can I fix this? Thank you!

Hello Airtable family, I’ve previously explored how to sort the linked records, finding the best approach was a manual sort using the ‘Batch Update Block.’ The purpose was so that when using our Airtable-based ordering system, when we clicked a customer record in the customer table, it would show linked orders sorted with the most recent orders at the top. As I’m not the only one entering orders, it’s become a bit tedious and/or unreliable to use this method. I’m looking for a way to do it programmatically, either with an automation, scripting, or using even using Integromat. In theory, I’m thinking the best approach might be an automation script that only triggers when a customers ‘linked orders’ array changes, though not sure how to set that up with views, triggers, ect. I can likely figure out the script part from pseudo code. Any suggestions or ideas to try, I’m all ears! (Or, eyes…?) Kris

If you’re using a rollup field to summarize linked records with ARRAYJOIN(), the array’s order is determined by the order of the linked records. I created this script to automatically sort linked records in a cell. My use-case is to summarize interactions with companies. I sort by descending order to show the latest summary on top. Enjoy! // Set a trigger: when a record is updated -> watch the linked records field // Set an action: run a script // You should set the record ID of the triggering record as an input variable // Grab the triggering record's ID let inputConfig = input.config(); let recordID = inputConfig.recordID; let table = base.getTable("tableName"); // Load table let queryResult = await table.selectRecordsAsync(); // Get all records in the table let record = queryResult.getRecord(`${inputConfig.recordID}`) // Find the one with the ID from the input // Get the linked records array let linkedRecordsArray = record.getCellValue("linkedRecordsField"); // Sort the link

Hi all,I'm building a List InterfaceIn that list, I have enabled the "Edit records inline" setting. Now, all fields, even the ones that have been locked in the underlying Base, are editable from the interface. How do I keep the locked fields locked in the interface?

Hi, I have managed to set up an email automation. But after the email is sent, I want to update the AirTable record with the date and time the email was sent. How do we do this? I did see Kuovonne do this with a custom script in another example. But not sure how to do this for us. @kuovonne Thank you. 

I have a database of people and one of the columns contains links to other records in that "People" database and is meant to showcase which other people this record has a relationship with. I was wondering if there is a way to update two records simultaneusly, so that when I add Person B as a relation to Person A, that relationship is reflected in both records.

Hi! I’m working on two separate base for my organization: the first manages the order, and the second the tracking and payment process. With the sync tables I’m able to get the tables from the order in the second base for the planning and processing of the shipment and payments . But I’m encountering a problem: there are some lookup fields about quantities that I need to process as number on the second base. The synced table show them as text, so the lookup on the tracking table it is also showing them as text, but I can’t modify the format to a number. I’ve also already tried to add another field with a VALUE() formula, but it gives an #ERROR! and doesn’t evaluate the text into a number. Any idea how to proceed? Many thanks, Claudio

Can we generate a sharable link to a List View the same way we share Grid View? I don't see the "Share View" button on my list view. 

We are a self-publishing company seeking an Airtable expert to optimize our database management and workflow automation. Our goal is to streamline our processes for managing over 6000 authors/projects annually.

Multiselect Field: Sprintcontainsrow 1: Sprint 24.01, Sprint 24.02, Sprint 24.04row 2: Sprint 24.04, Sprint 24.05, Sprint 24.06row 3: Sprint 24.03want a formula in new field called "Latest Sprint" to return the last entry in the Sprint fieldrow 1: Sprint 24.04row 2: Sprint 24.06row 3: sprint 24.03thanks for any help!-Mary

When I create a LIST in INTERFACE and I mark the options "Edit records inline" and "Add/delete records inline" I can add RECORDS from the computer.But when I log into the app from my cell phone, I can't add a RECORD.Is it possible to add RECORD also from the app on the cell phone?

I am a real novice at formulas and I have been unable to work out what I have done wrong. Can somebody please tell me. DATETIME_DIFF(TODAY(01-11-2019),{DOB LInk},‘Y’) I am trying to return the age of a person based on the difference between the DOB and the date in the future. What I have here works sometimes but sometimes gives the incorrect age. The problem occurs if the dob is later in the year than todays date. Airtable AYM Festival test 2019 - Airtable Explore the "AYM Festival test 2019 " base on Airtable. Hopefully the link will show that the first age (for Jacob) is correct but the second line for (Peter) is one year out.

Hello,I have shared 3 interfaces with a collaborator and have given them editor permissions. They are able to acces one of the 3 interfaces. When they try to access the other 2 interfaces they get a notification which says 'You are not authorized to view this page'.I am pretty sure that I followed the same procedure to share the interfaces and I don't think I have set any restrictions for who can see the interfaces. M is only able to view the Equipment & FAcilities Maintenance even though they have editor permission on all the interfaces.M has access to the interfaces on the desktop and they work perfectly for the permissions I have set. This issue only occurs on the mobile app on a tablet.Does anyone know what might be going on?Thanks!

I have an automation set up to add an event to my google calendar. It is working fine except, the end date it shows on the calendar is showing up the day before it ends. I have the events with no time listed because i do not want a specific start and end time for them. When i have the all day box checked in the automation It is showing on the calendar as ending a day earlier. When i make the "all day" under configurations in the automation dynamic and pick the end date it gives the start time and end time as 8AM in google calendar.  Is there a solution for this? Thanks in advance for any help!

Let me start by saying that I have been trying to do this in Interfaces but I've also had a look at the new Forms feature.What I would really like to do is present the user with a grid with 4 columns: MakeLineModel Qty    When the user clicks in the blank line under Make, they get a drop-down that lists all the current values in the Make field (unique values). Then they do the same for Line and Model, based on the selection under Make - i.e. a decreasing filtered list. They then manually enter a qty. They can then add more rows as they complete the 'form'.Ideally they would also be able to have the option to ignore the drop down selection and enter a value in any column that doesn't already exist in the data.I can't work out how to do this and don't really know if it's a form view on the Data area, a Form in an Interface or if I would use the new Forms feature.Any ideas ?

I have two date fields that sync from an Outlook calendar. Because most events on that calendar are full-day events, they have an end time of 11:59 PM. This is what it looks like with "include time" selected:...and this is what it looks like toggled off.I reviewed this similar question, where it turned out to be a time zone issue, but that doesn't apply here as the time zone settings aren't accessible if you don't show the time. I'd prefer to hide the times for the sake of tidiness/reducing visual clutter. Is there a way to fix the rounding issue without creating a separate formula field?

Hi,In the form Interface when I want to select a value from another table (linked record) I only see the name of the first column.How can I see more data on this field?Attached a picture for illustration:  

Hi. I’m having trouble getting my Slack Bot to show properly within an Airtable automation. I’ve set up the custom emoji’s within slack, and created a custom field within my table to match the emoji code. When the automation is executed, it remains as the airtable logo. ^^ inside Slack ^^ Inside Airtable ^^ Inside Automation ^^ Slack Response

Hi there, I have a script that collect a few records in my table, and I'd like to create a repeat action (to send a Slack message to each of these records). I used JSON.stringify to convert my array to a string and the output is something like: ["rec0aFuNHkPzxxx","rec2jGJ33iVxxx", …]When I try to use this script output as a list for my repeat group it says : "No valid nested options". I looked in the doc but haven't found anything about it. Did I miss something ?

Hi, I have a table where I add any investment into a company done. So, each row contains a field which is  linked record that link the investment to a record in table "company".But we can invest several times in one company. So I want to create a view that could display the last investment made for each company. I thought creating a new "single select" field called "active investment?", and having "active" option automatically selected for the latest investment made for a company. But I can't figure out how to do this double condition (having the "company" in the "linked field" and being the earliest date). Does someone know how to do something like this? Thank you,  Have a nice day 

I'm trying to create a calendar to show different dates that our personnel are not available. What I can't figure out is if there's a way to have a different label show for each specific set of date ranges as I would like the calendar to show the specific reason someone is not available during those dates.I have 5 sets of unavailability date ranges and each of those have notes that pertain to the respective date range (i.e. why that person is out). The fields are set up now as Date 1 Start - Date 1 End - Date 1 Notes, with 5 sets of fields like that.When toggling those notes on in the customize labels function, I get all the notes attached to each date range included in each calendar block. And the date ranges label function only lets you set one label for all records that have data in that date range.What I want on the calendar blocks:Date Range 1 - Date Range 1 NotesDate Range 2 - Date Range 2 NotesWhat I'm getting:Date Range 1 - Date Range 1 Note Date Range 2 Notes Date Range 3 Note