Resolved! 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
Resolved! Attachment URLS
I know I am late to the game here. I have been ignoring the updates until now. I currently have uploads and the links for the uploads through a formula - which allows me to create a download button.I use these so in the public share link to my base -...
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!
