Other Questions

Hi there, I don’t know exactly whether this question goes here or under table design but see below my challenge. On my base I have different tables but the main ones are contacts and projects. Under contacts I have all person details, emails, etc and use these to send automated emails etc. My table projects I have different views and the Kanban I currently have is ‘stage’ view. We are growing quite fast and, now I would like to have a Kanban view which stacks the projects that certain people in ‘contacts’ table are running but to do this I would need to create a ‘single select’ field. This would duplicate my work as I already assign the project to a contact, linking the tables and running automations in the background. Just checking in to see if anyone can think of a smart way to stack / group by contact if that makes sense. Thanks in advance, Arnau

I have been trying to create an automation with a Google Calendar trigger where, upon the creation of a new calendar event, a record is created in my Airtable base. I can look at the appointment in my Google Calendar (9/3/22 from noon to 1pm). When I look in my base, the start and stop time values are displayed as 5:00pm and 6:00pm. The Title, Date, Start/Stop Times of the Calendar Event read as follows (in Google Calendar): “Test Event 3 Sep 3, 2022 12:00pm to 1:00pm Sep 3, 2022 (GMT-5:00) Central Time - Chicago time zone” I went back to check my automation routine in Airtable and, upon generating a preview, it shows start and stop times of 5:00pm and 6:00pm. The formula I used to translate the GMT (Start and End) fields into the correct time format is below. The format is fine. The values are wrong by 5 hours. DATETIME_FORMAT(SET_TIMEZONE({Begin GMT},‘Chicago/Ilinois’), ‘hh:mm a’) Any suggestions? Thanks in advance.

Hi, All i have created a multiselect option field in airtable and in that field new options is created via Parabola,but now i am facing the issue, Cannot create more select options for new select option xyz , due to this i cant able to add records in air table, i tried to direct add options in that field but cant able to do that, please let me know how to fix it . Thanks

Im attempting to make an app that will allow the user to select a value from a dropdown, and then the table will filter the records for that value. I’ve gotten the dropdown working, however for whatever reason the last return has an error and will not work. The problem function is the one that will update the records. How can I resolve this return error?

Hi all! I’m looking for some brainstorming help to come up with a creative solution. I am hoping to use the new limited view feature on forms to create a booking system for my team’s educational programs. Right now, we have two tables - one for the program information and one for our contacts. We have it set up that way so we can keep track of whether or not contacts return and do additional programs. I would love if there was a simple way to have a contact created and linked (or just linked if that contact already exists) when someone fills out and submits the form that populates the program information. Any thoughts or suggestions appreciated!

I’m getting an invalid hook call error, but I’m unsure as to why. My extension is intending to list all the values in a specific field in a dropdown to then select one to filter buy Error: Invalid hook call. Hooks can only be called inside of the body of a function component. This could happen for one of the following reasons: You might have mismatching versions of React and the renderer (such as React DOM) You might be breaking the Rules of Hooks You might have more than one copy of React in the same app See https://fb.me/react-invalid-hook-call for tips about how to debug and fix this problem. at resolveDispatcher (https://localhost:9000/__runFrame/bundle.js:79388:13) at Object.useContext (https://localhost:9000/__runFrame/bundle.js:79396:20) at useSdk (https://localhost:9000/__runFrame/bundle.js:25061:19) at useBase (https://localhost:9000/__runFrame/bundle.js:32768:41) at ./frontend/filter.tsx (https://localhost:9000/__runFrame/bundle.js:34:74) at webpack_require (https://localho

Currently experience a bug? I think… I’m trying to sort by A-Z on column 1, then sort by selected radio check marks? Just me…?

Trying to filter results shown on a google map. User Type A is associated with Multiple User Type B but NOT all in the data base. (Eg. User A1 is associated with User B1, B2 and B3 but NOT B4… want map to only show B1,B2 and B3’s pins to A1) Would like map to reflect that. Using Softr and it has conditional filter on lists that is perfect for this but NOT on maps. Thoughts? Work arounds? Side note: Can not be manual… needs to be automated/scalable Thanks in advance!

