Link To Form Formula

AppSheet AppSheet Q&A
,
1

Hello,

I am trying to write a formula to link to a form slice I’ve made. However I am running into 2 problems with the following action formula:

=LINKTOFORM(“Off Rent Request”, “Equipment ID:”, [Equipment ID:], “Approval Status”, “Transfer Requested”)

First problem being Equipment ID isn’t locked (They can change the info there, I need it to be locked, but showing what was on the previous page). Second problem being I need the approval status to be filled in with “Transfer Requested” even though I’ve got that column hidden in that slice. Is that possible?

1 Like
2

@Joshua_Giles
You can set the Show_if property of both columns to FALSE so that they won’t appear in the Form UX, but will be filled with data you have set in the deep link.

3

@LeventK That would work for this form view, but I need that column to appear in a different view. This form sets the status of the row (i.e. “pending approval”), I then need a different view to be able to change that status (i.e. “Approved”).

Is there a way to write a show_if formula that only shows in specific UX’s?

4

How awesome, I just found your answer in a different topic. NOT(CONTEXT("ViewType")="Form") should do the trick lol

5

@Joshua_Giles

CONTEXT(“View”) = “YourViewName”

specifies a particular View

6

Using Show_If to hide a column you don’t want users to modify is the wrong approach. Instead, set Editable_If to the expression, FALSE. Note, this isn’t setting Editable? to OFF.