SyaefulBahri3
5 years agoQrew Trainee
New field based on date duration
Hi All,
I have Table event consists of
Event name: Quickbase training (text field)
Start date: 1 April 2020 (date field)
End date: 3 April 2020 (date field)
Duration (days): 3 (Formula - Numeric)
I want to create a new table that consists of attendees status dynamically based on the duration field above
Something like this if possible
Day 1
Status: Online
Day 2
Status: Offline
Day 3
Status: Online
If the Duration (days): 5, there will be
Day 1
Status: Online
Day 2
Status: Offline
Day 3
Status: Online
Day 4
Status: Online
Day 5
Status: Online
and so on according to how many days for durations
Many thanks
------------------------------
Syaeful Bahri
------------------------------
I have Table event consists of
Event name: Quickbase training (text field)
Start date: 1 April 2020 (date field)
End date: 3 April 2020 (date field)
Duration (days): 3 (Formula - Numeric)
I want to create a new table that consists of attendees status dynamically based on the duration field above
Something like this if possible
Day 1
Status: Online
Day 2
Status: Offline
Day 3
Status: Online
If the Duration (days): 5, there will be
Day 1
Status: Online
Day 2
Status: Offline
Day 3
Status: Online
Day 4
Status: Online
Day 5
Status: Online
and so on according to how many days for durations
Many thanks
------------------------------
Syaeful Bahri
------------------------------