Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Getting Count when two conditions are met

Hello, I'm creating a fairly simple base to track all of the violations for an HOA board. I'm trying to create a field to calculate the total number of times a house has gotten the same violation in the past year.The Base has 3 tables, "Homes" with a...

QPBoard_0-1725551592849.png
QPBoard by 4 - Data Explorer
  • 86 Views
  • 1 replies
  • 0 kudos

Resolved! Single select dropdown does not appear when I embed the view

Hi all, So I have created a base here (it is a gallery view)https://airtable.com/appPv62y3frc8BYJA/shrVTQGn7420FaGvUEverything in the base works as it should. The single select dropdown works great, but in the embed view, the single select dropdown d...

Nicko54 by 5 - Automation Enthusiast
Solved
  • 339 Views
  • 2 replies
  • 1 kudos

Resolved! Multiple Dates per Entry in Calendar

Hi all--We are a publishing company and we sometimes publish the same content multiple times throughout the year. We have a field set up "Publish Date" that shows all of the dates. The problem is when I try to have these feed into our general publish...

LaurenMaine by 6 - Interface Innovator
Solved
  • 472 Views
  • 2 replies
  • 1 kudos

Hyperlinks

HelloIs there a way to include hyperlinks in a base? I am importing data from Excel, where I collected the profile of n individuals and for each profile I have general information (name, education, job title etc) and a link to their LinkedIn page. Wh...

federica by 4 - Data Explorer
  • 1510 Views
  • 2 replies
  • 1 kudos

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 

JM1234 by 6 - Interface Innovator
Solved
  • 607 Views
  • 2 replies
  • 1 kudos

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

Elizabeth_Aucti_0-1676346277967.png

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

Ramagu by 5 - Automation Enthusiast
  • 556 Views
  • 3 replies
  • 0 kudos

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

Lisa_Wetherby_0-1712696136417.png
Lisa_Wetherby by 6 - Interface Innovator
Solved
  • 1031 Views
  • 4 replies
  • 5 kudos

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

GolfCartsUSA by 5 - Automation Enthusiast
  • 1990 Views
  • 8 replies
  • 0 kudos

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

akidz2 by 4 - Data Explorer
  • 663 Views
  • 2 replies
  • 0 kudos