Solved

I’m about to develop a public view of our entire product database, which is one Airtable base of around 2000 records. Right now we’re having something like that in place, but basically just as an embedded view (the standard Airtable functionality) – but we’d like to enhance this public view, hence the custom developing need of it. The functionality of our public view will have to enable filtering all of the products on multiple levels – e.g. product category, price range, colour … you name it. Since this will be a public view, and hitting the api limits would happen easily with around 2000 records (I guess), I believe some sort of caching of the entire base data is in order. My main question is: how, and in what way? My first thought is to poll for the Airtable base at like an hourly interval, and saving all that data in one json file, then reading that json file on the client side with vue.js and outputting it in a gallery sort of way, with all the filters in place. That still leaves

Hello everyone, I use Airtable to manage projects and elements (Balcony, Terrace, Stairs, Separator Screen) in projects. I look for a method to automatically create drawings numbers. Indeed in elements table I have a link to projects table and for each element I create a drawing. I want drawings numbers drawing like this: ProjectNumber-ElementCode-Number the numbers is reset for each different element in same project. Example: Project1-Balcony A-01 Project1-Balcony A-02 Project1-Terrace X-01 Project1-Terrace X-02 Project2-Balcony A-01 Project2-Balcony A-02 Project1-Terrace X-01 So, as you see, the numbers at the end are reset for each element in same project, and reset between project. Can someone help me? Thanks SDionne

Hi there I’d like to make a formula that whenever I mark the checkbox (I’ll unmark it later again), it will add +1. It’s a counter for how many times I already did a recurring task. Any ideas on how to do that? Many thanks in advance Cheers Marc

I have a table/records with a computed column/fields (using a lookup function) - let’s call this field/column F0. I would like to PATCH the table by changing the values of field F1 and leave everything else as is. However, when I send the request I obtain the following error { "error": { "type": "INVALID_VALUE_FOR_COLUMN", "message": "Field \\"F0\\" cannot accept a value because the field is computed" } } Any guidance would be appreciated!

Hello, Seeking help from the community for a printing error. Printing from any view worked fine until the most recent major Windows update (Windows 10). Now, after trying to print, I will get a preparing to print dialogue and nothing happens after that. Any tips?

Hello there For recurring tasks, I’d like to calculate the data depending on what I select in the single select field. For example: if “2 weeks” choose the formula which adds 2 weeks to a date or if “1 month” then add 1 month and so on. Is that possible? Thank you. Cheers Marc

Column #1 {Need Hotel?} Yes or No Column #2 {Hotel Cost (Estimate)} {Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)} What I need is to change the column in #2 so that If {Need Hotel?} = Yes, then Do {Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)}

