I have a timesheet App where users will enter start end end times for a particular Job.
In the job Table there is a VC in the Job table called “Related Timesheets by Job”, which is fine.
I also have a table where users enter extras, and they do timesheet entries for this as well. There is a VC in the Extras table called “related Timesheets by Extras”
Both of these will populate a column in the timesheet table with their unique codes… the one from Job will populate the column [Job] and the one from the extras populates the column [extras].
Now, I am trying to filter out which columns show, depending on whether the [Job] column has anything in it, or the [extras] column.
Using the Show-If condition:
Now, the [Extras] column IS NOT BLANK, so the columns I am wanting to show/hide should hide…
But they are not hiding… and a quick check showsthat the App thinks the [Extras] column is empty, when it isn’t…
Any ideas why this may be so?
Is it possible to have timesheets coming from two different directions, one from Job and one from Extras, but the one from Extras also populates the [Job] column in the timesheet with the Job ID?