Other Questions

Total airtable newbie here in need of some help and direction, please! I have two tasks I would like to accomplishPlease find below a screenshot of what my table looks like. I have a drop-down selection field for each year camp has taken place, and can select “camper” “staff” or “canceled” for each year. Task 1: I would like to have a field that calculates the number of years a person has been in attendance at camp, whether or not they were staff or a camper. So the year tallies would look like this:Person A Years at camp = 1 Person B Years at camp= 2Person C Years at camp= 1 (Because they canceled in 05) What are the steps I need to do this? I think part of doing this airtable wizardry will involve making my year fields linked record fields- do I link all these year fields together and if so, how? Once my fields are set up the way they need to be, how do I create a formula that basically says if year= camper or year=staff, either equals “1” or whatever and then counts those,

I am currently working on a form, and I would like to know if it is possible to include hyperlinks within a form question. I believe this functionality would greatly enhance the user experience and provide valuable additional information to our respondents. To provide more context, I am looking to creating a checkbox question that includes hyperlinks to external resources (privacy policy and terms & conditions). These hyperlinks would have to be reviewed first before checking the box. I have explored form creation tools, but I couldn't find a straightforward way to implement hyperlinks within the question in the form. Hopefully someone can help.  

I would like to disconnect the general Slack Notifications from a base — the one that posts messages to a Slack channel whenever a base is updated, not a custom automation. I can't figure out how to disable the connection; when I click on "All Slack notification rules" the page comes up empty.

I have a table called "companies" that is linked to another table called "deals" where 1 company can have many deals.  On the companies table, I have a roll up called "latest deal", that takes the max deal start date from the deals that the company is linked to.  This all works great.Now I have a sync from the companies table to another base which tracks a project status for each company.  The "latest deal" field is sync'd in this new base.I noticed today that I had a deal start date (in my original base) change from 2020-01-15 to 2020-01-14.  This updated the roll-up in the companies table of the original base but did not trigger a sync to the new base.  And when I manually triggered the sync, it still didn't update to the new date.The only way I could get the update to sync across was by temporarily changing my roll-up formula in the original base from max(values) to min(values) and then back to max(values)!Has anyone else experienced this issue with value ch

Getting a lot of issues with scripts starting today, that previously worked fine.  All having JSON issues with webhooks received.  This is an error from a script that is run from a webhook that is hooked up to a button in an interface. SyntaxError: Unexpected token < in JSON at position 0at runWebhook on line 30 at async main on line 14 Anyone having issues with these starting today? EDIT: 6pm PST - seems to be working correctly now.  Must be some sort of back-end issue. Will post back if any other errors surface.

When you remove a collaborator who had already been added to a specific base, does it send them any notification (email, push notification, etc.) that they were removed? We're trying to tighten up our information security as our team grows, but don't want to unnecessarily alarm existing team members that they're being removed from bases which they weren't accessing regularly, if at all, in the first place.