I have two tables: ‘events’ ‘people’ (including single select field for ‘dietary requirements’) I can assign multiple people to each event. I then use a rollup field in ‘events’ linking to ‘people’ and the ‘dietary requirements’ field with this simple formula: ARRAYJOIN((values), ", ") It returns something like: None, Pescatarian, Vegetarian, None, None, None, None, None What I would really like to see is: 1 x Pescatarian 1 x Vegetarian 6 x None (or No dietary requirements) There are more than three options at the moment (e.g. ‘nut allergy’ and others, and as I add more people there will be additional dietary requirements to add to the single select field, no doubt. What is the way to achieve this ‘count of same items’ please?

Hi everyone, I’m not sure if I’m missing something or what but when I clear out all the data in a column and then paste new data into the column, it still has the previous data saved? I know this because when I switch from single line text to multiple select, the old data shows up as a bunch of choices. Any help? The solution I found is to delete the column and make a new one but I have a ton of data and this seems like it may lead to issues half way through my project. Thanks.

Hi! I am trying to create monthly columns that tell me if a staff worked the entire month, a portion of month or not at all. For example… staff 1 starts 9/8- 11/12 - my formula would show staff 1 worked 73% of the month. Same if staff 2 starts 8/31-9-1…would work 3% of september. I have it almost working…but issue with start date on the first of the month. Any ideas? Thanks! Matt IF( AND( IS_BEFORE({Start Date},‘9-1-2019’),IS_BEFORE({End Date},‘9-1-2019’)),0, IF( AND( OR(IS_SAME({Start Date},‘9-1-2019’),IS_BEFORE({Start Date},‘9-1-2019’)),IS_BEFORE({End Date},‘10-1-2019’)),DATETIME_DIFF(DATEADD({End Date},1,‘days’),‘9-1-2019’,‘days’)/ DATETIME_DIFF(‘10-1-2019’,‘9-1-2019’,‘days’),IF(AND(IS_BEFORE({Start Date},‘9-1-2019’),IS_BEFORE(‘9-30-2019’,{End Date})),1, IF(AND(IS_BEFORE(‘9-1-2019’,{Start Date}),IS_BEFORE(‘9-30-2019’,{End Date})),(DATETIME_DIFF(‘10-1-2019’,{Start Date},‘days’))/(DATETIME_DIFF(‘10-1-2019’,‘9-1-2019’,‘days’)), IF(AND(IS_BEFORE(‘8-31-2019’,{Start Date}),IS_BEFORE({En

I’m trying to get a formula that allows we the take the total of numbers in the linked filed to be summed together For example Total Amount, Amounts used, Total Amount used, Currently in Stock 10 1,4,5 10 0 Idk if this makes any sense at all i just have a list of items in one table with all their information in another table any time i use the item i track the date and the amount used I would like my stock table Currently in Stock number to be able to subtract the total amount used since i may use a product multiple times in different areas or times My Total Amount is to help me track the amount i started to help know if we should get less or more incrase our amount

Hello, I was wondering if it’s possible to configure a form to auto-complete different fields when accessing it from a URL. The documentation for forms does not seem to mention any of this, and I think this would be a great feature to enhance our workflow. In my case, a Slack bot automatically posts player reports for my game, and a in-line link button is generated on the message so that I can add a “Ban” record if the report is valid. Right now, the administrator has to fill a few fields that would otherwise already be specified in the message. I believe adding parameters to a URL would make the implementation and usage of this possible feature very intuitive, like the following example: airtable(dot)com/MY_FORM_ID?MY_FIELD_NAME=MY_FIELD_VALUE

Hello, I’ve been tinkering with this idea but I’m stuck. I have a form with a Multiple Select field. Each option of this Multiple Select is the name of an activity. When the form is submitted, I’d like the table to add a value (I’m calling this “points”) according to the activity selected. So if Activity 1 was selected and the form submitted, 10 points are added to a field in the table. If Activity 2 was selected, it’s 8 points, and so on. Anyone have an idea how to make this? Many thanks in advance.

I have one table of people, and another with records of their visits. In the people table, I am trying to add a field that will tell me the date of the earliest visit… after 9/30/2016. I tried adding a formula field in the visits table to return the date of the visit only if it is after 9/30/16, but I have no idea how to build a specific date into the formula. I really don’t want to add another field to the table that will force me to add “9/30/16” to every single visit record just so I can do an IS_AFTER formula with two date fields. (Which reminds me, why don’t default values you set for certain fields show up when you add new records in the mobile app? Real bummer. But I digress.) IF(IS_AFTER(DATE,9/30/16),DATETIME_FORMAT(DATE,‘MM/DD/YYYY’),"") returns #ERROR everywhere. I am really hoping my format “9/30/16” is the problem, but I have tried other variations with no success. Meanwhile, if it is possible to get that formula to work, will a roll-up field in the people table let me pul

I have an Event Check-In form that allows people to add an Event, which draws from the Event table. EVENT CHECK-IN GRID EVENT GRID EVENT CHECK-IN FORM While we only have two events right now, I can imagine this form getting very difficult to use when we have more and more events. Is there some way to limit which linked records the form can link to based on a parameter like date of the event?

Hi everyone, I am trying to do a lookup from another lookup. To illustrate my request, I have created this base The first field is the close family relationship to Mister A. Mister A has parents and children > Linked record fields Mister A has Grand parents, Brothers and sisters, Uncles and aunts > Look-up fields But I can’t create a lookup from another lookup to have a field with Mister A’s Cousins. Can someone can help me to create a look-up or a formula to display Mr. A’s cousins in a new field. Thanks in advance. Thibaud -

Hello, I need to download a CSV file, displaying the name of the attached files of an Attachment field (without the link). Do you know how to display only the name of the attached documents ? Thanks a lot for your help ! Milarépa

Without going to Google sheets, how can I format an imported date/time from 2019-09-06 7:52 PM in the formula field to 9/06/2019 7:52 PM? Everything I’ve found just sets everything past 12pm to 12:00 AM. Also, is there something I’m missing using the regular date/time field? This doesn’t seem like a big stretch, but when I change the field type it just clears everything. Thanks!

Hi everyone ! I’ll try to explain my problem as clearly as I can… I am using Airtable for research purposes, for my PhD in archaeology. I produced a table for the objects of my corpus, and another one for my bibliography. In my objects table, I created for each object a field “bibliography”, in which I can enter links to records of my bibliography table. At this point, no problem in doing so. What I would like to do, is add a comment or a precision to this link : page and catalogue number that relate to my object. But I don’t know if it s possible… Any idea ? Hope this is clear, it’s not easy to explain, especially since English is not my native language… Thanks a lot !!

I have been setting up Airtable for the records of our large chorale singing group about 6 months. A lot is great, but there are still some things I am trying to figure out. I have a Members table in which the primary field is the member name. Among a number of other tables, I one called Ticket Sales to track the number of tickets sold by each member. I set up the link from Ticket Sales to Members and successfully created the Lookup so that I can bring in the Member Name to Ticket Sales. However, I also want to bring in the Active Status information for each member, which is a field in the the Members table (people who are on leave aren’t assigned tickets for an upcoming concert). But even though in the Lookup field I choose the Member table, and Active Status field, nothing is returned. What am I doing wrong?

Hi everyone, I’d like users to submit entries via an Airtable Form and confirm their email. With Zapier, I can react to a new entry and send a confirmation email. Easy. But how do I close the loop? What kind of link could the user click on, that would trigger a confirmation in the base? Any creative idea? Thanks, Tim

Hello all! I am wondering if there is a way to make text in a SendGrid Block email bold? Thank you!

I am trying to make a grocery list that would take the price of an item ($0.88) and multiply it by the quantity needed (2) so that it outputs the total amount ($1.76) I have tried the formula Price * Quantity which hasn’t worked. How would i create a formula to output the total price as stated above? Screenshots

Hi! I’m trying to create a formula where my Primary Field is a number that I need to pull from a URL link: Currently, I am using the formula RIGHT() to tell the formula to find the last three characters from the right of the URL link, which won’t work once we get to 4 digits, or if for some reason the URL structure changes adding an extra character at the end. Is there a way to find only a number from a URL and return it as such? Thank you.

I have a table “Ethnicity”. For the purpose of this post, I’ll use Asian ethnicities as an example, but my Ethnicity table will also include ethnicities of other racial groups. On this table are entries like “Asian Indian”, “Bangladeshi”, “Bhutanese”, “Taiwanese”, “Chinese”, etc. I have another table “Contacts” which contains a column that links to Ethnicity. Each record in Contacts can be linked to multiple ethnicities. I now want a column that marks whether a record’s ethnicities fall under larger racial groups. For example, if the record is linked to “Taiwanese” or “Chinese” or both, I want the record to be marked “Yes” under the column, “Asian” What’s the best way to accomplish this?