This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
The dashboard contains views of CCS_Table, CCS_Detail and CCS_Comments.
The first two are based on the same CCS table, the third is based on a
slice of the CSS_Comments table. So the discrepancy is due to the
comments view being based on a different ...
I’m a little confused, if both are detail views of different tables that
reference Orders then I would expect them to behave consistently one way
or the other. But I didn’t understand what was meant by “related views
to the Orders Table. So they are ...
Actually I’m not so sure now if MaxRow will even help, it may just get
converted into the same kind of nested structure. If that doesn’t seem
to reduce the delay, you could try taking the original lookup and
pulling out the MAX(SELECT(…)) part into i...
Hi @Aaron_Moolb, I took a closer look at what’s going on here. It turns
out it’s actually the column called Last Day Off in the Employees table
that’s causing the big delay. When an Attendance record is updated,
since it has a Ref to an Employee reco...
Yesterday I was thinking of using a slice to filter the date range, but
I realized the same problem occurs for virtual columns with app formulas
involving slices - if a data change affects the slice filter condition,
although the view will update wit...