Create conditional action button

AppSheet AppSheet Q&A
, , , , , , , , , , ,
1

Hello Community, I want to create an action button:

Do this: Go to another view with in this app

Deck view of table “Assigned Assets” where this action button will be placed.

Target: Linktoform(“Asset Return Request_Form”,“Asset Id”,[ID],“Primary Device”,[Primary Device],“Make”,[Make],“Model”,[Model],“S.No”,[S.No],“Location”,[Location],“System Hostname”,[System Hostname],“Processor”,[Processor],“RAM”,[RAM],“Ram Types”,[Ram Types],“HDD/SSD”,[HDD/SSD],“OS”,[OS],“Office 365 License”,[Office 365 License],“Owner”,[Owner],“User Mail Id”,[User Mail Id],“Manager”,[Manager],“Manager Email”,[Manager Email],“Attachement”,[Attachement],“Vendor Name”,[Vendor Name],“Purchase Date”,[Purchase Date],“Issued Date”,[Issued Date],
“Country”, [Country],
“Work Location”,[Work Location])

Condition: [ID] value of this row should not listed in “Asset Return Request” in Asset ID schema and if listed the value of Status schema should Contain Approved or Rejected.

How can I achive this condition?

2

NOT( IN ([ID], Asset Return Request[Asset ID]) )

1 Like
3

@TeeSee1 Thanks, or if the ID is listed in Asset Return Request[Asset ID]) the value of Asset Return Request[Status] of that row should contain “Approve” OR “Rejected”. How to add this or condition in you given formula, please help me with this as well!

4

Try this.

ISNOTBLANK(
 FILTER(
  "Asset Return Request",
  AND(
   [_THISROW].[ID] = [Asset ID],
   IN (
    [Status], {"Approve" ,"Rejected"}
   )
  )
 )
)
5

@TeeSee1 , tried this one but didn’t worked actually there are two tables “Asset Current Data” where ID schema is lsited and there is another table “Asset Return Request” where Asset Id and Status, in Asset current data view i want to add an action button which can be accessed based on condition that ID vaue of this row should not be there in asset id schema or if listed the value of Status schema of that row should conatain Approve or Reject, only on this condition that action button can be accessed

6

OR both of the expressions.