Skip to main content
Question

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

      I think this is what you are looking for:
      If([Start Date/Time] < Now() and Now() < [End Date/Time],
        "Yes",
        "No"
      )
      However, you statements "I have a column called Tours. When I click on Tours" and "two properties of the tour field" leave me a little confused as you refer to Tours as  if it wasa field when I think you might mean Tours is a table.
      Terms & ConditionsAccessibility statement