Overview

When creating apps or testing functionality, it is often necessary to create test data. 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 do this in PhixFlow. The following methods will be covered:

• Creating an Editable Grid - This method creates a spreadsheet-style screen, that allows you to edit and update data. This method is best when using existing data
• Using External APIs - This method is best for creating large datasets using a third-party data generator (mockeroo.com)
• Using Input/Output Multipliers - This method is best for small datasets, with specific examples. The data can be easily rolled back and reset to its original state. For example, testing the results of a function

If, after making changes, you wish to restore your test data to a previous run or its original form, see Rolling Back Test Data.

Creating an Editable Grid 

Anchor
Grid Grid

Use a simple ERD and Screen setup to create an editable grid. 

Step 1: Create a table

Image Removed

Step 3: Set up the Screen

Expand
title How?
Right-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 

1. Image Removed

In the View Properties

and select Insert excerpt _view_show_config _view_show_config nopanel true Image Added On the Insert excerpt _property_tabs _property_tabs name action nopanel true , toggle on  Insert excerpt

HELP100:

_toggle_on

HELP100:Click

_toggle_on nopanel true  Auto Save

Note: Enabling Auto Save automatically saves any changes made to the data  Click  Insert excerpt

HELP100:

_finish

HELP100:

_finish nopanel true In the Layers panel, click on the area

FieldContainer to

containing the grid 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

ensure the Width and Height to 100%

Click

Click  Insert excerpt

HELP100:

_finish

HELP100:

_finish nopanel true Click on the Name attribute header on the grid to open the View Attribute Properties on the right Image Added On the  Insert excerpt

HELP100:

_property_tabs

HELP100:

_property_tabs name style nopanel true ,

within

in the Grid Settings section, untick Read Only In PhixFlow version 11 and older, this option is on the  Insert excerpt _property_tabs _property_tabs nopanel true Click  Insert excerpt _finish _finish nopanel true 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

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 Adding a Button 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: Image Modified

Adding

Step 4: Add New Records via an Actionflow

Image Removed

Image Removed

Image Removed

Check Point

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

Using External APIs 

Anchor
API API

Configure an

Create a Multi-Record Table using an API

This example uses the below three elements to create dynamic data. The table in this example will pull across data, as stipulated by the attributes, and this data will change each time the user clicks 

The HTTP Datasource is used to connect to the external source, the HTTP Collector then reads the data, and the Table stores the data in PhixFlow. 

Image Added

For more information on how these three elements work and for a detailed example, see Importing Data Through an API.

Using Input Multipliers

Using Input and Output Multipliers 

Anchor
Multiplier Multiplier

Use a simple table configuration on an 

Create a Multi-Record Table using an Array

This example uses an array to create static data. The table in this example will produce the exact records as stipulated in the Input Multiplier.