How to use URL Request Parameters for Popup Form

Introduction

The URL Request Parameters for the Popup Form is a feature for Form Grid. It will pass the selected field ID as URL request parameters to the pop-up form, which is the configured form grid target form that will pop up upon adding or editing a row in the form grid. In this article, we will demonstrate 1 example of using this feature.

How does it work?

1. Create two forms: Store Form and Item Form based on the table and screenshot below.
   1.  Store Form:
      

      Element	Label	ID
      Text Field	Item ID	item_id
      Text Field	Store Name	store_name

      
   2. Item Form:
      

      Element	Label	ID
      Text Field	Item ID	item_id
      Text Field	Item Name	item_name

      
2. Next, create another form called Child Form and add the following fields: a Hidden Field, a Text Field, and a Select Box.
3. Configure the Hidden Field ID as 'selectBox'. This field holds the field ID passed through the URL request parameters.
4. Configure the Select Box to Load Data From - Database SQL Query, enable the Use AJAX for Cascade Options?, and enter the SQL SELECT Query as below.
   

   SELECT c_store_name, c_store_name
   FROM app_fd_w_store
   WHERE c_item_id = (?)

   
   
5. In Advanced Options, under the Dependency section, enter 'selectBox' for Field Id to Control Available Options Based on Grouping.
   
6. Create the final form called Parent Form and add the following fields: a Select Box and Form Grid. Configure the Select Box ID to 'selectBox' and Load Data Form as 'Form Data'. Next, configure the Form Data, Form as 'Item Form', ID Column as 'item_id', and Label Column as 'item_name'.
   
7. Configure the Form Grid to link with the Child Form and specify the Columns.
   
8. Under Advanced, configure URL Request Parameters for Popup Form, 'selectBox' as Parameter and Field Id.
   
9. Save and generate the CRUD for all forms. During runtime, populate the data for the Item and Store forms.

Expected Outcome

Properties

Fields to configure:

• Parameter: Map values as the URL parameters.
• Field Id: Field ID of the form element in the current form.
• Default Value: Default Value when there's no existing value found/selected.

  A hash variable is accepted here. For example, you may key the following

  #currentUser.firstName# #currentUser.lastName#

  to pre-populate the field with the currently logged-in user's name.

Video Tutorial

Download Sample App