Other Questions

In the Teams plan, can a form that's shared with a Commenter and filled out via mobile web browser be secured via password?

Hi The screen shot is of a table for sales in one of my bases. The 'pay window filter' field determines which pay month the date falls in, our pay windows run 25th to 24th, so 26th September would fall in Oct Pay Month. The 'Pay Month' Field formats that date into the correct Text format I want which then links to a second table called Pay Months where the record name is October 2023, November 2023 etc. As you can see from the screen shot, I've filled in a new record with a date, its automatically calculated the Pay window filter, but 'pay month' has automatically formatted the text and linked to the other table. Why is this, am i missing something? I thought this would automatically do that. I'm new to airtable just building out systems for my business, so any help much appreciated. 

Hello 👋I took an effort and explored other related posts available. I came to a workaround I am not happy with, so I decided to make a new post and ask Experts for guidance 😇 I know almost everything is possible with Airtable, sometimes we struggle to find a way.Problem StatementHow can I display linked records that meet certain criteria (not the lookup/rollup field), but exact records.ContextI have 3 Tables (relevant for the issue). Chapter, Event, Sentiment. The story looks like this: There are different Events. Chapter Members from multiple Chapters provide responses about given Event in a form of Sentiment.Relations(one) Chapter - (many) Events(one) Chapter - (many) Sentiments(one) Event - (many) Chapters(one) Event) - (many) Sentiments(one) Sentiment - (many) Events(one) Sentiment - (many) Chapters*looks like I have some many-many relations, and I don't have any additional table to store it.Problem(one) Chapter - (many) SentimentsFor a given Chapter

Hi there, Tablet : Galaxy Tab A8 SM-X200, Android 13 As the title say we just got a brand new Android Samsung Tablet for our workshop to be able to check the PDFs of manufacturing plans. However, when i click the pdf file, it displays a broken image icon.The thumbnail preview does show the first page of the plans, downloading the pdf and opening it in another app of the tablet works, i tried opening the same pdf on dropbox from the chrome browser and it works, of course on the desktop-chrome it works.  Do I need to enable anything on the tablet or app?  Thanks for the help

I am unable to remove collaborators—and keep getting billed for them every month. I go into workplace settings and view the list of billable collaborators—of which three are listed— not including myself. I click on “add or manage workspace collaborators.” However, only I am visible. A search by name or email address also produces nothing. Please advise. Thanks!

Hey Folks!When I copy and paste the contents of a multi-line rich text field, it seems to remove formatting, including the bullet levels, spacing, etc. For example:Test 1Sub note 1Note 2Sub note 2Sub note 2aIt shows up like this:Test 1Sub note 1Note 2Sub note 2Sub note 2aThis happens both when I copy and paste and also when I send a record. The send record preview also shows the unformatted bullets.  Any ideas?  

I've set up an interface dashboard that pulls in data from two different tables. Within this dashboard are two number elements that are Field summery Sums of data from the two tables. In a third Number element I wanted to use a formula to divide one by the other, I thought I could use a very simple formula for this in the element itself, but I cant. Is it possible to do what I need in the interface dashboard?

I've set up a Table for recording my Staff working hours, moving from a paper system. Each day the staff member using a form, enters the date, name and number of hours worked, site location etc. When its time for payroll I want to create views that filter for last months payroll window. Our window runs from 25th of the month to 24th of next month. So when I'm preparing payroll on the 24th October, I want the view to filter out all results except those falling in 25th sept to 24th Oct pay window. I was trying to use filter so many days ago, but this varies each month depending if its 30 or 31 days. Is there a way of setting up a filter from the 25th of last month specifically? 

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).