I have a column with an App Formula of:
LOOKUP([_THISROW].[JobID],“Combined”,“JobID”,“Insured”)
It works great if there is a value to pull into the App from “Combined”.
But if there is no value to use yet I need a way for users to enter their own value which of course will be available once “combined” is available.
I tried the formula in the Suggested Values box but it breaks the App.
Is there a way to allow a user to enter a value so he doesn’t have to wait for “Combined” to make a value available to overwrite the users temporary value?
Regards