Ask the Community

Hi Guys, I'd like to use Airtable to build a utility settlement tool with the tenants. My tenants pay an advance for utility every 6 months; after 6 months (this period might differ), I record the meter reading and fixed and variable utility prices (the utility prices might differ between months, it's not common, though) calculate how much they should pay vs. how much they paid in an advance. I have 6 tenants. I use it for the following utilities: electricity, heating, and water. I've been doing it in Google Sheets so far, but AirTable interfaces would be useful for me. I'm trying to figure out the tool's structure: if I should put the dates of the readings in rows and the utility kind in columns or the other way around. Do you think it makes sense to use Airtable for this purpose?  Thanks for your help.

Hello All,I've been attempting to create a more efficient way for my organization to sort through volunteers and create a matching system to the elderly. So far, I've created two main tables: Volunteers and Old Friends that are populated by a use of forms. There are certain columns that are referenced in the forms controlled by other tables i.e. hobbies. Using Scripting in an attempt to create a system that can sort through the Volunteers table and Old Friends table to match based on the hobbies (to start, I plan on using other variables once I get this part working). Any help would be greatly appreciated!Here are the links to the two tables:Volunteers - https://airtable.com/app63KIAsdReM2VbZ/shrsqIBAQVIhCcfEAOld Friends - https://airtable.com/app63KIAsdReM2VbZ/shrLDOcutrx5CNfjRThis is what I have from Scratch but I'm unsure where I am going wrong: // Fetch the tableslet volunteersTable = base.getTable('Volunteers');let oldFriendsTable 

UPDATE: found out this was due to a formula error, which left the deadline date field in #ERROR for the affected records. SORRY not to have noticed it before posting.rgds,Björn---------------------------------------------------------------------Hi,Sending out personalised e-mails with repeating group automation. Out of a bunch of 96, some 5 just failed with a quite unhelpful ""Subject" could not be converted to a string" message.The e-mail subject field uses a variable to fetch a deadline date. For 95% of the e-mails it works like when tested, for 5% it doesn't.Any ideas how to troubleshoot? How on earth does it work for some, but not for others? It's the same data that is retrieved for all.Rgds,Björn

Why does my primary field total display xxx Stories on some dBases and xxx Records on others. OK, dumb question, but I had to ask... and it's not in the AT Glossary of Terms.

