Create action to update records

By the end of this section you will be able to:

• Create actions on Streams
• Add an action to a view
• Update a selected record with an action
• Create an action that requests values from users

Set a fixed value on records

• Open the model Dashboards and Forms 11-13. Actions to update, insert, delete
• Find the stream Wisteria Books Return Requests, and open the view Wisteria Books Return Requests – you will see a list of book return requests
• You will add an action to update records in this view – to record when return requests are refused:
  • In the configuration form for the stream Wisteria Books Return Requests, go to the Actions tab
  • Press to create a new action
  • Give the action the following configuration:
    • Name: Refuse Return
    • Display Name: Refuse
    • Go to the Item Updates tab, and set
      • Stream Item Action: Update
    • Press  - Apply
  • The form will update – press in the Action Attributes section
    • In the Stream Action Attribute Details form:
      • Select the Attribute ReturnStatus
      • Set Expression to: "REFUSE"
      • Press 
  • Press  in the main action form to save your changes
• To associate the action with a view (you will use an existing view on the Stream):
  • Go to the Views tab
  • Open the configuration form for the view Wisteria Books Return Requests
    • Go to the Menu tab
    • Press - Actions
    • Select your action from the drop down list and drag it into the list of actions associated with the view
    • Press   to apply your changes
• To see the new action button on the view, open the view
• Test your button: select a record and press the button
• Press on the view; you will see the ReturnStatus updated
• Test your button: select a number of records and update the ReturnStatus with your button

Actions to request values from user

You will extend the action you created in the previous exercise to allow users to add to the comment on the record, when they refuse a return.

• First you need to create a form that will be used to take values from the user – in PhixFlow terms, this is known as a Form View:
  • Open the configuration form for the stream Wisteria Books Return Requests
  • Add a view:
    • Name: Enter Refusal Comment
    • Stream View Attributes: HandlingComments
    • In the list of Stream View Attributes double-click on HandlingComments
      • Set Width on Form to 300; Height On Form to 300
      • Tick Multiline on Form

      • Press

• • • • Go to the Advanced tab
      • Tick Form View
    • Press  to save your changes
• Open the configuration form for the action Refuse Return that you created during the previous exercise
• Set Form View to Enter Refusal Comment
• Go to the Item Updates tab
• Add an additional attribute:
  • Press - Show the list of Attributes
  • Drag in the attribute HandlingComments
  • You will see that this is auto-populated with the expression _prompt.HandlingComments – leave this as it is, since this is the expression you need
  • Press  in the main action form to save your changes

This action is already associated with the view, so to test:

• Open the view Wisteria Books Return Requests
• Select a record and press the Refuse button
• In the form that pops up, enter some text into the HandlingComments field
• Press on the view
• You will see the comment update as well as the status

Create actions to insert new records

By the end of this section you will be able to:

• Create an action to insert a record
• You will need to take user input for 2 fields in the new action, so you must create a new Form View:
  • In the configuration form for the Stream Wisteria Books Return Requests, go to the Views tab
  • Create a grid view Add Return Request
    • Add attributes to the view:
      • CustomerRef
      • BookTitle
    • Go to the Advanced tab and tick the Form View flag
    • Press
• In the configuration form for the Stream Wisteria Books Return Requests, go to the Actions tab
  • Press to create a new action
  • Give the action the following configuration:
    • Name: New Return Request
    • Display Name: New Return
    • Form View: Add Return Request
  • Go to the Item Updates tab, and set
    • Stream Item Action: Insert
  • Press 
  • Press - Show the list of Attributes
  • Drag in attributes:
    • CustomerRef
    • BookTitle
    • ReturnStatus
  • Set attribute expressions:
    • (Accept the default expressions for CustomerRef and BookTitle, since we will take these values from the user in the form view)
    • Update the expression for ReturnStatus to: "New"
  • Press
• To associate the new action with the view:
  • Open the configuration form for the view Wisteria Books Return Requests
    • Go to the Menu tab
    • Press - Actions
    • Select the new action from the drop down list and drag it into the list of actions associated with the view
    • Press to apply your changes
• To see the new action button on the view, open the view (if you already have it open, close it first)
• Test your button: press the new button, complete the details in the Form View and press
• Press on the view
• You will see a new row added

Create action to delete records

By the end of this section you will be able to:

• Create an action to delete a record
• In the configuration form for the Stream Wisteria Books Return Requests, go to the Action tab
  • Press to create a new action
  • Give the action the following configuration:
    • Name: Delete Return Request
    • Display Name: Delete Return
  • Go to the Item Updates tab, and set
    • Stream Item Action: Delete
  • Press
• To associate the new action with the view:
  • Open the configuration form for the view Wisteria Books Return Requests
    • Go to the Menu tab
    • Press - Actions
    • Select the new action from the drop down list and drag it into the list of actions associated with the view
    • Press to apply your changes
• To see the new action button on the view, open the view
• Test your button: select a record, press the new button, and press
• Press on the view
• You will see the row disappear