So I'm still in the development stages for 4 ...

[Joshua_Giles]

So I’m still in the development stages for 4 separate apps that all pull from the same excel file on Box. 2 of the apps allow a user to be logged into a GMail account while the other 2 require me to be logged into a Box account that has been given access to that excel document. I want all 4 apps to be able to be accessed by any logged in account.

I have all the same security settings set on the Security Tab under “Require Sign-In” for all 4. Which is:

Require User Authentication? ON Authentication provider: Any Provider Allow all signed-in users: OFF

And I’ve approved this specific Gmail user for all 4 of them.

The error that I receive on the 2 that aren’t working says, “Unable to fetch app definition: Error:User ‘553644’ does not have a valid ‘box’ account/n”

Any ideas? It’s the strangest thing because I’ve created all 4 using the exact same methods

[Aleksi_Alkio]

Have you checked that all apps have correct users in the whitelist?

[Joshua_Giles]

So cool story, turning on and off that security setting requiring the user be logged in multiple times fixed one of the apps. Let me see if the same trick works with the other.

[Joshua_Giles]

It still has the same problem when switched to Google as the authentication provider.

What’s interesting to me is if I turn off the User Authentication if gives me an error saying, the data table “needs to be accessed with the end-user’s auth.” which makes me think the setting is different in the referenced sheet rather than the security setting.

[Aleksi_Alkio]

If all your users are using gmail account, what happens if you change the Authentication provider to Google?

[Joshua_Giles]

It’s baffling…

[Joshua_Giles]

I made them all in the same day and they’re all linked to the same excel document.

[Aleksi_Alkio]

Is it possible that you are using older version in those two apps?

[Joshua_Giles]

@Aleksi_Alkio Yes, they all have the same GMail users in the whitelist

[Aleksi_Alkio]

When you open and close apps while changing accounts etc. sometimes the browser is not able to “follow” all of this. Clearing the browser’s cache sometimes helps.

[Aleksi_Alkio]

Have you tried to clean the cache?

[Joshua_Giles]

I didn’t know that was a thing. How do you do it and what does it do?

[Aleksi_Alkio]

Have you checked that all apps have correct users in the whitelist?

[Aleksi_Alkio]

When you open and close apps while changing accounts etc. sometimes the browser is not able to “follow” all of this. Clearing the browser’s cache sometimes helps.

[Joshua_Giles]

@Aleksi_Alkio Yes, they all have the same GMail users in the whitelist

[Joshua_Giles]

So cool story, turning on and off that security setting requiring the user be logged in multiple times fixed one of the apps. Let me see if the same trick works with the other.

[Joshua_Giles]

It still has the same problem when switched to Google as the authentication provider.

What’s interesting to me is if I turn off the User Authentication if gives me an error saying, the data table “needs to be accessed with the end-user’s auth.” which makes me think the setting is different in the referenced sheet rather than the security setting.

[Aleksi_Alkio]

If all your users are using gmail account, what happens if you change the Authentication provider to Google?

[Joshua_Giles]

It’s baffling…

[Joshua_Giles]

I made them all in the same day and they’re all linked to the same excel document.

[Aleksi_Alkio]

Is it possible that you are using older version in those two apps?

[Aleksi_Alkio]

Have you tried to clean the cache?

[Joshua_Giles]

I didn’t know that was a thing. How do you do it and what does it do?