Other Questions

hi! i have a field that is linked to another table, and that field is a date. I’m trying to sort chronologically, but from what i see, it can only be sorted alphabetically. is there a way to change the settings of the date to yyyy-mm-dd in numbers instead of mm-yyyy now so i can sort chronologically? or any way to do that? thanks!

The article The primary field – Airtable Support doesn’t explain why rich text formatting should be blocked. Is there any reason to do so? For security?

Hi! I’ve been playing for quite some time now and just can’t get a result. I want to use Airtable as an inventory management tool. In a table orders are automatically imported via the store. One row is automatically created per order. There I get the product with SKU and the associated size. My problem is that the SKU is the same for all sizes: Product A Size 11 (SKU: 123456) Product A Size 12 (SKU: 123456) In a second table I have created the products and entered the stock level. Now I want the stock level to change automatically as soon as an order is received. Maybe you can help me? Thanks

Hi everyone! We’ve been working on a tool I wanted to share with the community. After months of private beta, we’re publicly launching our Airtable x Webflow sync at Whalesync! It lets you sync your Airtable data to your Webflow CMS instantly . The problem Airtable is the best place to manage your data. Webflow is an awesome frontend website builder. The combo allows for really powerful creations, but connecting the two is hard. Trying to do this with automation tools like Integromat can be complicated and brittle… especially when it comes to things like linked records. The solution A super simple (but powerful) way to sync data from your Airtable base to your Webflow CMS. You just map the collections/fields you want to connect and Whalesync creates a real-time sync. We support the major field types out of the box including linked records and rich text fields. How we’re different :zap: we sync in real-time :keyboard: we offer 1:1 support via Slack/calls :rocket: we’re a grow

I have a script that takes a small amount of time to run. While it runs, I want to use the full width of view I am on, so I close the app slide out. That also stops my script. Is there a way to configure this from not happening? I would like the script to continue running while I get other work done.

