I haven’t been able to find an answer to this on the site, but there doesn’t seem to be a function to count the number of words in a text field. There’s a function to count the number of characters – LEN. One workaround could be to the count the number of spaces in a text string, but I don’t see a function to do that, either. SEARCH and FIND return the first position of the search string inside the text, not the total number of times the search string occurs. A word count function is very important for using AirTable as a content management system. ... View more

Just a heads up for anyone who hasn’t noticed this non-intuitive behavior. For Numbers and Currency Field types the “precision” selection can affect the values, not just the formatting. It looks to me like Airtable is inconsistent here though, so results can get pretty funky. For example, create a column that is a Number or Currency and set the precision to 1.00 or $1.00. Type the value 0.49 in the first row and replicate it 9 more times for a total of 10 rows. The sum shown at the bottom of the column will be 4.90, which is correct. The value displayed in each row is 0.49. The non-intuitive behavior comes when you change the precision. Change the precision to $1 instead of $1.00. Each row now shows $0, which makes sense given the rounding. The total at the bottom is now $5, which doesn’t make much sense given all the numbers are 0. Also doesn’t make much sense given the actual values are $0.49 and the actual total is $4.90. Now change the precision back to $1.00. All the rows are now $0.00 and the total is $0.00. (I guess Airtable gets to pocket the $4.90?). I can imagine this behavior causing serious headaches. Imagine I’m keeping a budget, and I want to see the values to the dollar sometimes, and to the cent other times. If I change the precision, I absolutely do not want it to be changing the values. But there seems to be no way to prevent this. ... View more

Hi there, I‘m searching for a way to detect duplicate entries in a table. My table contains event names, currated by me. I have a form that anyone can use, to suggest new events. When someone submits an event, I‘d like the table to warn me that an event with a similar name already exists. Any idea how to do this? Thanks ... View more

Would be so nice to have some options in a form for dates. My dilemma tonight is I need a base that collects a record for each committee our employees serve on within our department, within our organization, and outside our organization. The first annoyance for the forms end user is they will have to complete a new form for each committee they serve on. My wish is they could select their name and fill out the first form and submit and when they select the option to complete another form it would auto-populate the name field. This would be a nice service for them. In this form I need to know the month and year they began serving on the committee and if then month year they terminated their service or if they are still presently serving on the committee. Here are some screen shots that I took from another form (not Airtable) that collects membership data Thank you for your consideration - very grateful for Airtable and their amazing team! ... View more

Hi all - this is somewhat of a repeat topic, but the original post wasn’t under feature requests and has not yet been addressed. When embedding a view that is grouped, every group is expanded regardless of how the view is configured prior to embedding it. It would be great to be able to preserve the configuration when embedding. Use case: I embed several views on our company intranet with files to download. I have several different “packets” of files that I want employees to be able to see at a glance, instead of having to scroll past each group that they don’t need. What I want the embedded view to look like: vs. What it actually looks like: ... View more

Ability to create instance a table of another base into Another base. That instance will just mirror the actual table form from other base. This will solve all the cross-base feature requests and issues 🙂 ... View more

Is there a way to sync our database of users with airtable so a form can autofill that information in like Google Forms does. This way a user doesn’t have to type in their email every-time and we can track our users better for reporting. ... View more

Many of the core keyboard shortcuts make Airtable a breeze to use, but there are some key areas where data entry gets stalled because you have to go back to the mouse or trackpad — this seems really pronounced in the Calendar views and when using date fields. In a calendar view, for instance, something like the following would be great: CMD/CNTL-LEFT/RIGHT: Move back or forward one day/week/month depending on the current layout. Some combination to add a new record Arrow keys navigate among the records in the calendar view. When the one you want is in focus, you can open it with the usual SPACEBAR shortcut. For date fields: OPT-ARROWS or FN-ARROWS currently navigates through the popup date picker, but you cannot actually SELECT a date from the keyboard. Some combination that moves the highlighted blue date and updates the field when you hit ENTER would be nice. ... View more

Hi, I tried to change browser language, location and computer settings, but calendar weeks still starts with sunday. Computers calendar starts with monday automatically, but airtables still starts with sunday ... View more