Other Questions

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

I need to build this /dp/B079KHS5CY This part B079KHS5CY comes from my “Data” column. How can I combine this together to form a proper URL? Thanks in Advance

Recently I began changing over from gmail to apple’s mail. I usually sign into airtable with apple–that is, not with an airtable password. I couldn’t sign in because the new apple email wasn’t recognized as a member, of course. So I hit, “forgot password” and made a password. I signed in with the new password and gmail account. Then I went into my account and changed the email to the newer one at apple. Now online I cannot get my workspace at all. It is still on my phone (perhaps still signed in with old mail?) I tried changing my email back to the original one, but that did not help. Is there anyway I can get the workspace back online? I’m afraid it may sync my phone and then I will have lost all my info.

I’m syncing a table from 1 base to another which contains 30 or so employees and their daily salary on a project. At the end of the day each day, I would like to add all the employees and their salaries to another table, the data table, in the base. As I add employees (or offboard them) I would like to only those people in that day’s list. Do I need to have 30 different automations, one for each employee? And how do I deal with employees being onboarded and offboarded? Perhaps a script or something can elegantly solve this? I do not know how to build scripts personally. Any advice on this relatively straightforward but hard for me issue would be greatly appreciated!

Hey! I use Airtable to plan a basketball practise. I bring the information for each exercise by pasting it from Excel into the “exercise plan” table for the participating athletes. When I paste the Excel data into the Airtable, the date field changes to a text field. Can anyone tell me why this is? I have modified the field types in Excel and Airtable in many different ways, but the problem recurs over and over again. I have a similar table in another account and this problem doesn’t recur there?

Sometimes I need to copy a record from one table and paste it into another. Until this week, I was able to do so with no problem. However, now I’m having an issue with multiple select fields. For example, one field is for a person’s availability, and they might select three days (e.g., Monday, Tuesday, and Wednesday). When I paste the record into a different table, it creates a new option within that field called “Monday Tuesday Wednesday.” I want the days to remain separate. Airtable Support said that creating a new option is what’s supposed to happen, but that doesn’t really make sense to me. They gave me a couple of workarounds, which would make the process more time-consuming. Does anyone have any suggestions? Thank you!

I have a scenario where I need to create “Booking” records in AirTable via Zapier in which some bookings might have multiple “Payments”. These Payment records will already be in AirTable, but in this Zap I need to create a new Booking and relate the two existing Payments to it. How can I use Zapier to create a new Booking in AirTable and connect two existing Payments to the Booking at the same time? I’ve tried using a comma delimited list of Payment unique ids (see screenshots).