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
Solved! Go to Solution.
You can put the expression in the Initial value field.
You can put the expression in the Initial value field.
It works, Thank you Joseph...
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |