Suggested Values - LOOKUP

[DaveWillett]

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

[Joseph_Seddik · Accepted solution]

You can put the expression in the Initial value field. 

[DaveWillett]

It works, Thank you Joseph...