Attempt to Auto-fill Form makes field disappear in form view

[mklein]

I am creating a real estate app and working on a function to send property information to a client. To do this, I have created an action where the user presses the button "Send to Client" on the property page and that takes them to a form to capture the client's email, which sets off a automation workflow where an email is sent with the property information. Here is my first dilemma:

I have the address as a ref row to the Property data set. This results in a drop-down field in my "Send to Client" form (see below). I would prefer for the address of the property they were viewing to auto-populate in that field and they simply need to input the client's email. 

When I try to input an expression in the Address field in the Auto-Compute section within the App Formula field, it makes the Address field on the form disappear instead of auto-filling. See below:

Does anyone have a solution? It seems that any expression that I try in that field results in the Address field in my form to disappear. Is it because it is a reference column?

[SkrOYC]

---

@mklein wrote:

I would prefer for the address of the property they were viewing to auto-populate in that field and they simply need to input the client's email

---

LINKTOFORM() - AppSheet Help
Conditionally show or hide a column value (Show_If) - AppSheet Help
Control column order - AppSheet Help

[mklein]

Thank you for sending those links, but the information doesn't seem to solve my problem (or I can't seem to apply them correctly).

Any time I place an expression in the Formula space within the data sheet, the form field disappears (as shown above). If I place an expression in the Initial Value space it does not show in the form. I have tried changing the Type from "ref" to "address" to "text" and I am still getting the same result.

Any additional guidance? I am not sure what I am missing.  

[SkrOYC]

You don't have to use any app formula nor initial value, just the LINKTOFORM().
Then you can use a Show_If that hides the field if there is data in it

[mklein]

Currently, I have the "address" as a ref field type. Should I change the type (ie: Text field or Address field) and then use the expression LINKTOFORM()? 

Also, I WANT it to display the address automatically based on the property they are clicking the "Send to Client" action button. So I am not sure if Show_If is appropriate here since I don't want to hide the address.

My problem is that when I include an expression in the formula field of the data table, the address field in the form disappears. When the formula field is empty in the data table, the address field in the form is a drop-down. I would like the initial value to be the address from the detail view of the property the clicked the action button on. 

Any suggestions?

[SkrOYC]

I think you need to study the links I sent you a little bit more, also these ones:

Define App formulas and Initial values - AppSheet Help
Conditionally allow column edits (Editable_If) - AppSheet Help
Dereference expressions - AppSheet Help