I have 3 records:MembersSkillsMember Skills Xref (a linked table that joins members to skillsI have seen the tutorial on how I can edit a member record and add skills to the member using fillout.com, but is there a way to display the skills associated with a member when editing a member record?  In other words, I want to have the parent record and show all the detail records (skills).Thanks.

Hi,I created a script which takes data  in a project financial table and updates special table with payments report.I'm going to setup it to run daily or weekly automation, and add it to many projects in different bases.Problem with updating a single-select field 'Type' (of operation), when new Types appear.here is the issue, automation can't do that (script extension works ok):thinking about workaround - use preparation script, compare and check whether new types available, output them in variable 'newtypes', find any random record in destination, loop Update it's 'Type' through the list of 'newtypes', then return the old value.Then run main script.More clean solution, to avoid affecting Modified Date of existing record could be - Create new record, Loop update it with all new types, then delete it (by script).Unfortunately, Loop must be in the end. Can't return old value, can't run main script(I put 'List of record IDs' in 'Record ID'(to update), it's not quite correct, but

Is there any way to use formulas and linked at the same time? I want a column to add data from the columns A + B + C to = ABC and then have ABC show up on a different tab. Is that possible? 

I'm using a public airtable view with a button that passes data to a web form. Works on desktop but not on mobile.looks like this: "https://myurl.com/bid?bid=" & ENCODE_URL_COMPONENT({Deal Name}) & "&new=" & ENCODE_URL_COMPONENT({Current Bid Value}) & "&id=" & ENCODE_URL_COMPONENT(DealID) I had to flatten a lookup cell and turn it into {Current Bid Value}, which works. But for some reason on mobile it clears the query string. It should pass something like this: https://myurl.com/bid/?bid=Joel&new=120000&id=recaAB2Q4b8H2iYgL  Instead of: https://myurl.com/bid/ any suggestions?

I'm running into issues duplicating tables because of field counts.I can create a new table and copy a record over and it pastes all the correct fields but all the links and lookups are broken.My newest method is to link the record back to a main table and bring in all the fields as lookups but that as a (from {Table}) to the end of each field. A) is there a way to prevent that addendum to the field name OR a way to bulk remove it? Like with an script and via API calls?

Hello! Here is my situation and what I would like to get accomplished: I have three tables, 1,2,3. T1 has a list of candidates, who will either pass or fail (based on my selction of a single select value). For those who pass, I want to add their data to T2. Now this is simple using a Linked record in T2 that points to the record in T1. I am using T3 to host values. I consume these values in T2 as lookups in order to make some calculations. (eg. if score<T3 score then “expert”) My question is, when I add a new person from T1 to T2, such that they appear in t2 thanks to the linked reorc functionality, how do i also call the records from t3 in order to keep doing the calculations? It seems every time there is a new record in t2 i have to also copy paste the linked records from t3 for them to show up in their respective lookup columns for the calculations to make sense. I tried filtering by those t3 linked record values thinking that any new record will auto-populate the corresponding l

Im trying to write the same formula I have in excel in to Airtable and Airtable erases everything but the first if(and()) statement. IF({Statement} = 1, "3",     IF(AND({Statement2}<=50, {Statement2>0),1),     IF(AND({Statement2}>50, {Statement2}<=100, 1.5)),     IF(AND({Statement2}>100, 2))) I don't get any errors, it just erases everything after that first if-and. Im sure it's something small that Im doing that's causing it not to work but I cannot seem to figure out exactly how to write this in a way that returns the values I need. This entire document is essentially going to be built like this because it relies on data from 3-4 columns. Thanks for your help.

I would like to set up and automation that "At 9 AM every Monday, Airtable will automatically send a Slack message to a user if a certain condition is met (e.g., "Task1" is set to "Pending Activation"). The Slack message will have an actionable button (e.g., "activated"), and when clicked, it will update a specific field " Task 1" in Airtable (e.g., changing "Pending Activation" to "Activation"). But the test result is negative and showed received invalid inputs.    

Does anybody have a good workaround for delaying email automations for (example) 10 minutes? Our situation: When a project goes over budget, an email is sent to the project manager But: the email will go immediately, which is a problem, because the project manager might simply be in the process of updating the record, and once he’s finished with his updates, the project might not actually be over budget. Therefore, we are getting tons of false notifications. What’s needed: Some sort of pause before the notification is sent out, where Airtable checks to see if the situation is still true for that record, before sending the notification.

Hi! On my table I have three fields, "Start Date", "End Date", and "Week Number". I am trying to make an automation that extrapolates the week number from the date range. I know there is a formula that does this but I'm looking to have the field be a single-select color-coded field. I have an automation that is working out well but I can't figure out how to do the automation so that it would automate multiple weeks if the start and end date spans multiple weeks. Current automation: If start date is 1/1/25 and end date is 1/3/25, return week 1. Where I want to get: If start date is 1/1/25 and end date is 1/9/25, return week 1 and week 2. Is there an easy way to do this? 

Hello dear Community,I am brand-spankin' new to this platform. I am doing a trial interview in a few weeks and the organization that I am interviewing for uses Airtable especially for managing their staff and for their intense travel and organizational schedules. Might anyone have a referral for me either a mentor/tutor or for a program that I can access online? Thank you! 

I am working on a seating chart for an event that has 150 tables of 10 and want to create a base that will help me assign people to tables, track how many open seats I have at a table etc. Any suggestions?

Is anyone else seeing the Apply button in their filter conditions?  It showed up some time this week but it's not in every table.  This is annoying! Is there a way to turn it off?There:Not there: 

Can we please get an option on Air table that is a fixed monthly rate for either unlimited or a large, allocated amounts of users! I need to scale but paying $54 per user per month when we need 20-50 users is an insane amount of money just to be able to tag the correct person i need to assign something to. Does anyone have a workaround for this so I can delegate tasks to people and actually have them get a notification???? 

I have a table <TableA> whose records <TableARecord> have a field <LinkedRecordB> which is linked to records of a second table <TableB>.I am try to use that field <LinkedRecordB> for automations and I don't see how.If I try to use it in a Condition Group, when defining the condition I can only use the record ID and Name.If, as a workaround, I try to find the corresponding record in <TableB> using a "Find records" action with "Find records based on" when trying to defined the condition I am not even able to select that field <LinkedRecordB> and get an error message when hovering stating: "No valid nested options"The only solution I have found is using adding another field of type "Formula" in <TableA> an getting the Name of that linked record <LinkedRecordB> and then using it in the condition in option 2.Am I missing something?

Hello. I'm brand new to airtable. Less than 2 days. I'm struggling a lot. I have a table with basic member info in it (member id, first name, last name, email, etc).  Now, I want to create a form, let's call it "sign up for party". I want the results of this form to populate another table, but be linked to the data in the main members table.When I create a linked field in the form, it shows EVERYONE in the table!! That's a huge security issue!! I want people to enter their member id into the form and have that id validated that it exists on form submit. When they submit, the record should be created in the new 'signups' table, linked to the main table.how do I accomplish this? This seems fairly simple/common, yet I've spent 8hrs trying to figure it out.

Greeting ! Attached image explain the question, Thank for your support.

I want to share an interface with my teams (more than 10 users). They just need to edit/update some data on the interface, but when I want to share with them, I need to change to 'Editor'. So, there's more than 10 editors in 1 interface. I'm using Business plan (annually).  I don't understand at the part where I need to pay for each editor, which means the bill is not fixed and it will be added for each 'Editor' I add? Does it actually include in the bill, no extra charge or what? Can't I just share with my teams without extra charges?

Hi Community,  is there any way to use Assignee fields from Airtable in Fillout? BestMirko 

I have a formula field that gives me a date.then I have a normal date field "current". For example, if I enter a date in the "Current" date field, then the formula field should calculate 2 years from this date and give me the date in 2 yearsExample: “current” has the value: October 1st, 2020Formula field calculates 2 years further10/1/2022works quite well so far If the “current” field is empty then the formula field should take the date of “approval” and calculate 3 years from there.Example:“Approval” has the value: October 1st, 2017 then the formula field calculates 3 years further so: October 1st, 2020 also works.but every time this formula is executed, I get a linked tablea new data set is simply created even though this is not what is wanted.here is my formula:  DATETIME_FORMAT(IF({Letzter HU/ AU Termin}, DATEADD({Letzter HU/ AU Termin}, 2, 'years'), DATEADD({Erstzulassung}, 3, 'years')), 'MM.YYYY')  

I recently saw that we can create Kanban views using LinkedIn fields and not just single-select options within that table. Question though—how do I change the order of these columns? They seems to be sorted automatically although it's unclear how it's being sorted. For what it's worth, I can't manually change the column order (which is what you could do for the single select fields)...