The cover field is a designated attachment field, the contents of which appear at the top of each kanban card. From here, you can change the associated field (by clicking on the appropriate radio button) or create an entirely new single select or collaborator field. In the view bar, there's an option that says "Stacked by " which tells you which field you're currently using for this kanban view.Ĭlicking on this will bring up the field picker again. We'll use the "Status" field to create our initial kanban stacks:Ĭustomizing a kanban view Changing a kanban view's associated field If you do not already have an existing single select or collaborator field, you can create one using the "+ Create a new single select field" or "+ Create a new collaborator field" options. You will then be prompted to select one of the table's single select or collaborator fields to use to create stacks. If your view creation section is collapsed, you will need to first expand it. To create a new kanban view, open the view sidebar, then underneath the "Create" heading click the "Kanban" option. To see this view in action, check out this video! Creating a kanban view Click and drag to move cards between different stacks, or reorder them within a stack. Start day < 10 work days to Bank holiday? is a lookup field from the Calendar table for that day.With the Airtable kanban view, you can visualize your workflow in a board of stacked cards. I also have the view, Weekday, not bank holiday, and that's the view that you can pick a day from to schedule an event from the Event table. I have a Calendar table which has all days, and two supporting "Bank Holiday" fields: does the date fall on a BH, and if not, is the date 10 days or less from a BH. I looked at your examples, and here's my solution. So, for your problem, you need to encode every schedule-able day that's 10 working days or less before a Bank Holiday (BH) so that if the day is selected you know it's less than 10 days from a BH and can conditionally add another day to the end date. If Event A happens at Time 1, and it's so much or so little time from Event B, then do with Event A.Īnd, again by my way of thinking, rules are expressed in code.Īnd if you actually even can express that with a relation, I think it'd be very convoluted. 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 |