Simply put, I cannot understand why my "listeCommandites" Array shows 20 elements before I loop through it and then the console.log(item) within the loop only iterates through 17 elements. Lines i'm talking about for console.log() are in the last code snippet. Here's a code sample:...  async function createOrUpdateCommandite(pPostId, pRecordID, nom, status, meta) { const headers = { 'Authorization': 'Basic ' + auth, 'Content-Type': 'application/json' }; const postData = { "title": nom, status, "meta": meta }; let response; try { if (pPostId) { // Update existing post response = await fetch(`${wpDomain}/wp-json/wp/v2/commanditaires/${pPostId}`, { method: 'POST', headers, body: JSON.stringify(postData) }); } else { // Create new post response = await fetch(`${wpDomain}/wp-json/wp/v2/commanditai

Hey Everyone!One of our tables has maxed out on automations, so we've been using synced tables in another base to outsource some work to; we are routing client emails from there and have recently started noticing that when a user has not opened up that synced base for awhile and kept it active things are happening with a multiple hour delay.An old thread where another user had this issue had the following information from customer support:When the base is inactive the base will not sync. The base will sync as soon as a user access the base. One workaround to keep the base active without a user active in the base is to create an automation set to trigger at a scheduled time (when users are not active on the base). The automation can perform a simple action like checking or unchecking a checkbox field on a record. Doing this should keep the base active, and thus syncing, without an active user. I’ve passed along the feedback to the team to have this information reflected on our support a

I would like to know, if I am paying for team program in different account, does it applies also for the fact that if I changed the functions of airtable base for example one year ago, and need to put the airtable in original state which was one year ago, can airtable support make that copy of the base that was changed one year ago ?

I have an Airtable form link but I'm not sure what base it's attached to. Is there a way to find the attached base without going through every single base and table in my workspace?

I have a Customers form and I want them to be able to add their pets. When I click +Add under Pets, I just get a list of currently entered pets. How can I actually add one? Thank you. 

On April 4 my entire base disappeared.  We had been using this to track our inventory for the entire business since October of 2021.  I immediately contacted support and have still not heard back.  It has been 3 weeks.  This data was extremely critical for our business because it tracked all of our inventory.  I am hoping that the support team will be able to recover the data.  This happened to occur at the same time that Airtable released changes to their user interface, so I am not sure if that is related.  Please help!  Hopefully Airtable can access a "snapshot"  but I am not able to see them because they are accessed within the base, which is gone.

Hi, I’m trying to find a way of calculating the difference between two values within the same field but in different records within the same table as per the image below. I have read many similar questions and answers but they always appear to be over complicated, although most have been from a few years ago. I am hoping therefore, Airtable might have introduce a simple way of carrying out this calculation and hope someone might be able to point me in the right direction.Just to clarify what I’m trying to achieve, I am tracking the weight (plus lots of other info) of our new puppy and want the ‘difference’ field to calculate the difference between his current weight versus his previous weight.

The timelines in airtable are not overly functional for what I need. I need to view up to 50 timelines on the same screen, each with multiple records. As you can see, I am only able to view a few things at once.Partially there is a base design issue here, but for other reasons I don't really want to redesign the whole base to make viewing easier.So the UI doesn't quite work for me here. I need something that can condense the vertical height these take. E.g. thinner lines, or being able to overlap them, or being able to "summarise" the total time frames on the sub-grouping.Does anyone have any suggestions for a better app that plays with airtable?  

Is there any way to give base user permissions to access only selected tables in a base, not the the whole base?

I would like to set a checkbox to checked based on if another field has a number in it. Here is the Function I have in a Field called CheckChain. IF({Chain Amount} = BLANK(), Chain = 0,Chain = 1) The field Chain is a checkbox, and the field Chain Amount is how many times tire chains are applied. I am using this as a check to be sure the Chain checkbox is checked, if someone forgot to check it and entered an amount.

I'm looking to create a form with fields for a project lead like name, title, affiliation, and email. What's the best way to allow for multiple project leads? Ideally, a user could click a checkbox to 'Add Additional Project Lead'. There's no limit on the number of leads. Any advice on using repeating fields for this? Basically, trying to determine if I can somehow not have to replicate each field an ungodly amount of times with a checkbox between each conditionally showing the next bunch of project lead fields conditionally based on the particular checkbox (nightmare).

I am trying to build an order system with several tabs: Orders at vendor (I buy from 1 vendor) Orders from customers Customers Products An order from a customer has several products and might have more than 1 from each item. And that is where I get stuck. How can I add more than 1 of an item when there are multiple items? If it was just 1 item more times the colums would be product & amount, but that wont work. I feel like I am missing something obvious…

I have a string of text that I want to break into two separate strings of text. Here’s an example: This is an example string of text / I want to break it into two separate strings of text I want all of the words that precede the “/” to be one string of text. And then I want all of the words that come after the “/” to be a separate string of text. I want to completely eliminate the “/”. So, to recap, we start with this: This is an example string of text / I want to break it into two separate parts And then we end-up with this: This is an example string of text I want to break it into two separate parts

I have emailed and used the contact support feature and have not gotten a response. I need to have tax removed from an invoice before my institution can pay the balance. Has anyone else dealt with this? Why is there not a phone number where we can reach a support person?

As some of you may know, I’ve spent the past year, at least, battling a debilitating physical condition. For the last few months, this expressed itself as near-disabling reflected pain in my arms and shoulders that made working at a keyboard – or focusing on any task more complicated than rereading genre fiction – virtually impossible. Although the condition was finally diagnosed mid-November, complications (a two-month pause to reschedule surgery with an in-network physician amenable to my insurance provider; the scorched-earth arrival of Covid-19) pushed my surgery back to April 10. (Fortunately [?], the delay meant my situation had deteriorated to the point the procedure was no longer considered elective; otherwise, you’d be reading this in October.) Today, a week out of the hospital and with another month of recovery ahead of me, I already feel better than I have in a couple of years. A whole raft of symptoms my doctors said might be alleviated by the surgery have completely disapp

Is it possible to hide or display certain fields in a table based on the value of another field? Basically, conditionally. For example, let’s say a table has the following: Field A Field B Field C And I want the following display options Field A: Always visible Field B: Visible only when field A is marked “Present” Field C: Visible when field C is marked “Absent” How would one do this?

In airtable, I've programmed a calendar with dates and times for specific events. The formula is as follows: IF({Override horaire cour 1}=0,IF(Ordre="1", DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Horaire c1h1}), DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Horaire c1h2})),DATETIME_PARSE(DATETIME_FORMAT({début},'MM/DD/YYYY')&' '&{Override horaire cour 1}))When I install the calendar in my application, all the appointments are 1 hour later. How can I fix this?

Hi, guys!I would like to find out if Airtable is by default downsizing attachments when it comes to images / video / PDF files. Thank you in advance!Razz

Hi everyone,My team and I are trying to create URL previews for AirTable share links. The URL preview extension works for other URL types, such as Google Sheets, but we are seeing "No preview" when we select a cell with AirTable share link. It's the same issue whether the share link is for a base or for a table view.While looking through online documentation, I saw that the format of the link that's generated for us is different from the format I see in the documentation. Ours is in the format "https://airtable.com/app[random-string]/shr[random-string]/tbl[random-string]" or "https://airtable.com/app[random-string]/shr[random-string]",  while the online documentation shows the format "https://airtable.com/shr[random-string]".I'm not sure if that is the cause of the URL preview failing, but was wondering if anyone else encountered a similar issue.Online documentation I was referring to:Screenshot 1Screenshot 2Screenshot 3