Solved

I have been using an AirTable base with about 600 records for an MVP backend of a webapp built through AppGyver using Airtable’s API. Unexpectedly, I can no longer access the base, whether through the API or through the AirTable interface. I get the following message: the base is unavailable. And I am certainly not sending over 5 API calls a second. What gives?

Hi Airtable Friends, I want to combine four things in my primary field: (1) Story ID#, (2) Date, (3) Storyteller, and (4) Story Title – all separated by a " - ", of course. I was able to get the first two things with this formula: ({Story ID#} & " - " & DATETIME_FORMAT(Received, ‘DD/MM’)) & " - " But when I follow this up with {Storyteller} & " - " & {Story Title}, I get a message that says: “Sorry, there was a problem saving this field. Can’t save field because it causes a circular reference.” To be clear, here’s the full formula that keeps getting rejected: ({Story ID#} & " - " & DATETIME_FORMAT(Received, ‘DD/MM’)) & " - " {Storyteller} & " - " & {Story Title} I’ve tried a number of variations using parenthesis and curly brackets, but always get the “sorry” message. Grateful to anyone who can help me get past this irksome obstacle!

I have a simple gallery, showing three fields. One of the fields links to related records. The gallery card shows a limited number of related records before it cuts them off. I would like to print the gallery cards showing all related records. How do I do that?

Is there a way to view ALL of the “LONG TEXT” field without having to OPEN it? By default, it only shows the first time… is there a way to see ALL the lines? Thanks, George

Hi all, pretty new here! I just want to set up a field to capture grams and kilograms (weight). Do I set cutomize the field to number? I’d like to to display KG or g like it would if I added a currency $/£/€ etc. Is this possible? Thanks for any help you can provide!

I am trying to import an .ics file (generated from Google Calendar) into Airtable with the calendar block, but when I get to the mapping step, the only fields I’m able to map are the Name and the Notes. For some reason the date and time fields are not mapping.

Hi, I’m writing an item order table and have been successful in pulling prices from a matrix based on qty input using the Tiered system, but I find I now need to include the ability to override the price. The Tier Formula is below and works - it populates the name of the tier based on the quantity input IF(Quantity > 1, IF(Quantity < 5, “Tier 2”, IF(Quantity >= 5, IF(Quantity < 10, “Tier 3”, IF(Quantity >= 10, IF(Quantity < 15, “Tier 4”, IF(Quantity >= 15, IF(Quantity < 25, “Tier 5”, IF(Quantity >= 25, “Bulk”)))))))), “single”) Once the tier is populated, I’m using a SWITCH formula to pull in the correct price based on the price tier SWITCH((Tier), “Single”,{Single Unit Cost}, “Tier 2”,{2-4 Units Cost}, “Tier 3”,{5-9 Units Cost}, “Tier 4”,{10-14 Units Cost}, “Tier 5”,{15-24 Units Cost}, “Bulk”, {Bulk 25+ Plus}) I find that I need to be able to override a price if their is a special one off price for a given line item. But since I’m using a formula, there doe

Hi everyone, I would like count the number of records form another table. For example, I have created a table with all the payments that the company receives, and they are linked to the customer master record. But I would like to add a control in the customer table of the number of payments made by this customer (the number of records, because a payment is represented by a line). Is there a way to search a second table and count the number of records for a client? Many thanks in advance for your help. Have a very nice day. Alexia

I have a formula I can’t figure out. My column that I want as a formula is called “Forecasted SCIP Received” To calculate this date, I need to use another column called “Actual Site Walk Date” plus a “Duration” column. However, if “Actual Site Walk Date” is empty, I need it to use “Forecasted Site Walk Date” instead, so: If the “Actual Site Walk Date” is not Empty, then “Actual Site Walk Date” + “Duration”. But if Actual Site Walk Date is empty, then “Forecasted Site Walk Date” + “Duration” How do I write this?

Hi everyone, I’m new to this. I have created a table to collect student grades. I collect the data on a form and populate the Student and Score fields by use of a form. Thus, I have many different names in my Student field. When I filter the names, I easily separate out any specific student’s scores over the previous 20 tests. But, I cannot figure out how to AVERAGE these scores for each student. Can this be done, or is my data collection method fundamentally flawed and I should start over again? Happily accept everything but blows. :slightly_smiling_face:

I have 2 different lookup fields: Release1 = lookup individual item release date from another table ReleaseMulti = rollup multiple items release date based on condition (if its a multi-item) using MIN(Values) I then have a formula field: RELEASE = IF(Release1="", ReleaseMulti, Release1) Without grouping, this RELEASE field appears correct… for example showing 9/30/2020 in several records. However… if I group by RELEASE, I find that it will split into different groups if the 9/30/2020 is from Release1 vs ReleaseMulti in a different group This is very problematic. I know ReleaseMulti is an array value, and on a similar text based field I used &’’ trick I read on these boards which solved that issue. But in this date field adding the &’’ to the end of ReleaseMulti in my formula does not work. I also tried many combinations of arrayflatten, arraycompact, date parse, datetimeformat, etc… to no avail Can anyone advise how to get a single date from the ReleaseMulti array and conve

