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 do this in PhixFlow, which can be manually edited and added to.  On this page, the . 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

Using External APIs - This method is best for large datasets and existing data.

Use a simple ERD and Screen setup. 

Step 1: Create a table

Creating an Editable Grid 

Anchor
Grid Grid

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

Step 1: Create a table

Step 2: Create a Screen 

1. Image RemovedImage Added

On the Grid Actions wizard, drag Delete Selected Records onto the Delete button on your screen  
Image Removed- this is the only button you need 

1. Image Added

Step 3: Set up the Screen

Check Point

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

Image Removed

Create a Single Record Table

This example uses one number to prevent the need for input pipes. The table in this example will produce one record.

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

   Insert excerpt

1. _finish

1. _finish nopanel true

Adding a Button

1. 1. Click 

      Insert excerpt

   HELP100:

   1. _

   palette

   1. finish

   HELP100:

   1. _

   palette

   1. finish 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 Removed

Step 4: Add New Records via an Actionflow

1. The Expression for one of your attributes must be _inputMultiplier
2. Image Removed

1. Note: Unticking Read Only will allow you to manually enter information into these columns on your grid

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

Step 4: Add New Records via an Actionflow

Check Point

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

Image Added

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 

Create a Multi-Record Table using the Syntax 1..n 

This example uses the syntax 1..n to run a table multiples times. The numerical difference between the two numbers will determine the number of records returned. For example, using the Input Multiplier 1..10 will return ten records.

1. The Expression for one of your attributes must be _inputMultiplier

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.

1. The Expression for all of your attributes must be _inputMultiplier, followed by .1, .2, .3, etc.
2. Image Removed

[
    [1,'CHAIR',100],
    [2,'TABLE',430],
    [3,'MONITOR',800]
]

Create a Multi-Record Table using a Lookup

This example uses a pipe as an input multiplier to pull in data from a dataset. For each record in the dataset, the Input Multiplier will run once.

1. The Expression for all of your attributes must be _inputMultiplier, followed by .1, .2, .3, etc.
2. Image Removed

[
    [1,'CHAIR',100],
    [2,'TABLE',430],
    [3,'MONITOR',800]
]

Create a Multi-Record Table using a Lookup and Filter

This example uses a pipe as an input multiplier to pull in data from a dataset. For each record in the dataset, the Input Multiplier will run once.

1. The Expression for all of your attributes must be _inputMultiplier, followed by .1, .2, .3, etc.
2. Image Removed

[
    [1,'CHAIR',100],
    [2,'TABLE',430],
    [3,'MONITOR',800]
]

Create a Multi-Record Table using 2 Input Multipliers

This example uses a pipe as an input multiplier to pull in data from a dataset. For each record in the dataset, the Input Multiplier will run once.

1. The Expression for all of your attributes must be _inputMultiplier, followed by .1, .2, .3, etc.
2. Image Removed

[
    [1,'CHAIR',100],
    [2,'TABLE',430],
    [3,'MONITOR',800]
]

Create a Multi-Record Table using an Input and Output Multiplier

This example uses a pipe as an input multiplier to pull in data from a dataset. For each record in the dataset, the Input Multiplier will run once.

1. The Expression for all of your attributes must be _inputMultiplier, followed by .1, .2, .3, etc.
2. Image Removed

[
    [1,'CHAIR',100],
    [2,'TABLE',430],
    [3,'MONITOR',800]
]

Create a Multi-Record Table using a File Exporter

This example uses a pipe as an input multiplier to pull in data from a dataset. For each record in the dataset, the Input Multiplier will run once.

.

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 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.