Hello! I’m hoping someone can help me with a nested if statement. I am trying to list a specific price for a product or combination of products. Airtable keeps telling me that I have an invalid formula, please check formula text. Can anyone see anything specific here that needs to change? IF (Foursome=TRUE(), 59.95, IF(Twosome=TRUE(), 39.95, IF(AND(IB=“IB”, HH=“HH”), 45.90, IF(OR(IB=“IB”, HH=“HH”), 22.95, IF(OR(EP=“EP”, EP2=“EP2”), 11.95, IF(AND((IB=“”, HH=“”), (AND(EP=“EP”, EP2=“EP2”))), 23.90, IF(AND((OR(IB=“IB”, HH=“HH”), (OR(EP=“EP”, EP2=“EP2”)))), 34.90 IF(AND((OR(IB=“IB”, HH=“HH”), (AND(EP=“EP”, EP2=“EP2”)))), 46.85, 0)))))))) Thank you in advance for your help!!

Greetings All, Loving AirTable. Is there a way to set up a view such that I could post a link in an email or website that people could click on, then search for their name, and see their relevant data, but not other people’s? I know this is probably a stretch, but thought I should ask anyway. Trying to figure out the best way to let them confirm their own details (hotel, dates, meals, t-shirt sizing) in an automated way that doesn’t require me emailing each one of them. I know there is an email block, which I haven’t figured out how to implement yet, but I see it requires a SendGrid Account which I haven’t had a chance to look into yet. Thanks for any assistance! Rachel Alvarez Cure CMD

Hi! Long story short, I’m demoing Airtable to see if it is right for what i’m trying to do. The situation is: My company currently uses a custom Filemaker Pro database / app for scheduling and project management that is TERRIBLE. We’ve worked with the company to try to make it better for YEARS and i’m just fed up with it. It’s slow, bloated and is costing us time and money. I’m in the process of carefully exporting the data from the database and have got almost all of it in what i think are usable excel sheets. Basically what i’m trying to work on now is how to link the data in 2 (or more)tables. I’ve got a table that is a list of projects, with client info, date, time, job number etc… I’ve got another table that is a list of our deliverables for the client, Video title, length, format, etc. Several rows that also contain the same job number in the first list. The question is how do i best go about easily accessing the appropriate data in either table from the other? I’ve been messing

good evening, I wanted to know how I can perform the data dump of several tables in a new one (read-only) that contains the information of the others and is synchronized. Thank you

45-second video: Loom | Free Screen & Video Recording Software | Loom TLDR I have a master table of URLs. Inside the base, I want the child table to match any URLs back to the master. Thank you!

Hi all, Im new to Airtable and was hoping someone could help me with a work around to a feature I don’t think is available yet. I’m looking to create a booking system for my small business where I take some of the customers details over the phone (name, phone etc.) but they then finish filling their other details (address etc.) out via either a sent form or a private version of the form via our website. Is something like this possible using airtable?

Hi, I’m trying to add a column that will display the date which each individual primary record was added in to Airtable basically displaying some sort of a log I guess of when the record was first added Any ideas???

Hello! SO in my base I have records of staff, then I have records of their positions (designations), and then I have the projects. I have done some ong winding process by which we enter transfer aof staff and then we track the last transfer of the staff and allocate that person to that project. The place i need assistance is, that I would like to have a list infront of the projects as to who is the person of that designation against that project. Ie - To find for a project - chart of the people as per their designations. (I have attached a photo showing the new part i would like added). So the objective is to create a chart showing project wise people as per their designation. This is required when staff needs to be transferred for a new project or when a project is winding down etc. I am still filling up my own data and just working with some sample text. Thanks! Vatsal.

Here I can see the customer name but in form it doesnt show up

