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
Data can be manually added or updated using a simple ERD and Screen setup.
Creating a table
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
Creating a Screen
- 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
- 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
- PhixFlow will ask how you would like the attributes to be displayed, choose
Insert excerpt |
---|
| HELP100:_grid |
---|
| HELP100:_grid |
---|
nopanel | true |
---|
|
- PhixFlow will ask if you would like to add actions, choose Yes
- On the Grid Actions wizard, drag Delete Selected Records onto the Delete button on your screen
- Close the Grid Actions and Available Attribute wizards
Setting up the Screen
- 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
- 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 |
---|
|
- 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 |
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:
Adding New Records via an Actionflow
- 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
- Map across your Output Attribute from the Calculate node onto the Save node
- Drag the Input Connection Point onto the Calculate node
- 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)
- 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:
Coming soon