1. To create a screen using your ERD data, click 

   Insert excerpt

1. Right-click on the grid on your screen and select

   Insert excerpt
   _view_show_config _view_show_config nopanel true

   1. Image Added
2. On the

   Insert excerpt
   _property_tabs _property_tabs name action nopanel true

   , toggle on 

   Insert excerpt
   _toggle_on _toggle_on nopanel true

    Auto Save
   1. Note: Enabling Auto Save automatically saves any changes made to the data 
   2. Click 

      Insert excerpt
      _finish _finish nopanel true

3. In the Layers panel, click on the area containing the grid to open its Properties on the right
4. Click on the 

   Insert excerpt
   _property_tabs _property_tabs name style nopanel true

    and within the Style Settings section, ensure the Width and Height to 100% 
   1. Click 

      Insert excerpt
      _finish _finish nopanel true

5. Click on the Name attribute header on the grid to open the View Attribute Properties on the right
   1. Image Added
6. On the 

   Insert excerpt
   _property_tabs _property_tabs name style nopanel true

   , in the Grid Settings section, untick Read Only
   1. In PhixFlow version 11 and older, this option is on the 

      Insert excerpt
      _property_tabs _property_tabs nopanel true

   2. Click 

      Insert excerpt
      _finish _finish nopanel true

7. Repeat this step for all of your attribute headers, except UID
   1. Note: Unticking Read Only will allow you to manually enter information into these columns on your grid
8. Then click 

   Insert excerpt
   _finish _finish nopanel true

9. With Auto Save set up, the screen no longer requires a Save button
10. To delete the Save button, click on it on the screen to highlight it in the Layers, right click it in Layers and select 

    Insert excerpt
    _permanentlyDelete _permanentlyDelete nopanel true

Adding a Button

1. Open the Palette by clicking 

   Insert excerpt
   _palette _palette nopanel true

    on the toolbar
2. Expand the Buttons - Primary section and drag the Add button onto your screen - the screen will highlight the areas where the button should be dropped
3. Give your button a name
   1. Optional: In the Layers panel, expand the area Window CRUD Bar. Then, while holding shift, drag and drop your Add button onto either the Left or Right area within the Window CRUD Bar

Check Point

At this point, your screen should look similar to this:

Image Added

1. Right-click on your new Add button and choose 

   Insert excerpt
   _actionflow_add _actionflow_add nopanel true

   1. Give your Actionflow a name
2. To configure the input connection, within the Connections section on the left, click on Click to Connect
3. Choose the On Click Action Event, then select Connect Input
4. Drag a 

   Insert excerpt
   _action_calculate _action_calculate nopanel true

    action from the toolbar onto the canvas
   1. Give it a suitable name
5. The

   Insert excerpt
   _property_settings _property_settings nopanel true

    for the Calculate action will show on the right
   1. If these are not open, click the Calculate action to reopen them
6. In the Output Attributes section, add a new attribute by selecting 

   Insert excerpt
   _addIcon _addIcon nopanel true

   1. Give it a name and set the expression to "new"
7. Drag a

   Insert excerpt
   _action_save _action_save nopanel true

    action from the toolbar onto the canvas
   1. Give it a name
   2. Set the Type to Auto Insert/Update
   3. On the Table dropdown list, choose the table you made earlier on your ERD
8. Connect the out pipe from the Calculate node to the Save node
   1. Image Added
9. Map across your Output Attribute from the Calculate node onto the Save node
   1. Image Added
10. Drag the Input Connection Point onto the Calculate node 
    1. Image Added
11. Close the Actionflow and open the screen you created earlier

12. Insert excerpt
    _lock _lock nopanel true

     the screen, then select the Add button
13. The Actionflow will fire and a new record will be created on the grid, with a unique ID (UID)
    1. Image Added
14. Double click on the fields to manually enter information 
15. Repeat these steps of adding a new record and updating the information as many times as required
16. Each record will save automatically

1. Prepare your API data and ensure it is in JSON format. For this example, we have created a data schema and mock API using https://www.mockaroo.com/mock_apis
2. On an 

   Insert excerpt
   _analysisModel _analysisModel nopanel true

   , create a new 

   Insert excerpt
   _http_datasource _http_datasource nopanel true

3. Set up your 

   Insert excerpt
   _http_datasource _http_datasource nopanel true

    Properties to look similar to the below settings, and ensure your URL matches your API source
   1. Image Added
4. Hover over your

   Insert excerpt
   _http_datasource _http_datasource nopanel true

    and select 

   Insert excerpt
   _http_collector_add_new _http_collector_add_new nopanel true

    on the hover menu
5. Set up the 

   Insert excerpt
   _http_collector _http_collector nopanel true

    Properties to look similar to the below settings, and ensure your URL passes in your API key
   1. Image Added
6. Hover over your 

   Insert excerpt
   _http_collector _http_collector nopanel true

    and select 

   Insert excerpt
   _table_new _table_new nopanel true

7. Set up the 

   Insert excerpt
   _tables _tables nopanel true

    Properties to look similar to the below settings, and ensure the 

   Insert excerpt
   _attributes _attributes nopanel true

    you wish to display on your view are set up
   1. Image Added

8. Insert excerpt
   _run_analysis _run_analysis nopanel true

    on your 

   Insert excerpt
   _tables _tables nopanel true

   , then 

   Insert excerpt
   _view_show _view_show nopanel true

    to see your data
   1. Image Added

1. On an 

   Insert excerpt
   _analysisModel _analysisModel nopanel true

   , create a blank Calculate 

   Insert excerpt
   _tables _tables nopanel true

2. Within the Table's 

   Insert excerpt
   _property_tabs _property_tabs nopanel true

   , add 

   Insert excerpt
   _attributes _attributes nopanel true

    to the table, which will act as column headers
   1. Add the Expression _inputMultiplier, followed by .1, .2, .3, etc. to the relevant attributes
   2. Image Added
3. In the Analysis Options section, in the Input Multiplier box, add an array, like the example here

   1. 
      

      Code Block
      title Input Multiplier
      [ [1,'CHAIR',100], [2,'TABLE',430], [3,'MONITOR',800] ]

      
      

4. Insert excerpt
   _finish _finish nopanel true

    the Properties, then 

   Insert excerpt
   _run_analysis _run_analysis nopanel true

    on the table
   1. Hover over the table and select 

      Insert excerpt
      _view_show _view_show nopanel true

   2. For this example, the data shows three records, with each record assigned the UID, Item name and Quantity as specified by the Input Multiplier, along with the Last Updated date 
   3. Image Added