![]() You'd think by the use of the words "in relation" that you could deal with this in a relational way, but I see it as a rule: I've dealt with a problem like this before: when an event happened in relation to other events mattered. I know there is a possibility to write a script in Python with an AirTable API. The course is divided in multiple classes, it would also be awesome to have a timeline view with the full Course and all the classes. ![]() If the end date falls on a sunday, it needs to add +2 so that it ends on a Monday. If there's a bank holiday in the 10 days after the start date, and it's on a weekday, it needs to add +1 to the end date. The "session type" would be "Course 1", which has a duration of 10 days (two weeks, monday to friday - I don't know if the duration should be 14 days instead?). I have a session starting on Monday, 7th of march. I'd like for the user to have the end date generated automatically by only writing the start date. ![]() I have created a "bank holiday" table, as well as a full calendar table (containing everyday of the year and what weekday it falls on). If the bank holiday falls on a weekday, it needs to add +1 day to the end date. I am developing an automated calendar for a school on AirTable, but I am struggling to add if there is a bank holiday between the start date and end date.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |