Virtual column not showing in detail view but does in Test

[VictorB]

Hi every one, 

I'm using a VC to get a date from a child table with this expression (the idea is to get the latest update date from the table Indexs and to show it in the view of the related meter) : 

LOOKUP(MAX([Related Indexs][_RowNumber]); "Indexs"; "_RowNumber"; "Date")

The expression is working when I run the Test tab, but don't show up in the view. EXCEPT when I add a new value to the table Indexs, and the app didn't sync, 10 sec later it's gone.

Did some one have any idea ?

[Rafael_ANEIC-PY]

Hello @VictorB, here's a few things that you can check:

1- Is the VC included in the view?
2- Does it have any conflicting showifs?
3- Is the row that was just added saved correctly?
4- Is the virtual column's type the correct one for this case?

[VictorB]

Hi @Rafael_ANEIC-PY , 

1- Yes it is, it's sowing up for like 5 sec (and I've checked the view options)

2- Following an older post I've tried to set the showifs to TRUE, but it don't change any thing. 

3- Yes, I can see it one the google sheets

4- Yes, it's a Date type

[VictorB]

You can see that "Last Date" is showing after a value is added and disappear after the sync. 

[VictorB · Accepted solution]

I solved it by changing the expression : 

INDEX(
             SORT(
                     SELECT(
                                      Indexs[Date]; [ID Liste compteurs]=[_THISROW].[ID]
                                     )
                     ; TRUE)
               ; 1)

But I don't understand why the previous one did that. 

Any way, thanks for your time.