calendar, timeline, working-hours, computed-field

Question

Hi,I’m building a weekly service planner in the new Airtable Interface (Calendar element).My setup uses: 	Pradžios laikas (Start date/time) – editable date field			Pabaigos laikas (skaičiuojamas) (End date/time) – a computed formula field	 The interface does not allow dragging or even showing the computed end date properly.Also, I cannot find any option to limit visible working hours (e.g. 08:00–18:00) — the calendar always displays 24h. My goal: 	Display a weekly calendar (for 5–6 working days)			Show jobs only between 08:00–18:00			Allow visualization using a computed end date	 Is there any current workaround or plan to bring back these settings to the new Interface Designer? Screenshots attached (showing the “computed field” restriction message and 24h timeline).Thanks in advance for your help!If this behavior is expected in the new Interface Designer, could you please confirm whether support for computed End Date fields and configurable working-hour ranges (e.g. 08:00–18:00) is planned? This setup is critical for real-world workshop scheduling (service planner use case). I really appreciate any insight or roadmap information. — Gytautas

TheTimeSavingCo · Answer

Also, I cannot find any option to limit visible working hours (e.g. 08:00–18:00) — the calendar always displays 24h.Try using a formula field to help with this. For example, in the following screenshot I’m using this formula:IF(  AND(    DATETIME_FORMAT({Start date}, 'HH') >= 8,    DATETIME_FORMAT({End date}, 'HH') <= 18  ),  'Visible',  'Not Visible')And in the Interface, we can then filter it so that it looks like this:The interface does not allow dragging or even showing the computed end date properly.Yeah computed fields prevent the drag and drop I'm afraid. To get around this, try creating a Date field and using an automation to paste the calculated value from the formula field into the Date field insteadCould you provide some screenshots of the computed date not showing up properly? The screenshots you mentioned in your post aren’t showing up

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded