Calendar
Last updated
Last updated
A calendar with entries that can be viewed, added, edited and removed. Same table setup as in Data grid.
Use blurbs to present day specific data. Enter a title of the blurb and either use text, variables or FlowScript to visualize data in the value field. Use FlowScript to for example summarize data from the grid part of the calendar control, and when the user enter the numbers in the grid the summarized value in the blurb will be live updated.
Example:
Title: Reported Value: {sum((dayEntries where internalQuantity > 0).internalQuantity)}
Calendar start: Start date of the calendar. Enter a date, example: 2018-05-05 or {now()-10}
Calendar end: End date of the calendar. Enter a date, example 2020-05-05 or {now()+10}
Unavailable days: An unavailable day will be grey and not clickable. Enter a date, example {selectedDay = "2018-05-05"} Enter multiple dates from a table, example {selectedDay in blocked.days}
Selected date: This date will be selected by default when entering the step with the calendar view. Enter a date, example 2018-05-05 or {now()-1}
Read-only days: A read-only day will be red when it is selected and it will not be possible to add, delete or edit the data grid for those days. Enter a date, example 2018-05-05 or {now()-1} Enter multiple dates from a table, example {(selectedDay where status = 'Confirmed').days}
Use a case statement to decide what color the columns should have based on a variables value.
Example: {case when SelectedDay in table.column then "RED" else "" end}
Or to mark a date that has got an entry write: {case when any(dayEntries) then "RED" else "" end}
Edit columns: First column in "edit columns" is grayed out. It's possible to choose source, edit title and include and enter output variable.