If my event is September 2, 2025 (aka "program start date"), it would be in Quarter 3, 2025. But I need to list that commission would be paid the following quarter (aka "quarter earned", so Q4, 2025. Fiscal year runs Jan - Dec like the calendar.I cur...
Hello,We are looking to take our current airtable bases and build out custom affiliate views for our travel agency. We'd like each of our affiliates to be able to view their current clients with us, statuses, and financials. We would also need someon...
I am trying to sort by the Week # of the year that an entry is assigned on my base. Its sorted by year, then by week - so 2024, week 1 through 52, etc.However, for anything this week up until the 31st, its showing up as the 1st week of Dec 2024 (whic...
I have this formula for calculating the quarter and the fiscal year of when an invoice should be paid.Program Start date is 7-4-2024 (which is Q3). I want it to be paid the quarter after (so this one would be be paid Q4, FY24) but its showing Q3 - FY...
Hello! I am looking for an advanced questionnaire, either in Forms for Airtable or an integration. I would need it to be in sections (each section having a little header with directions), and an if-then conditional type of response, where if they ans...
@jessielcktrvl, did you end up finding someone to help? Would you be willing to share who you used? I'm looking for something similar for my travel company.
Actually @Ron_Daniel what that did is set Wednesday as the top of the week, so now all the weeks throughout the year are starting on Wednesday. Is there a way to only distinguish the change for the beginning of the year and the end of the year? so th...
