Insert a space before a capital letter
Hi I have a file name / string of texte.g. 'ThisIsTheFileName'I would like to insert a space before each capital letter. Is there a formula to do this?Thanks
Forum Posts
Help with Scripting to Add Totals by Commercial and Year in Airtable
Hello Airtable community,I am working on a project where I need to automate some financial reports in Airtable and I would like to ask for your help to solve a specific challenge related to conditional sums in several tables.Context:I have a base wit...
Resolved! Count unique values in a column
I have a grid view with a field that shows volunteers that have volunteered along with the date they volunteeredI want to figure out how many volunteers volunteered each month - how do I find how many unique volunteer names appear in this list, and i...
Hardest Problem I've Ever Encountered
Okay guys, got a doozie... Basically, in the screenshot I have a table, which is the main table that 99% of things sprout off from. We have customers, who through a webflow form are able to select accessories to add on to their purchase. That gets re...
Having birthdays show up on a calendar view in Airtable
I have a field where people can enter a birthdate. I want that to show up on a calendar view in Airtable. Unless the year is the current year, it's not showing up on the calendar. I tried using a formula field but then I can't get the formula field t...
VIEWS: Filter by time (hours) not just date (days) in a single field
Hey all, first post in here. Has anyone else noticed that when creating a view and setting the filters (particularly on conditions relating to a date field that includes a time) there is no way to set the filter to read hours rather than days? My use...
Resolved! Reformatting Rollup Date Range
I have a rollup cell that is pulling a range of data from another sheet. Is there a way to:1) Format these so it's easier to read : MM/DD/YY-MM/DD/YY 2) Format these so I can create a calendar view that would show these dates in a row on the calenda...
Resolved! Consolidating Lookup Results
Apologies in advance if this was answered elsewhere, I did try to find it.I have a lookup cell that is pulling information from another sheet. In that other sheet, the cells all share an attribute called “Daily Flow.” I’m wondering if there’s a way ...
Separating multiple data entries in field
Hey,I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!
Combining fields in table into formula
Can someone assist me with writing this formula? I'd like to basically have a column in which the staff or faculty nominee column is combined with the value. For example: Cameron, Ali - Innovative SpiritI'm running into an issue were if the staff col...
