Displaying records in list view from Virtual Record Table not possible

[cat traveller]

I have collected data in global variables that I usually display without a problem in portals and in list view in the filemaker app. 

For this I created fields in a table that calculated unstored GetValue ($$myvariable ; RecordNumber) whereas Record number is a set indexed field of that table. 

When I try to display this data in filemaker Go it also works. However on webdirect (unfortunately some of our staff have android phones, it will display as ?.

Is this common behaviour for webdirect? I also tried a layout calculation that also displays ?

Thank you all

 

[Søren Dyhr]

Beyond that you could use Get(Recordnumber) instead of a field you define .... would I take into consideration that every $$variable value belongs to each user, which means that a script is needed to initiate it for each "session" ...

--sd

Edited August 5, 2024 by Søren Dyhr

[cat traveller]

Yes, this might work as well. The issue is that it's not displaying in Webdirect. In filemaker Go and on filemaker it is displaying correctly. I am trying to find out how to display the data in filemaker web direct.

Cheers

 

[Søren Dyhr]

I understood it the first time around, but what if you're jumping onto a wrong diagnosis ... that something else causes it?

Your issue, seems instead to be in the vicinity of this:

https://community.claris.com/en/s/question/0D50H00006h95smSAA/multiuser-webdirect-design-issues

--sd

[cat traveller]

SOLVED.

you were correct Soren. I did drill through the script step by step. 

I was pulling the data via Execute SQL from three data files. Two of them did not have the right Webdirect enabled. Thats why the SQL result did not return anything. I have turned off webdirect access in security by default. 

Afterwards - all working. 

Thanks and Cheers

Edited August 7, 2024 by cat traveller