Skip to main content
Question

New field based on date duration

  • April 26, 2020
  • 0 replies
  • 13 views

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
------------------------------
This topic has been closed for replies.