Forum Discussion

JohnBarulich1's avatar
JohnBarulich1
Qrew Cadet
7 years ago

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 ...
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
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.
JohnBarulich1's avatar
JohnBarulich1
Qrew Cadet
7 years ago
Another update:

Starting to realize I can probably create a relationship based on these values. Can anyone lead me in the right direction. Sorry to constantly change my ideas, I was thrown into this head-first and have never used QuickBase

Thanks,
John