Overview
There are a number of ways to quickly create test data in PhixFlow, which can be manually edited and added to.
- Creating an Editable Grid - This method is best for using existing data and making amendments.
- Using Input/Output Multipliers - This method is best for small datasets, with specific examples. For example, testing the results of a fucntion.
- Using External APIs - This method is best for large datasets and existing data.
1. Creating an Editable Grid
Data can be manually added or updated using a simple ERD and Screen setup.
Step 1: Creating a table
Expand |
---|
|
On an Insert excerpt |
---|
| HELP100:_erd |
---|
| HELP100:_erd |
---|
nopanel | true |
---|
| , either:Create a new table by dragging Insert excerpt |
---|
| HELP100:_tables |
---|
| HELP100:_tables |
---|
nopanel | true |
---|
| from the toolbar onto your ERD canvas- 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 - Import an Excel CSV file by dragging it from your PC onto your ERD canvas
If you create a new table, PhixFlow automatically adds the following attributes to the table: Insert excerpt |
---|
| HELP100:_key_primary |
---|
| HELP100:_key_primary |
---|
nopanel | true |
---|
| : UID Insert excerpt |
---|
| HELP100:_display_name |
---|
| HELP100:_display_name |
---|
nopanel | true |
---|
| : Name
Add as many new attributes 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 names- Image Modified
|
Step 2: Creating a Screen
Expand |
---|
|
- 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 - On the Create Screen wizard, enter the following:
- Name: give your screen an appropriate name
- Open Maximised: toggle
Insert excerpt |
---|
| HELP100:_toggle_off |
---|
| HELP100:_toggle_off |
---|
nopanel | true |
---|
|
- Description: give your screen an appropriate description to indicate its purpose
- Template: choose Edit Form
- Image Modified
- Click Create Screen
- The Available Attributes selector will automatically appear, press the cross to close this
- To select the attributes you wish to see on your screen, select
Insert excerpt |
---|
| HELP100:_attributes |
---|
| HELP100:_attributes |
---|
nopanel | true |
---|
| in the toolbar - Click the tickbox next to each attribute, or click the top tickbox to select all the attributes, and drag them onto your screen
- Image Modified
- PhixFlow will ask how you would like the attributes to be displayed, choose
Insert excerpt |
---|
| HELP100:_grid |
---|
| HELP100:_grid |
---|
nopanel | true |
---|
|
- Image Modified
- PhixFlow will ask if you would like to add actions, choose Yes
- Image Modified
- On the Grid Actions wizard, drag Delete Selected Records onto the Delete button on your screen
- Image Modified
- Close the Grid Actions and Available Attribute wizards
|
Step 3: Setting up the Screen
Expand |
---|
|
- Click on the grid on your screen to highlight it in the Layers panel on the left within the Body
- The View Component Properties will show on the right, click the View hyperlink
- Image Modified
- In the View Properties, toggle on
Insert excerpt |
---|
| HELP100:_toggle_on |
---|
| HELP100:_toggle_on |
---|
nopanel | true |
---|
| Auto Save - Click
Insert excerpt |
---|
| HELP100:_finish |
---|
| HELP100:_finish |
---|
nopanel | true |
---|
|
- In the Layers panel, click on the area FieldContainer to open its Properties on the right
- 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% - Click
Insert excerpt |
---|
| HELP100:_finish |
---|
| HELP100:_finish |
---|
nopanel | true |
---|
|
- Click on the Name header on the grid to open the View Attribute Properties on the right
- On the
Insert excerpt |
---|
| HELP100:_property_tabs |
---|
| HELP100:_property_tabs |
---|
nopanel | true |
---|
| , within the Grid Settings section, untick Read Only - Repeat this step for all of your attribute headers, except UID
- Note: Unticking Read Only will allow you to manually enter information into these columns on your grid
- Then click
Insert excerpt |
---|
| HELP100:_finish |
---|
| HELP100:_finish |
---|
nopanel | true |
---|
|
- With Auto Save set up, the screen no longer requires a Save button
- 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 |
---|
|
- Open the Palette by clicking
Insert excerpt |
---|
| HELP100:_palette |
---|
| HELP100:_palette |
---|
nopanel | true |
---|
| on the toolbar - 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
- Give your button a name
- 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:
Step 4: Adding New Records via an Actionflow
Expand |
---|
|
- Right-click on your new Add button and choose
Insert excerpt |
---|
| HELP100:_actionflow_add |
---|
| HELP100:_actionflow_add |
---|
nopanel | true |
---|
|
- Give your actionflow a name
- To configure the input connection, within the Connections section on the left, click on Click to Connect
- Choose the On Click Action Event, then select Connect Input
- Drag the Calculate node from the toolbar onto the canvas
- Give it a name
- The Properties for the Calculate node will show on the right
- In the Output Attributes section, add a new attribute by selecting
Insert excerpt |
---|
| HELP100:_addIcon |
---|
| HELP100:_addIcon |
---|
nopanel | true |
---|
|
- Give it a name and set the expression to
"new" - 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
- Connect the out pipe from the Calculate node to the Save node
- Image Modified
- Map across your Output Attribute from the Calculate node onto the Save node
- Image Modified
- Drag the Input Connection Point onto the Calculate node
- Image Modified
- Close the Actionflow and open the screen you created earlier
Insert excerpt |
---|
| HELP100:_lock |
---|
| HELP100:_lock |
---|
nopanel | true |
---|
| the screen, then select the Add button- The Actionflow will fire and a new record will be created on the grid, with a unique ID (UID)
- Image Modified
- Double click on the fields to manually enter information
- Repeat these steps of adding a new record and updating the information as many times as required
- Each record will save automatically
|
Check Point
At this point, your screen should look similar to this:
Using Input MultipliersComing soon
3. Using External APIs
Coming soon