Column data not showing for specific user

[Paarl_Bus]

Good day again! Just after posting my previous help request I encountered another inexplicable problem.

I have a Text field on a layout that shows the 2 dates for the upcoming trips this weekend. For nearly every user it is correct but for some it does not show the first date.

The dates are calculated in the Users table and both are correct for this user. See screenshots.

Friday’s date (17) in user table. Logged-in user Jo-Marie

Friday’s date not showing

Code for the Title field

Correct dates for every other user

Since the dates come from the user profile, I checked both the user table and the profiles for those that display an incorrect title.

What I’ve found are the following:

1. 2 users show no Friday date.
2. 1 user with a child already booked shows the warning message but no Title (with the dates) at all, while another user also with a prior booking shows both warning message and correct Title.
3. The user profiles for case 1 above have empty Day2H fields, It is correct in the Users table and the formula to calculate it is, of course, the same for everyone.

Profile does not calculate Day2H though Date2H is correct

Profile showing correct calculation result for Day2H

Any takers?

Herman

[ThinhDinh]

Can you tell me what table is this screen tied to? Do you have any filters on the tab level?

How do you construct Date2H (the ITE column).

[Paarl_Bus]

Hi @ThinhDinh . The screen is tied to the Trips table and there are 2 filters for the Collection only - the child’s name is in the user profile related column for their children, and the date is On or After Today.

The dates are calculated through quite a long process (stored in Users table):

1. Calc date for this Friday - now+6-weekday(now)
2. Get the month of date in 1
3. Check if date falls in a school term (lots and lots of helper columns)
4. Calculate Date2H with this ITE:

Hope it helps.

Update:

It now works correctly. I don’t know if it the reason why, but I changed the process of calculating Date2H. Previously I used 3 columns, to get today’s date, to get the weekday for today, and to calculate Friday’s date. I realized they could be combined so I did that.