1. On an

   Insert excerpt
   HELP100:_erd HELP100:_erd nopanel true

   , either:

   1. Create a new table by dragging

      Insert excerpt
      HELP100:_tables HELP100:_tables nopanel true

       from the toolbar onto your ERD canvas

   2. Add an existing table by clicking 

      Insert excerpt
      HELP100:_tables HELP100:_tables nopanel true

       on the toolbar, then dragging a table from the

      Insert excerpt
      HELP100:_repository HELP100:_repository nopanel true

       onto your ERD canvas 
   3. Import an Excel a CSV file by dragging it from your PC onto your ERD canvas

2. If you create a new table, PhixFlow automatically adds the following attributes to the table:

   1. Insert excerpt
      HELP100:_key_primary HELP100:_key_primary nopanel true

      : UID

   2. Insert excerpt
      HELP100:_display_name HELP100:_display_name nopanel true

      : Name 

3. If you import a CSV file, add the above UID attribute to your table and set it as the 

   Insert excerpt
   HELP100:_key_primary HELP100:_key_primary nopanel

   Add as many new attributes

   true

    

4. Add the attributes you require to your table as you need by clicking 

   Insert excerpt
   HELP100:_addIcon HELP100:_addIcon nopanel true

   Add on the table, and give your attributes appropriate namesnames
   1. New attributes only require a valid Name and Type
   2. 

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

   Insert excerpt
   HELP100:_more_options_erd_IconOnly HELP100:_more_options_erd_IconOnly nopanel true

    on your table and choose 

   Insert excerpt
   HELP100:_screen_icon_only HELP100:_screen_icon_only nopanel true

    Create Screen
2. On the Create Screen wizard, enter the following:
   1. Name: give your screen an appropriate name
   2. Open Maximised: toggle 

      Insert excerpt
      HELP100:_toggle_off HELP100:_toggle_off nopanel true

   3. Description: give your screen an appropriate description to indicate its purpose
   4. Template: choose Edit Form
      1. 
   5. Click Create Screen
3. The Available Attributes selector will automatically appear , press the cross to close thisTo - select the attributes you wish to see on your screen, select

1. Click Right-click on the grid on your screen to highlight it in the Layers panel on the left within the BodyThe View Component Properties will show on the right, click the View hyperlink and select

   Insert excerpt
   HELP100:_view_show_config HELP100:_view_show_config nopanel true

   Image Modified
2. In the View Properties, toggle on 

   Insert excerpt
   HELP100:_toggle_on HELP100:_toggle_on nopanel true

    Auto Save
3. ClickClick 

   Insert excerpt
   HELP100:_finish HELP100:_finish nopanel true

4. In the Layers panel, click on the area FieldContainer to open its Properties on the right
5. Click on the 

   Insert excerpt
   HELP100:_property_tabs HELP100:_property_tabs name style nopanel true

    and within the Style Settings section, change the Width and Height to 100%
6. ClickClick 

   Insert excerpt
   HELP100:_finish HELP100:_finish nopanel true

7. Click on the Name header on the grid to open the View Attribute Properties on the right
8. On the 

   Insert excerpt
   HELP100:_property_tabs HELP100:_property_tabs nopanel true

   , within the Grid Settings section, untick Read Only
9. 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
10. Then clickclick 

    Insert excerpt
    HELP100:_finish HELP100:_finish nopanel true

11. With Auto Save set up, the screen no longer requires a Save button
12. 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
    HELP100:_permanentlyDelete HELP100:_permanentlyDelete nopanel true

Adding a Button

1. Open the Palette by clicking 

   Insert excerpt
   HELP100:_palette HELP100:_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:

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

   Insert excerpt
   HELP100:_actionflow_add HELP100:_actionflow_add nopanel true

2. Give your actionflow a name
3. To configure the input connection, within the Connections section on the left, click on Click to Connect
4. Choose the On Click Action Event, then select Connect Input
5. Drag the Calculate node from the toolbar onto the canvas
6. Give it a name
7. The Properties for the Calculate node will show on the right
8. In the Output Attributes section, add a new attribute by selecting 

   Insert excerpt
   HELP100:_addIcon HELP100:_addIcon nopanel true

9. Give it a name and set the expression to "new"
10. Drag the Save node from the toolbar onto the canvas, give it a name, set the Type to Auto Insert/Update, and from the Table dropdown list, choose your table
11. Connect the out pipe from the Calculate node to the Save node
    1. 
12. Map across your Output Attribute from the Calculate node onto the Save node
    1. 
13. Drag the Input Connection Point onto the Calculate node 
    1. 
14. Close the Actionflow and open the screen you created earlier

15. Insert excerpt
    HELP100:_lock HELP100:_lock nopanel true

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

1. On an 

   Insert excerpt
   HELP100:_analysisModel HELP100:_analysisModel nopanel true

   , create a blank Calculate 

   Insert excerpt
   HELP100:_tables HELP100:_tables nopanel true

2. Within the Table's 

   Insert excerpt
   HELP100:_property_tabs HELP100:_property_tabs nopanel true

   , add 

   Insert excerpt
   HELP100:_attributes HELP100:_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. 
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
   HELP100:_finish HELP100:_finish nopanel true

    the Properties, then 

   Insert excerpt
   HELP100:_run_analysis HELP100:_run_analysis nopanel true

    on the table
   1. Hover over the table and select 

      Insert excerpt
      HELP100:_view_show HELP100:_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. 

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
   HELP100:_analysisModel HELP100:_analysisModel nopanel true

   , create a new 

   Insert excerpt
   HELP100:_http_datasource HELP100:_http_datasource nopanel true

3. Set up your 

   Insert excerpt
   HELP100:_http_datasource HELP100:_http_datasource nopanel true

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

   Insert excerpt
   HELP100:_http_datasource HELP100:_http_datasource nopanel true

    and select 

   Insert excerpt
   HELP100:_http_collector_add_new HELP100:_http_collector_add_new nopanel true

    on the hover menu
5. Set up the 

   Insert excerpt
   HELP100:_http_collector HELP100:_http_collector nopanel true

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

   Insert excerpt
   HELP100:_http_collector HELP100:_http_collector nopanel true

    and select 

   Insert excerpt
   HELP100:_table_new HELP100:_table_new nopanel true

7. Set up the 

   Insert excerpt
   HELP100:_tables HELP100:_tables nopanel true

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

   Insert excerpt
   HELP100:_attributes HELP100:_attributes nopanel true

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

8. Insert excerpt
   HELP100:_run_analysis HELP100:_run_analysis nopanel true

    on your 

   Insert excerpt
   HELP100:_tables HELP100:_tables nopanel true

   , then 

   Insert excerpt
   HELP100:_view_show HELP100:_view_show nopanel true

    to see your data
   1.