Ask the Community

Hi!Please excuse my lack of knowledge as I am a novice user of Airtable, and also not familiar with databases.I am seeking guidance and help on a small matter.I have collated birthdays and anniversaries of my friends, about 900+. I have created the base and the Table and called it 'Master View'. Now in this table, I want to have a 'Daily View' wherein based on the date on a daily basis, I get to see the sifted data of only those who are celebrating their birthday and anniversary on that day. I can then share the link of this 'View' with all my friends for a better coordination amongst us on daily basis.Please help. Thanking in advance.(The fields in the 'Master View' of my Table are Name, Name of Spouse, Date of Birth, Date of Marriage, Contact Number, and Mugshot (photo) of the person.)

Hi,I'm having trouble with Airtable displaying options off the visible screen. So far I have experienced this with automation menus (first image) and creating dropdown fields (second image). Is there a way to force these menus to only appear on the visible sections of the screen or a way to scroll these back into view?Thanks for the help.   

I have a shared view that should react to data that has changed in another table in the base, however it seems to take a while before the change is reflected in the shared view. Does anyone know what the frequency of the cache refresh for a shared view is? Is it possible to change it?Essentially I have a directory of freelancers that can be used by all contributors to network with each other. Part of that networking is finding out who is near you. Each entry in the directory has a long and lat associated with it and I have implemented a function that calculates distances based on who is selected in a linked table (i.e the person selected there is the point from which distance calculations are performed).I've implemented it this way so that I don't have to get charged for geocoding API calls and because the contributors are not users on my base (they don't have Airtable accounts, they just contribute by filling in their details on a form and viewing the directory by the

I've got two tables "Table A" and "Table B", that are linked. Table B utilizes the look up tool to pull certain information from Table A. However new records were added to Table A and the lookup on Table B isn't pulling that information. There's no view, filter or automation conflicting with this so why are newly created records not being found by the look up tool?

I am trying to combine two fields into one. Both fields have a date and I am getting an error message when I try to combine them with & or Concatenate formula.  DATETIME_FORMAT({Date PL NT}, 'l') & " " & DATETIME_FORMAT({Date of PL Local Orders}, 'l') HELP!  

I am looking to build a base for Tradeshow scheduling, deliverables, budget, attendance, and post show statistics. For context we are a manufacturer who attends other tradeshows with a booth and a set of products. My role is to make sure the marketing materials are created and produced, the logistics of products and booth to be delivered, while staying within a budget.The goal would be to track the amount of time until a tradeshow and track the deliverables and their due dates needed before the tradeshow occurs. Separately I would report the budget of the tradeshow as a whole (if we exceeded or came under) along with the activities that made up for it.As a stretch goal, i'd like to create a form that would populate into the base with Tradeshow Name, Dates, Attending, Goals, and budget which would create the backfill dates of tasks leading up to the tradeshow.I've drawn out how i'd like the data to be in relation with each other as well as a form design i'd

Hello, As a noob in the field i would like to discuss what content/guide should i study to prepare for 2024 API changes. We use Adalo and Airtable with no automation on AirtableI was reading this guide from Adalo:https://help.adalo.com/integrations/airtable/connecting-to-airtableApparently if i get it right, i just have to change "the bearer key" while the link to the base record "https://api.airtable.com/ecc..." remain the same? Thanks

Hi all,I want to use a formula to group my outgoing payments by week. The tricky part is that I want to start the week on Thursday (so it runs Thursday to Wednesday). Can anyone help me with a formula for that please? TIA, H

I've been trying to update a multipleCollaborator field without overwriting. Specifically I have a lookup field with user IDs and I'm trying to copy the same IDs (hence collaborators) to another (empty) collaborator field.This should be relatively simple and yet i get a "TypeError: record.getCellValue is not a function or its return value is not iterable" // This script downloads all the Auto-Requester's Collaborator IDs and re-prints them in Requester const config = input.config() const recordAT = config.recordAT const autorequester = config.autorequester const requester = config.requester const table = base.getTable('Deliverables') console.log(autorequester) for (var arID of autorequester) { let queryResult = await table.getView('All All').selectRecordsAsync({fields: ["Requester"]}); let record = queryResult.records.find(r => recordAT) console.log(record.getCellValue("Request

Hello, I just made an API request to Airtable that failed, and I don't have enough traceability data to inform me about the details of the request for which the API request failed (e.g.: the different fields and values in the request body).Is there any log store where I can see all the requests (or at least just the failed ones) made to my Airtable base via the API? Or is there any way to query for these failed requests via an interface/API?

I have a Pro account, but want to allow some users to have Read Only access to an Interface I have created. I did the Share, but it doesn't show up for them on their login page anywhere we can see.Is there something I am missing to get them to view the interface?

Looking to use a button that when clicked, links that associated record to other selected records.   

I have a table with one field for start date and one field for end date. These dates are looked up from another table. I want to have a field that shows a concatenate of the two. Here is what I have: CONCATENATE({Estimated Start Date},"-",{Estimated Completion Date}) This is what it’s returning 2020-02-24T00:00:00.000Z-2020-02-29T00:00:00.000Z I want it to look something like, MMDDYY-MMDDYY Thanks for any assistance you provide!

MySQL or PostgreSQL or MongoDB or some KV Database? (include table fileds and view and record)SQL or NoSQL?And what is the structure of the table of database?

our issue that we dont have laptops we use Ipad in our companynow the print function on the PDF generator Extension is working fine on Safari but it is not working at all on any other browser noting that we are using airtable web version on those applications and non of them seem to work "chrome, DuckDuckgo,Brave, Firefox, Opera "

We use QR codes and print labels using the QR codes.  However, Make cannot access the QR code anymore due to the URL's no longer working.  This happened once last week, and then was resolved.  Is anyone else experiencing this?We rely on the QR code URL and this is breaking down our entire business functionality since we can't process any new items until this is resolved.I click the URL and see 'The link you're trying to visit is not available. Please visit our support center for more information.'

A few months ago we found the "over limits" alert in our workspace, after doing an analysis we determined where our over limits attachment came from, we would like to find a way to move all the records with their attachments to another base and delete them from the origin database without losing the attachments

Hello! Thanks in advance to everyone.I'm wondering how can I create a formula which allows me to know if an event has ocurred the past week, but I don't want the event of the past 7 days, I really need the past week. For example: if today is wednesday I want to know what had happened between the monday and the sunday of the past week.I have done it by this formula: IF(DATETIME_FORMAT(SET_TIMEZONE(NOW(), 'Europe/Madrid'), 'W')-1={EVENT WEEK}, 1, 0), but the problem with this formula is that it is not going to work the first week of the year, because, obviously, that is the 1st week and the last week is 54 so the formula

I have two data tables;Table 1 has records with "recommended zip codes" these zip codes are in a single delimited fieldTable 2 has a data table with zip codes and corresponding populationsUltimately I just want to find the total population for all zip codes listed in the single field (even within an interface)I can see this being solved in two different ways:a formula to recognize each separate value stored in the same fieldsome way to separate all the separate zip code values into distinct columns within the same recordAny ideas on how to solve for either of these? 

I am looking at to allow users to edit data stored in airtable, without being airtable users. I know how I can do this with form, or with mini extension but I am looking for a solution that would allow user to see all the data in a table, and be able to update the table directly. I have a way to make this happen with a sync between google sheet and airtable, with Make, but I am wondering if there is something else I could do here, more direct. Thanks for your help!

Hi all! I am back looking for support with a formula to return a date based on a "created" date and a variable.So far I've been trying to get an IF statements with a DATETIME_FORMAT included to work, but I'm making no progress...My Goal: Create a column that shows an Estimated Pickup Date which is either 11 days after the created date, or 6 days after the created date if the "rush" checkbox is ticked.This is what my columns look like:Any brilliant minds out there who can point me in the right direction?Thanks in advance!Devon

I'm trying to create an inventory management base. I have two products that use several parts to make. I want to be able to enter the quantity when I buy the parts, and then when I manufacture, have those numbers subtracted from the quantity of each part.So product COF01 uses 1 jar, 1 lid, and 1 desiccant with 70 grams of coffee. I don't know how to get the 1000 quantity manufactured to translate back to deducting 1000 pieces from each part and then 1000x70 from the coffee product.In my products table, I don't know if I can list all the supplies in one field or if each piece needs it's own field.I feel like this should be simple but I'm completely stalled.

Is it possible to create conditional views of events in Calendar View?I'm trying to build a publicly-accessible calendar of events. Some events are open to the public. Others are private. For private events, I want to limit the information about the event (just showing that something is taking place on a date during a specific timeframe so it's known that time is unavailable). For public events, I'd like to show information about the event (I have Event Title and Event Description fields in my table).So there are two overall goals:Show all events so that viewers know those times are unavailable to rentFor public events, show some details about the event.

Bonjour j’aimerai savoir comment fait-on pour intégrer notre logo dans un formulaire fiche ?  

Hello, everyone, This is my very first attempt at using Airtable, and my first question here. My name is Rosane, and I am a programmer. We are moving our processes into Airtable, and I expect to have lots of questions coming up. I have watched several tutorials, but am not finding the answer to my current question. I need to count records in a base, and only display groups that have 9 or fewer records. I grouped my base and collapsed all so I see the counts, but I can’t figure out how not to show all counts. Any help is very much appreciated. Thanks, Rosane