You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Forms - Lookup failed to retrieve data from tables

posted on December 5

Normally when a lookup fails, it just falls back on the static values for the drop down.

In this case a customer is getting a message when trying to submit, "Lookup failed to retrieve data from tables".

[LFF378-Lookupfailed]

Why is it not reverting back to the static values? Also does this mean they can never submit the form? How do we see which lookup or data is failing? Everything appears to be working correctly.

0 0
replied on December 7

Was this working and then it stopped? If so, it could be that permissions have changed at the user or database level. Check the variables for what is being sent to the lookup. If it is sending a null value, it will return a null value because those are the results rather than the static initiating value.

0 0
replied on December 7 Show version history

The customer says all the lookups are working, returning the values from the database. That is why I am looking to know which lookup the system is upset about, so that I can drill into that specific configuration. What happened to just using the static values when a lookup fails? Never heard of it preventing a submission.

 

Edit: Also it is worth noting that LF378 has not been documented yet and they are using the App, I am wondering if this error was just recently coded into the app store updates.

0 0
replied on December 7

Hi Chad, Does the customer get the same error using Forms on a desktop machine or in the mobile browser as they do in the app?

0 0
replied on December 10

Also, did you see any errors in the event log? This is sounding like a support call to Laserfiche. Best of luck with it!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.