JohnBarulich1
8 years agoQrew Cadet
Wondering how to reference a property from a field in the same table
Hi people,
I have just started using QuickBase but having coding experience. In my table, I have a column called Tours. When I click on Tours, it shows me Start Date/Time and End Date/Time. In the same table, I have an Available column and would like to populate it with 'Yes' when the CURRENT Date/Time is between the Start Date/Time and End Date/Time. 'No' if it's outside of the interval.
I would like to know how to reference those two properties of the tour field when writing a formula. I would also like to know which potential function call would guarantee that Available is updated automatically.
Thanks,
John B.
I have just started using QuickBase but having coding experience. In my table, I have a column called Tours. When I click on Tours, it shows me Start Date/Time and End Date/Time. In the same table, I have an Available column and would like to populate it with 'Yes' when the CURRENT Date/Time is between the Start Date/Time and End Date/Time. 'No' if it's outside of the interval.
I would like to know how to reference those two properties of the tour field when writing a formula. I would also like to know which potential function call would guarantee that Available is updated automatically.
Thanks,
John B.