Data from related table showing for one user but not for the others

How come the PDF attachment template captures data from the related Shift table showing for user 1 but not for any other users? User 1 is my default user and has old data captured, so maybe has something to do with that?

PDF attachment template

Pejme_0-1656998922578.png

App formulas

Pejme_8-1656999800415.png

 

Pejme_9-1656999859169.png

 

 

 

Data in Gsheet for user 1 - Pay review table

Pejme_2-1656999117447.png

Data in Gsheet for user 1 - Shift table

Pejme_3-1656999234434.png

 

Attached pdf for user 1 (working)

Pejme_1-1656998989795.png

 

Data in Gsheet for user 2 - Pay review table

Pejme_6-1656999585645.png

 

Data in Gsheet for user 2 - Shift table

Pejme_5-1656999539351.png

 

Attached pdf for user 2 (not working)

Pejme_7-1656999614353.png

It only works for user 1. No data is captured for any other users.

 

Also, I had another issue that might be related.

Email body template:

Pejme_12-1657000426507.png

App formulas

Pejme_14-1657000480692.png

 

Pejme_13-1657000461037.png

 

For user 1, both the virtual and the Gsheet column data are captured.

Pejme_10-1657000351889.png

 

For all other users, only the Gsheet data is captured.

Pejme_11-1657000388925.png

I don't understand what the problem is, but I solved it by replacing the virtual columns with Gsheet columns. However, I can't do this for my other problem as related columns needs to be virtual columns because the need to be List columns (I think).

Pejme_15-1657000680620.png

 

Any advise?

Solved Solved
0 4 134
1 ACCEPTED SOLUTION

@Steve So, when I said that I was facing issues for users other than mu default user, I meant that I am using the Preview App as functionality.

Pejme_0-1657090317672.png

I tried now to actually using the app on my phone. I logged in with another user (not my default user), and everything seems to be working fine. Can it be that some things don't work when using the Preview App as functionality? So nothing wrong with the app expressions etc, just Appsheet not working 100% in Preview App as mode?

View solution in original post

4 REPLIES 4
Top Labels in this Space