actions and views

[Fre3]

I want to make a button in a table that opens a form that associates with changing information on my table. 

However I only want to show what I'm changing in the form rather than the rest of the information. 

Image 1 is the button and table. 

Image 2 is the form I have currently created (red is what I want to show, green is what I don't need on the form)

Which action would it be to do this, any more information I can also provide. 

[Fre3]

Current view layout of tableCurrent view 

[Rafael_ANEIC-PY]

Hello @Fre3, you can use a LINKTOFORM() deep link action to direct your user to another form view with which you can use a condition based on a CONTEXT("View") expression in your Show_If column for your "Owner" column.

OR you can just hide that edit button altogether and turn on quick edit only for the columns that you wish the user to modify, that way they won't be able to edit the rest at all.

I suggest you go with the second path, I use it a lot.

[Fre3]

I'm going to be picky and choose the first one as I need the experience with expressions haha hope you don't mind :). 

The LINKTOFORM() and CONTEXT("View") expression where am I supposed to put these specifically. I think once I know this I should be okay with the rest.

Thank you 

[Rafael_ANEIC-PY]

Haha no problem, the LINKTOFORM() should be the action that the user should use to edit the record itself, so it should reside in that table, the action type is called "Go to another view within this app" and below it is the "Target" which is where you type in your expression, you can read more about LINKTOFORM() here:

https://help.appsheet.com/en/articles/2357261-linktoform

Then, the CONTEXT("View") expression should go into either the show_if or the editable_if of those column that you do not want to show or allow to edit, and the condition should let the user see those columns everywhere else except inside that form view, that can be done like this for example:

CONTEXT("View")<>"Form 2"

[Fre3]

Okay so the link to form opens a new form view for that table which is great. However I'm still not getting how I'm supposed to be editing just the contactid of a particular row that the form is supposed to be opening?

[Rafael_ANEIC-PY]

You need to use the CONTEXT() function to let the app know that the user should only be able to edit the contactID of the row when the CONTEXT("View") = "Form 2", being "Form 2" the one we made for this purpose, you can use show_if or editable_if for this, check these out:

https://help.appsheet.com/en/articles/2347640-context

https://help.appsheet.com/en/articles/961221-show_if-column-constraint

https://help.appsheet.com/en/articles/961206-editable_if-column-constraint