Iโve heard through the grapevine that Iโm not the only one having this issue, can we get some sort of update on where weโre at with a fix? Looks like this has been going on for at least a weekโฆ
Solved! Go to Solution.
It looks like the problem is not REF_ROWS with slices generally, but more specifically cases where thereโs a mismatch between the table or slice specified in the expression vs the referenced table configured below, for example:
I expect the fix will be released sometime tomorrow, but in the meantime changing the referenced table name to match the expression would also fix it. I think the expression result should be equivalent, but there could be some side effects like which inline view is used for the column, so if you want to try this as a workaround please verify in the preview that the behavior still looks correct before saving the change.
@MultiTech_Visions , you mentioned this the other day?
Last week I had noticed this and reported it; they confirmed there was an issue and pushed a fix out the next dayโฆ that was last week, and everything has been working as expected on my end.
Mind you, thereโs various โnodes,โ or whatever you want to call them, that people are on for feature deploymentโฆ so I might be on a different one than others, etc. etc.
The behavior Iโm expecting to see is the following:
Reverse references with their REF_ROWS() formula un-touched
Reverse references with their REF_ROWS() modified - meaning Iโve added an ORDERBY() or something to the formula
In our case we have a virtual column with the expression
REF_ROWS(โActivity_Helper_Sliceโ, โRefIDโ)
The child table Ref column is flagged Is a part of? so that we can add entries from the form view of the parent table.
We added a workaround expression yesterday with an initial value to get around the sudden issue so that the ref column still populates while being hidden,
maxrow(โTimesheets_Helperโ,โLast Modifiedโ,[creator]=useremail())
Hello,
What is the Referenced Table Name you use for REF_ROWS(โActivity_Helper_Sliceโ, โRefIDโ) ??
Is it Activity_Helper_Slice or Timesheets_Helper ?
The problem last week only affected a small number of accounts, however it looks like another attempted bug fix has broken this behavior when REF_ROWS is based on a slice. Weโre working on getting a fix out ASAP.
It looks like the problem is not REF_ROWS with slices generally, but more specifically cases where thereโs a mismatch between the table or slice specified in the expression vs the referenced table configured below, for example:
I expect the fix will be released sometime tomorrow, but in the meantime changing the referenced table name to match the expression would also fix it. I think the expression result should be equivalent, but there could be some side effects like which inline view is used for the column, so if you want to try this as a workaround please verify in the preview that the behavior still looks correct before saving the change.
Hi, thanks for your help. Since this error is happening, I have another problem with the reaction between fields. When I select child ref rows and then change some other fields, My list of child disappeared. I send this video to show you the incident. https://youtu.be/GYO5ANMucaQ
Hi Adam, this does appear to have worked! Thanks for your help.
Hi Adam this could be a temporary solution but when we could have the real solution? Please check that there is another problem with interactions between fields. Please your help
I think the inline view going blank is caused by the same issue. A fix should be coming later today, but if you continue to see it happening after the fix we can take a closer look.
Hi Adam, has the fixed been implemented?
Yes, it was released yesterday afternoon (US Pacific time). Are you still seeing this problem today?
Thanks Adam, Iโve tested the scenario successfully - thank you.
Hi Adam, client reported another orphan record today caused by this issue. Can you advise soonest? Thanks so much!
Is the clientโs app fully-updated to the latest version of AppSheet?
Thinking the same so I sent the question over yesterday, awaiting response and will report back.
Thanks Steve
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |