Custom "Form View" - Row Key

[Fraxinus]

I am having difficulty creating a custom form.

I have the problem in this article (https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Form-View-Option-Row-key-Only-edit-one-specific...) but my struggle is that I cannot figure out how to write an expression that evaluates to the row ID / key. My goal is to tigger an action from a DETAIL view, that points to a custom FORM, with only a few columns from the DETAIL view that preceded it.

One of my big challenges is writing SELECT and FILTER expressions, and I don't think this is any different. I need help writing an expression that results in a row key column (which is named "Row ID" as I am using AppSheet database on the back end).

Can anyone help?

[Suvrutt_Gurjar]

Are you not able to use one of several expressions suggested in the post you have referred?

Something like 

ANY(SELECT(Table Name[Row ID] , [UserEmail]=USEREMAIL()))

[UserEmail] is the column in the said table that contains user's email. The solution assumes that there is just one row per user in the table.

[LIUZheng]

Reading your note "My goal is to tigger an action from a DETAIL view, that points to a custom FORM, with only a few columns from the DETAIL view that preceded it.", my understanding is to create an action in the table to Do this: 

"App: go to another view within this app", with the target expression as "LINKTOFORM", which is to create new row. In your expression for LINKTOFORM, use [_THISROW].[xxxx] to refer to the column from the DETAIL view that proceeded it.

You may share some screenshots for better understanding your need

[Suvrutt_Gurjar]

---

@LIUZheng wrote:

My goal is to tigger an action from a DETAIL view, that points to a custom FORM, with only a few columns from the DETAIL view that preceded it."

---

---

@LIUZheng wrote:

"App: go to another view within this app", with the target expression as "LINKTOFORM", which is to create new row. In your expression for LINKTOFORM, use [_THISROW].[xxxx] to refer to the column from the DETAIL view that proceeded it.

---

I think you are on right track. You may want to take a look at the sample app below

Linktoform Example - AppSheet

The sample app is from the help article Get started by using the feature samples - AppSheet Help

[Fraxinus]

I think this is getting me on the right track - there is only one tweak: I don't want to add a new row with this form, I want to edit the existing row displayed in the DETAIL, except using the custom form. This is where I am getting hung up.

[Fraxinus · Accepted solution]

Got it! LINKTOROW([_THISROW],"Internal Notes"), where "Internal Notes" is the name of the view. I tested it, and it works!!

Thanks for putting me on to this!! 🙂 

[CarlosSoares]

You are right. Solved my problem. Thanks a lot!