I am making a GET request to an airtable collection (the data has the form of a list of jsons). I am trying to add a filter according to the documentation but because my data is not relational but json-like, I can’t access the fields inside the records. With an example: The simple GET output: { "results": [ { "id": "12345", "date": "2022-04-14T05:14:16.000Z", "info": { "username": "random1" }, { "id": "123456", "date": "2022-04-13T15:14:16.000Z", "info": { "username": "random2" }] } I would like to filter the date and/or usernames, doing something like: https://api.airtable.com/v0/myBase/myTable?filterByFormula={results}{date}>“2022-04-13” Thanks!

We have a form that populates information into a table - the Private Directory (only organizers can see). In this form, one of the questions is what information the person filling in the form consents to sharing in the Public Directory (everyone in the organization can see). Then in a different table - that is in a different base - we set up a directory that can be accessed by everyone in the organization and it shows records of people with only the information they consented to share. Currently, we are building the Public Directory manually: going through the Private Directory and creating records in the Public Directory and only adding the info they consented too. The only issue is now we have reached 300+ records that need to be filtered and transferred. We want to find a solution - through creating a new form or automations - that would make this process automatic. So essentially, is it possible to create a form that populates to two different tables - one where it puts all the inf

Hello… I am using a couple of single and multiple select lists but have made a few typos and decided to change some other. So I added the new options to the select list but I can’t seem to remove the old options that I no longer need? Either this isn’t supported or i just can’t see how to do it! Any help would be appreciated :slightly_smiling_face:

I added a Table2 where i want to pull data from Table1 In Table2 i added a Column called “link to Table1” and i made it “Link field type to Table1” Then i started to adding Columns in Table2 that i made “Look up type” Example: in Table1 Column1 (Name): John in Table2 Column1: Link to Table1 Column2 (Name) Look up “Name” from “Table1”: But when i fill a record on Table1, Table2 ignores all and nothing is happening, any idea?

Hello, I am building a very simple app in which people can upload a file into floter, then that file is imported into air table. However, the data I receive from Soft is a s3 bucket. Is there a way to read the file in this S3 bucket and put it into my table?

PLEASE I NEED HELP!! I want a formula that will automatically fill in a particular word in a particular field So the plan is i want to do an automation where by when there is a check box all that data goes to another table which is the re-order list, i have different table for different vendors so i find it unnecessary adding a vendors column field but the reason i added it is so when the automation takes place and the data moves to the re-order table, i will be able to identify that that product is from a particular vendor, i input the vendor name myself but i want a formula that will automatically fill in the vendor coulumn list without me inputing it manually, is it possible? Please i really need help

I’m starting a business while still in college and was wondering if anyone know if it is possible to use the Airtable Student Account for commercial purposes. Thanks!

Is there way to export data from excel (VBA) to Airtable??

Hi everybody I want to push some data into a field(array) and I don’t find any example or comment on how to do that in Airtable. For some context, I have a table with users and another table with events, every user has a unique ID, and when people fill the form to create an event, they have to enter their ID so the event is linked to the user in a lookup field that I added in the user table. I’m okay to take the ID from the event field and compare it to the ID in the user table. I’m just not able to push this same ID in the Lookup field to connect them at the end. In this case, the user Id is named Magical Number. My console.log at the end tells me I have the right value in my filterUsers variable, I have the right user that needs to b connected with the right event. How do I target the right field to push the ID into it, which is an array into an array cause I can have multiple events connected to the same user? Is there something in opposition to getCellValue like postCellValue? He

i have a communication log table, when i request something from Client and he didn’t replay the record still opened , i forced to call back to the client and open new ticket , finally i found may tickets still opened , how can i close all opened ticket related to to same client automatically

Hello, I’m using the Airtable Python wrapper found here: Airtable Python Wrapper Documentation — Airtable Python Wrapper documentation I’m trying to get all records modified after some date time. My code is: AT = Airtable(BASE_KEY, TABLE_NAME, API_KEY) filterByFormula = ‘IS_AFTER(LAST_MODIFIED_TIME(), DATETIME_PARSE(“2022-03-15T14:23:41.000Z”))’ AT_ITER = AT.get_all(formula=filterByFormula) However, this is always returning every record in the table. Also, how do I get it to return the last modified date in the fields? I have tried: AT_ITER = AT.get_all(formula=filterByFormula, fields=“lastModifiedTime”) …but this throws an error. The docs say the default is to return all fields, but there’s no modified date field when I try that, either. Any help, please? Thanks! -Dan

Hi Guys, This is probably a pretty easy one - for the right person… haha. Pls see attached. This cell started as CURRENTLY AVAILABLE. Then a linked record called ‘2022 Camry’ was added, and I now have ‘2’ records in this field. How do I automatically unlink (remove) **CURRENTLY AVAILABLE", ie, updating to only leave the record called ‘2022 Camry’. Thanks!!

I am trying to a similar thing, but instead of adding an INTERGER for the multiplier in the DATEADD formula, I am trying to pick up a value form a table LOOKUP. Have also tried with a FORMULA cell and it doesn.t work either. I have different categories of appointments to book, that each have different duration and priorities TIA, Duncan

I am very new to Airtable and struggling with one piece of the puzzle. I’ve read a lot of posts and articles but can’t seem to get this relatively simple thing working. I’m sure I’m missing something obvious. I am trying to use Airtable to house information for my meal planning and shopping. I have three tables. 1-Dishes/Recipes (Where all of my recipes are stored, tagged by meal and such). 2-Ingredients (A list of pretty much every possible ingredient). 3-Menu (A menu of what I am eating for which meal on which day). All of these are working as I want. When I add a new dish, I can add an ingredient from the list. The menu pulls information such as which meal of the day a dish belongs to when I add an item. All great. The struggle is that I want one more table for a grocery list. I can manually type each ingredient onto the list, but I was hoping for more automation than that. I want it so that the Grocery List table adds a record when a record is added to the menu, pulls the ingredien

Is there a way to make an address clickable so when a user clicks it bring up a Google map for that address without utilizing a block?

Hello I would like to extract a value after “HR” word. This value can be of 2 digits or 3 digits String: 146/63 HR: 78 oxygen: 98% T: 36.8

We are looking for a script similar to Running Total, except instead of adding the previous record to the one below it, etc it would add a Units Received field to a Total Received field everytime the Units Received field is updated. How would I go about something like this?

I am using Airtable to run a daily medical care routine. Every day follows the same set of routine records all with that day’s date. “Use same timezone (GMT) for all collaborators” toggled on. I am trying to filter to get a view of “Today”. When I create a Datetime filter where Datetime is “Today”, the “Today” is defined in in GMT = 0 and I live in GMT = -6, so at 6pm my “Today” filter stops working. Is there a way to change the timezone of the dynamic filter? I have not tried toggling the timezone setting to use my local timezone, as this causes issues with my setup in its current configuration.

How can I paste multiple records into a single linked record cell so that it is recognized as multiple linked records and not a new record with the concatenated name of all the pasted records? I have two tables (Table 1 and Table 2) which are linked. Table 1 has a column which can link to multiple records in Table 2. I have a separate Excel document which lists the associations between records in Table 1 and Table 2 and am trying to determine how to paste these into Airtable to document the links between the records. For example, Table 1 has the following records: 1 2 3 Table 2 has: A B C D E My excel sheet has the following pairs 1 - A 1 - C 2 - A 2 - B 2 - E 3 - D In this case, I am trying to copy record “2”'s associations (A,B,E) and paste them into the single linked cell in Airtable to link those records between the two tables. When I copy A,B,E in their individual rows in Excel and past them into the Airtable “2” linked record cell in Table 1, it pastes A, B, E in separate rows in

I have “next meeting date” in one table (a table describing regular meetings) and then I have “event date” in another table (describing one time events). I’d like a calendar view with all those dates. I’m thinking about auto-copying dates into a “dates table” when a date field is updated, wondering if there’s something more elegant. Thanks