Forum Discussion

SyaefulBahri3's avatar
SyaefulBahri3
Qrew Trainee
5 years ago

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
------------------------------
No RepliesBe the first to reply