I have string fields and I want to extract the first two words (minus any punctuation or special symbols). Ideally, they would remove the white space and capitalize each word as well.So a field with “Midnight: A Tale” = “MidnightA”. ”What’s New in Bo...
Hi all, I'm trying to extract the first set of data in this single select field using LEFT() and then converting that into a date field. The data extracted will be in Chicago time. When I run this formula, it assumed that the date is in GMT, and doe...
Hello altogether, this is driving me crazy. I am entering some formulas in my field and while I am adding fields, they disappear. This behaviour is consistent for all the fields. What is going on? Is it because there are too many referenced fields?
I'm trying to use either a SEARCH() or FIND() function to locate a comma within a string. Unfortunately, these seem to be broken on Airtable right now. Am I missing something? This should be pretty straightforward, right?
I have a base that has client names in a table and appointment date on another table that is linked to the specific client. I am trying to create a formula in the client table that will display the last appointment for that that client that was sched...
Hello,I am using Airtable in conjunction with a web app. On my web app, I have a page for a section dashboard that shows communal information. Additionally, I have an individual dashboard, which displays information about a particular user.My problem...
I have an Airtable database set up where we track entrepreneurs we work with in Sprints (Jan-Apr, May-Aug, Sept-Dec). One feature I need to implement is a way for our team members to submit revenue updates as often as they need based on entrepreneurs...
Hey I'm quite new but couldn't find an answer : I'm looking to show the average of a column in the interface. To be specific, I have a set of data from one table and I'm selecting certain data from another table, and I want to calculate the average o...
Hello,I'm moving into the List View Interface, and I am loving the "Prefix" field which allows me to use visual indicators to quickly see the status of records. My current roadblock is this, I haven't been able to figure out:How can I have a Single S...
I am trying to create a project tracker with a task list and start dates and end dates for each task that are calculated automatically based on a dependent (linked) task and its associated dates. My problem is how to create the first row because no m...
| User | Count |
|---|---|
| 896 | |
| 833 | |
| 609 | |
| 530 | |
| 352 |