Hello, I am new here. I’m a French person, so please pardon in advance if my English is not as it should. I have been in 3 days and not managing to get to a solution. I use the template Script Create records for multiple templates from Airtable templates. It used to work super fine. I have a table called TypesMission that list all the sorts of Missions I have to manage (like Projects). Then there is a template table for the Missions, called ModelesdeMission from which the data come and generate records in the Taches (tasks) table. The script runs from a button field in the Missions table (junction table linking the clients to the tasks). I am trying to upgrade the script to enable me to copy by program 2 fields in the child table : one is a singleselect, the other a link field. This would allow me to further automatize my workflow. In singleselect I store the ‘Responsible person by default’, I would like to have it copied for each task created in the link field I store the Dependency

I’m working on an AirTable system that someone else started for me, and learning as I go. I’ve got 3 Tables. A = Staff, B = Assets, C = Access. On Table B I’ve got a Link Field to table A, so I can add a Staff Member’s name in a new record, and then add an asset against their name. I’ve also got a link field in Table A, linked to Table B, and it shows me a list of all the assets assigned to that member of staff. This was already made when I took over and works perfectly. As soon as I add a new asset and assign it to a member of staff, the asset is added to the list of assets in the Staff table. I’m trying to create the same effect in in Table C. There’s already a link field where I select the staff member name, and then I assign them access rights to certain software. I’ve created another link field in Table A, expecting it to self populate with all the different software that the employee has access to. But it just sits there empty, waiting for me to manually select the software. And

Hello - I am using a simple formula of: DATETIME_DIFF({Today},{Start Date :star: },‘days’) to calculate the number of days from the Start Date to Today. I would like to combine an IF statement to do the following: I only want to return a number IF the Field ‘SOP Status’ contains the words ‘On Ramp’, otherwise return a blank result. Any help is greatly appreciated. Thank you

A Quick Prelude This morning, I was blankly staring past my monitors in a strange state of disassociation. On my screen was the commit history of a substantial git repo. While clearing out stale branches, I went down the rabbit hole of examining each engineer’s stylistic approaches. Commenting out versus deleting old code. Writing references to previous commits in comments. How some engineers write intuitive variable and function names, while others might name them rather generically. While some of those examples get called out and corrected in PRs, it left me with a lingering curiosity about our stylistic and functional choices when working with Airtable. This is a rather open-ended discussion, but I wanted to open it up to see how everyone likes to do things. It could be anything. There are some things that I’m personally curious to know, but I’d encourage anyone to jump in and share anything that you keep in mind when you are planning, building, implementing, and working within Ai

Hi there, I run a charity with volunteers who help feed and medicate local street dogs in Thailand. I am trying to create a database to keep track of their medical expenses. There are two types of expenses at the vet: medicine and vet fees. I’ve created an “Order” table, which connects to two respective “Line Item” tables (medicine & vet fees). In main grid view, the Order table works as expected. For example, I can create a new order, then add line items for medicine and or vet fees. Then those line items are rolled up and gives a grand total. The problem is in using the Form view on the Orders table: I can add existing records, but cannot create new ones, which is necessary. I really would like to use Form view so that my volunteers can enter data easily without really having to get involved with the grid view. Also, it would be really useful if the form could display calculated fields. This could show calculations like Grand Total. These calculated fields simply do not appear at

Hi I would like to use the extension to convert URLs to PDFs. It works for sharepoint URLs but I can’t get it to work for google docs - any idea how I do this? thanks! Clare

Hey there! So I am wondering if there is a way to hide specific options within a field. For example I have one Multiple Select field which features start and end dates for film festivals (1 - 10 Sep 2022, 2 - 20 Sep 2023 for example. In my main view, I would like to view all these options as it is a handy way to look back at the years for previous festival years. However on separate views, I would like to pick and choose which options appear, for example if I am sharing a view with a client and only want to talk about 2022 dates, I would love to hide the 2023 dates to not confuse anyone. If anyone knows an answer please let me know!!! It seems you can hide lots of things including fields however hiding options within a field is very tricky. Thank you!

I have a field with multiple select; I need to get a count of EACH selection AND would like to display each response with the count. For background: the field is part of a survey and those filling out the form choose all that apply to them. I tried the linked field route and it counts everything in the field; doesn’t separate them. Do I have to do a linked field for EACH option? I’ve looked at several related items in the community but it all reads like a foreign language that I don’t speak to me…