I’m trying to make a script to make product planning easier in conjunction with the gantt chart. I have four fields. startDate (date) endDate (formular) depended (link field to same table) lookUp (looks up the endDate via the depended link field) In the first record I put I set a startDate and endDate gets automatically calculated based on various parameters. in the second record link to to the first record and and the look up field looks up the above endDate, which my script then passes into the startDate and then it stops. My problem is that I want to have a bunch of records stacked on top of each other. Set the dependency field (which job it should follow) and press a button and then it’ll pass the lookUp endates into every start date, but because the lookUp takes a little time to update, it stops after the the first date. Is there away to make kind of make if loop over itself again and again until all dates with dependencies are filled? const luPlanRecords = await prodView.select

Hi everybody, I am new to using Airtable. I am sure that there is a formula for this but I can’t seem to find it or I don’t write it in a correct way. With a API service of a third party software I pull data from my Airtable. This data is dynamically filtered by using filterByFormula. The data I need is in the column called “groupcode” and has numeric values varying from 100 and 900. These numbers stand for product categories. Normally if I need products from the category with the number 212 I use the following formula. {groupcode"} =“212” But now I need products from category 212 and 268. Is there a way I can display only the records of two different specifc values ? Any suggestions or tips are appreciated! Thank you in advance!

Just wondered has anyone used Airtable to Organise their company manual? I am quite new to Airtable and getting a little over-excited - at the moment our company manual drives me crazy as it frequently needs updating (or at least small sections do) just wondered if anyone else had popped there’s into here and if so what it looked like and how successful its been

I’m searching for the occurrence of a specific character in a text field with SEARCH but it doesn’t return any answer, can you help?

Is there a way I can add the same record twice in a linked record field? I’m building a product sales database. When I have 2 of the same item in a customer order, I can’t figure out how to add the same item twice in the order record. I’d rather not have to track each order item individually on it’s own row because it becomes difficult to calculate the shipping costs for each item in the same order. Thanks in advance for any help!

Hello! I’m new to Airtable and am loving it so far. I’m creating a database for online resources, aiming to be shared public, read-only. But I’d like to know if it’s possible to have anyone create their own Personal Views on it? Mainly for Galleries Is it doable, or does it require further steps, such as anyone who visits has to become a collaborator?

I am having trouble with a formula. I need to bring back an exact minute time but cannot figure out how to make it read the minutes in this equation. Can someone help?

Hey all, I’ve been trying to work this out on my own but it’s providing super difficult. I have a birthdate field and I want to find out the age. I am using DATETIME_DIFF(NOW(), Birthday, ‘years’) & ’ years ’ and I see the age however those that haven’t filled in the birthday field say Nan. I would love some help. Thank you

Hi! We made an Airtable form and we have a custom domain that we want to mask the form’s URL. We can get our URL to redirect, but we get an error if we try to actually mask the Airtable URL. Does Airtable block this? Our domain name provider says it is on Airtable’s side.

This is the last post I found in the “community” on this topic with any clear response, as of July 2019. Is this still the status, or has there been an update? Replay from Cameron at Airtable: "Hi Gary, You can white label forms on[Airtable Pro but it isn’t currently possible to white label Airtable or add your own custom branding in any other way. I hope that helps! Cameron

I have a TablePickerSynced that I’d like to filter the options for. I’ve got the element conditionally disabled based on the presence of a selection in another TablePickerSynced: <FormField label="Which table holds the Events/Bookings?"> <TablePickerSynced globalConfigKey={GlobalConfigKeys.APPOINTMENTS_TABLE_ID} onChange={() => apptCheckTablesAreNotSame()} size="large" maxWidth="350px" disabled={!props.globalConfig.get(GlobalConfigKeys.PEOPLE_TABLE_ID)} /> </FormField> …but I’d also like the Tables available to be picked in this second TablePickerSynced to be filtered to only include those Tables to which the table selected in the first TablePickerSynced (props.globalConfig.get(GlobalConfigKeys.PEOPLE_TABLE_ID)) has a Linked Record relationship. Is this possible? I don’t see anything in the documentation that would indicate that it is, but I know the FieldPicker can at least disable certain options within the picker

How do I delete “unnamed record” across the gallery view or how do I fill it in? I can’t figure out either.

I am attempting to calculate asset depreciation using Airtable. I am calculating using the following Fields: Purchase Date: Date field Unrecovered Basis 1: A formula which is returning a currency value 1 Year (from Depreciation Conventions): This is a lookup to another table which has the 1 year depreciation amount. This is a numerical value (decimal) I have reduced the formula I am attempting to use down to it’s simplest form. There will be more switch states, but it doesn’t even work with the 1, so I didn’t want to confuse matters by adding more. The formula returns a result just fine, but I am unable to format it as a number (currency) and thus, am unable to use the value in future formulas. The Formula is this: SWITCH(DATETIME_FORMAT({Purchase Date}, ‘YYYY’) - 2015,1,{Unrecovered Basis 1}*{1 Year (from Depreciation Conventions)},BLANK()) When attempting to format the field, it states “Your result type is not a number or a date. Formatting options are currently only available if

Hello, I am a new user- I created an Airtable base that is updated via Zapier from a Google sheet. The records seem to be populating from the Google sheet correctly, but when I try to Group by Client name, not all the records are grouped. I will have some records with the same name in it’s own group. This has happened a number of times so manually dragging those records to the other grouped records of the same Client name has become cumbersome. Has anyone else experienced this and know of a fix or what I may possibly be doing wrong? Thanks in advance for any help on this topic.