OK, all you smart people out there. (I know there are a lot of you!) I need a formula for my database and I need some help, (because I’m horrible with math and algebra.)
I have different churches with different services and studies through the week. The services are stored in the database with an unspecified date/day/time. (e.g. Bible study is every Tuesday night at 7:00pm) On an Airtable calendar I want to display an actual date to the user. (i.e. Tuesday, March 10th.) In order to do this I have to calculate what the next actual future date will be from whatever is the current date. It has to dynamically adjust with any given day the user might be looking at the calendar.
Do you have access to Blocks in your base? IE, do you pay for the Pro plan?
If so, the Scripting Block might make this task a lot easier.
Either way, it would be helpful to know quite how you have your base set up. For starters, I might suggest a setup similar to this:
Not sure why my previous post is pending, but I’ve got something similar to this that I can share with you if you wish to reverse-engineer it and adapt it to your situation. I don’t have time to delve into the inner workings right now, although I do plan to share a how-to in some form (video, probably) at some unknown point in the future.