Share
Explore
Event Planning Template
Admin
Globals
t_GlobalVariables
View
Variable
Formula
Expression
Comment
1
f_EventStartDayLong
Sunday, September 15
Concatenate(
WeekdayName(c_EventStart), ", ",
MonthName(c_EventStart), " ",
Day(c_EventStart))
2
f_EventRSVPCutoffLong
Friday, July 19
Concatenate(
WeekdayName(c_RSVPCutoff), ", ",
MonthName(c_RSVPCutoff), " ",
Day(c_RSVPCutoff))
3
f_EventEndDayLong
September 15-18
Concatenate(
MonthName(c_EventStart),
" ",
Day(c_EventStart),
"-",
Day(c_EventEnd)
)
4
f_MyActivity
[ ]
[Sign Ups]
.Filter(
Participants.Email
.Contains(
User().Email
)
)
5
f_MyBooking
[ ]
t_Hotel
.Filter(
[Work Email].Lower() = User().Email.Lower()
)
6
f_MyRecommendedShuttle
t_Shuttle
.Filter(
Airport = f_MyBooking.[Departure Airport] AND
Time >
(f_MyBooking.[Departure Time].First()
.DateTimeTruncate(
"minute"
) -
Hours(3))
)
.WithName(
n_RecommendedShuttle,
If(
n_RecommendedShuttle.Count() > 1,
n_RecommendedShuttle.First(),
t_Shuttle
.Filter(
Airport = f_MyBooking.[Departure Airport]
)
.Last()
)
)
Find the recommended shuttle to the departure airport. This will also choose whichever shuttle the user has selected if they have already chosen one other than the recommended one.
7
f_MyShuttle
[ ]
t_Shuttle
.Filter(
[Work Email].Contains(User().Email)
)
8
f_ListSetupControls
falsefalsefalsefalsefalsefalsefalsefalsefalsefalse
List(
c_chk_Page1,
c_chk_Page2,
c_chk_Page3,
c_chk_Page4,
c_chk_Page5,
c_chk_Page6,
c_chk_Page7,
c_chk_Page8,
c_chk_Page9,
c_chk_Page10
)
This is the list of toggle controls that represent each of the setup steps.
This is used as the core object to calculate the progress bar as well as the progress message.
The formulas below use this object to calculate how many steps have been completed and remain.
9
f_SetupTotalSteps
10
f_ListSetupControls.Count()
10
f_SetupStepsCompleted
0
f_ListSetupControls.Filter(CurrentValue = true).Count()
11
f_SetupStepsRemaining
10
f_ListSetupControls.Count() - f_SetupSetpsCompleted
12
f_SetupProgressBarHeight
30
Rectangle height for the progress bar.
13
f_SetupProgressBarUnitWidth
90
f_SetupProgressBarHeight * 3
Calculation for each step’s width (3x the height).
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.