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:
ISBLANK([Extras])
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?
@Green_Gorilla Does the expression tester show that ISBLANK returns the unexpected value?
Well, the expression tester only shows the first 900 or so rows of the spreadsheet where this data is not present. But I made a virtual column with the ISBLANK part and it confirms it is NOT blankโฆ
@Green_Gorilla Are you in a form view or another view? If in another view, try setting โApply show-if constraints universallyโ under UX > Options.
@tony I will have a lookโฆ the view in which it works is Form View, and then it goes to detail view when saved, I think.
Thanks
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |