I am trying to get in contact with the Glide Expert who built an App that I am now managing.
Unfortunately there is an issue with how the App is handling and displaying a certain data set.
The errors relate to a specific time period (a specific yearly quarter.)
To further explain, the required functions are working as designed for:
Quarters 1,2,3,4 for 2023
Quarters 1,2,3 for 2024
Quarters 1 for 2025
For some unknown reason the Q4 2024 period will not function correctly (tally training hours for the period) within the same table as all the other ‘functioning’ quarters.
Same calls, same location but errors with 1 specific Row ID ???
The screen capture from the layout view below shows how training times are displayed as a total for that quarter.
The Q4 2024 total is displaying as 0 Structured and 0 Total even though the training has been completed and displayed just below.
You can see that quarterly totals either side of Q4 2024 are tallying and displaying correctly.
If I am unable to make contact with Marco Volpato are there any developers who may be able to assist with this issue ?
Can you share more details on how those number are calculated? Show how the columns are set up and how they pull in data.
@Loqode
Hi Jeff, here’s a visual snapshot of where/how the period is pulled and displayed
The total training hours as displayed on the front end is based on the above summary. What is very confusing is that the same process is used for all the quarters collectively… yet it throws the error for the Q4 2024 period only ???
The total training hours has 2 elements, structured and total hours. This is because the minimum training hours is 3 but must included a minimum of 1 hour Structured training
How are rows added to the Training Status table? Are there any rows in that table that represent Q4 2024 but have an ID that doesn’t match? Is it possible the Q4 row in the Attestation table was ever deleted and readded after data was added to the Training Status table, this assigning a new RowID?
The row for the period in the Training Status table are added via the ‘related’ call from the Attestation Table (Unique ID). There is no other reference to the Q4 2024 row anywhere else that I can locate.
To answer your question, there is only 1 RowID for the Q4 2024 period in the Attestation table as shown below
For some reason this ID is not being pulled from the Attestation Schedule and inserted into the Training Status table ?
I can not understand why it was working previously and then stopped for that particular quarter and is now displaying the correct tallied figure for Q1 2025 ???
Do you have any rows in the Training Status table that represent Q4 2024 data? What’s in the Period ID column for this rows? I’d say just update the ID in those rows to match what’s in the Attestation table. If the IDs don’t match, then that brings the question of how did that happen…
There are no rows in the Training Status Table that represent Q4 2024 data.
The last row is the last data entry for the Q3 2024 period as shown below.
The training status table ‘pulls’ the period from the Attestation Schedule, but as identified, the Row Id for that Q4 2024 period is not coming across.
There is a Training Register table that records all training related info, with elements of that used/pulled into the the Training Status table.
There are records there for the Q4 2024 period and also Q1 2025… but there is nothing being inputed into the Training Status/ Related Quarter column in the Training register anymore… I say any more, as it was and is working for all quarters prior to Q4 2024 and Q1 2025 (screen cap below)
Info/data in this column is either represented by Row Id (which matches the User ID (Shown below)
OR
as [ ? ] Drop Down
What is even more confusing is the fact that Training Records for Q1 2025 are displaying correctly (with tallied Training Totals) BUT there is no entry in the Related Quarter column on the Training Register !!!
You can see the correct data displayed on the front end !
Q1 2025 has training recorded and calculated/tallied figure
Q4 2024 has training recorded but no calculated/tallied figure
Sorry, I’m struggling to follow along with the flow of everything.
I think this part needs to be explained in more detail. I’m not sure what you mean by “pull”. What causes new rows to be added to the Training Status table?
The Training Status table is comprised of over 40 columns, the majority of these linked to the Training Register and approx 1 related to the Attestation Schedule (to set quarterly period)
In the screen capture below, the Period / T ID is the code from the Attestation Schedule for the individual yearly quarters.
Please note the last 2 entries are a result of me manually entering the Attestation Schedule Q4 2024 ID into the Period / T ID cell. I then inserted a user ID from the Training register (the row was a completed training record) which then populated the entire row with the required Training Status details from the Training Register… There is over 150 entries for the Q4 2024 period so I do not want to have to cut and paste every one of this in order for the Training Status table to update (which in turn sees the total hours total tally correctly and display on the front end page.
*The inclusion of the Period ID from the Attestation is what I clumsily referred to as the ‘pull’ of data into the Training Status table.
What I am trying to determine is how/why the Period ID from the Attestation table stopped being added to the Training Status table automatically (at the beginning of q4 2024, and in doing so, failing to update the total hours tally which then appeared on the front end ?
[EDITED]
As to your question of what causes a new row to be created/added in the Training Status table, unfortunately I simply do not know.
Hi Jeff, from what I can work out, the start of the new quarter causes a new row to be created in the Training Status table. IE it is date dependent/triggered
I’m guessing (and by no means is that an educated guess) that there is an issue/error with the date function which is preventing new rows for the Q4 2024 period to be created in the Training Status table. The App is constantly (every 9 seconds or so) ‘refreshing’ itself which results in a flicker of the screen and then it scrolls back to the top of the page. It looks to be stuck in some type of ‘check’ loop. From within Data view I can see that the columns associated with the Period in the Training Status table are refreshing… IE there is no data in the column and then for a split second something flashes up and then disappears. Approx 9 secs later it does the same thing
If you’re still looking for Marco, you can find him here
1 Like
