Important Update: Single Sign-On (SSO) for the Airtable Community will be required effective June 2n...
Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
I have a Teams level workspace with the following solution : Services Rendered Businesses Staff Monthly Reports YTD ReportsThe monthly & YTD reports are essentially acting as join tables for generating rollups, counts, and other formula fields to create up-to-date Month & YTD reports each time a new Service Rendered is submitted. In order for this to work smoothly for month reports, I set up an automation to relate the services rendered and businesses they were rendered to directly to the report itself each time a new SR was submitted. In order to add the new SR & Business without overwriting the others, I had to lookup and re-insert ALL the businesses and services each time. Not a big deal for one month’s work. BUT…Now, I’m ready to create a similar YTD report of my monthly reports table but quickly discovered that we will always have more than 1000 services rendered in a year, so this will not work for the YTD report after the first few months have passed. Is there a way
Is there a way I can share just a single record with an individual, via a customized link? My nonprofit runs a program where people apply and then their application goes through various stages. We have an Airtable form (as the application), which links to a base where each person’s application is displayed as a separate record. We would like a way for people to automatically view the status of their application, so we are trying to see if there is a way to share their own record with them, but only their record-- not anyone else’s records in the base. Obviously, we could copy and paste their record and send it to them, but we often are contacted multiple times by people who are wanting to know about the status of their application as it moves through the phases, so we are curious whether we could create a custom link that we can send to people after they initially submit their application. The idea would be that they can then return to the same link periodically to see updates in t
Hi everyone, I’m new to using Script in airtable and was using ChatGPT to help me write my script. Basically, I want the script to read my table (titel is Workshop registration) and when people register, they can click on as many workshops as they want. The script was to then separate the 1 registration into multiple, and it worked! However, I changed one of the columns from single to multi-select and it messed everything up, including the set up. It also just started to bug out a lot. Do you guys know what I could do? I’m not a coder at all and was primarily using ChatGPT to help me write it.
Hello, I am using FILLOUT forms in integration with Airtable.I saw something strange, that if I define a filter on records in my database, then in FILLOUT, I can only select the records that are displayed in the database, even though they are in the table, they are just not displayed because of the filter.Does anyone know if there is any way to solve this problem?
Hi all!I publish lots of blog posts about a variety of topics and I have huge comma-separated lists of keywords for each blog post that get fed into a search mechanism for readers to be able to find content that resonates with them.I’m wondering if there’s a way to track all those keywords so that I can see, for example, how many blog posts share the keyword of “tree”? I definitely don’t want to have to select from a multi-list each time I’m entering 50 keywords per blog post, so if I have to just paste the list into a field each time, that’s fine, but it would be nice to be able to have them pointing to a complete list where I can then see how many blog posts we have per each keyword.Thanks in advance!
I created a hyperlink in a long text type field, with rich text formatting enabled in gallery view. Works good. But when folks click on the link, the whole card opens. Is there a way, in a long text field with hyperlink, to go directly to the linked URL and not open the card.
I’m missing which field/value is used with two tables are linked. Can someone point me in the right direction? In particular, I have a master business directory table and I want use automation to push in the linking value to the separate Department table. I would have thought that they are linked on the record id, but when I try to push the Department record ID into the master table, it’s not recognized. It seems to want the department name, which is not always unique. Is there a place to see the linking values between tables?
Hello!We have a dashboard interface that we share with our clients. While we filter the elements of the dashboard to show records only where an email field in the record is the same as the login email of the Airtable account, anyone can still see a full list of who has access to the dashboard and their Airtable email addresses. This has been brought up as a concern as various countries would see that as a possible privacy infringement since contact information is shared. Is there a way to hide this information to others that also have visibility of a public shared link (be it to a base, or interface)?
We have a lot of information to view when we click on a record to view its details. I find myself scrolling up and down a lot looking for the exact group I need. It would be very helpful if there was a way to easily jump to a group in the interface. Or at the very least, make the groups collapsible so they’re easier to view and expand.What do you think? Would you find this helpful?
Hi,I’m trying to create a field that tells you when the next due date of your credit card payments are, based on what their monthly due date is (e.g. 5th of every month) and today’s date. I know I’m creating a string that looks like a date and not a date itself, which isn’t a problem for me.My issue is that the comparison I’m using to check if the Payment Due Date is before today, a simple comparison of values really, is returning one wrong result! I created extra formula fields to see where things went wrong, and I cannot for the life of me figure out what the issue is! Basically, when I compare the number in Today against the Payment Due Date, with this formula: IF(DATETIME_FORMAT(TODAY(), "DD") > {Payment Due Date}, "yes", "no") I get an incorrect result (Payment Due Date 5 returns “no” when it should be “yes,” because 22>5). I don’t get it. Does anyone know what’s going on? Thanks a lot!
Dear all, I do have a base with several tables in it of which HCO’s and HCP’s are two. HCO’s are Hospitals where HCP’s (doctors) are employed. I would like to be able to select and/or display hospitals based on whether or not certain HCP’s are available in a hospital (e.g. : display hospitals which do employ orthopaedic surgeons but do not have ophthalmologists available.Tried Airtable support, which came up with scripting. Please feel challenged to propose a non (or very, very, low) code solution for this! Thanks so much,MichielThe Netherlands
Hello all, I searched a lot about my problem, I found half answer only …. It’s a common problem I found several times on this forum but no real solution (I think) I have 2 tables.The table 1 create a line in the table 2 with automation. They have the same name project, no problem for that. I have several lines which are different projects.then on the table 2 I update a cell to “ok” on a random project and I need that a cell in table 1 automaticaly switch to “ok”. on the same project line.My problem is that the “ok” from the table 2 update the first line only of the table 1 😓 How can I manage to update for exemple the project 3 cell to “ok” from table 2 to table 1 ? thanks in advance.
I’m using the pyairtable python package, and I’m looking for a way to delete columns in a table and reorder columns based on how they are named (e.g. if the columns are dates, I want the most recent date to be the left most column). Not sure if there is a way to do this using python, but I’m hoping I wont have to do this manually. Thanks in advance!
Hi Everyone,I really hope you can help me.I have a table (Client Session Log) which creates a records every time the client has a session. I’m creating an automation, where a forms is emailed out to the client after Session 2, 3, 4, 5, and 6.It works up until the email part. The email address for the client is in the Client Coaching table: This is how I set up the email section:1.2.3.4. I am getting the following error message: I would really appreciate some advice here.Thank you if you have taken time to look at this. Kind regards,Siobhan
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.