This topic is locked
[SOLVED]

 Form label from table

3/23/2020 7:20:33 AM
PHPRunner General questions
rdf author

Trying to create a form like the one below. Any idea PHPRunner forum community? Thank you.
I. Category name Good Not Good Comment

a. Subcategory name [] []

b. Subcategory name [] []


c. Subcategory name [] []

d. Subcategory name [] []


e. Subcategory name [] [] ___

  • (add new subcategory)
    II. Category name

    a. Subcategory name [] []

    b. Subcategory name [] []

  • (add new subcategory)
    Category name = static and taken from table

    Subcategory name = static and taken from table

    Good / Not Good = check box

    Comment = text area
  • = user can add new subcategory name

M
Mark Kramer 3/23/2020



Trying to create a form like the one below. Any idea PHPRunner forum community? Thank you.
I. Category name Good Not Good Comment

a. Subcategory name [] []

b. Subcategory name [] []


c. Subcategory name [] []

d. Subcategory name [] []


e. Subcategory name [] [] ___

  • (add new subcategory)
    II. Category name

    a. Subcategory name [] []

    b. Subcategory name [] []

  • (add new subcategory)
    Category name = static and taken from table

    Subcategory name = static and taken from table

    Good / Not Good = check box

    Comment = text area
  • = user can add new subcategory name


The "Lookup wizard" looks like the area you need to look at. Prepare your "values" (Where you pull Catagories from) table first. Then on your designer page create the look you want.

Sergey Kornilov admin 3/23/2020

I'm not 100% sure I understand what you looking for but this article explains how you can store field labels in the database:

https://xlinesoft.com/blog/2015/12/04/storing-field-labels-and-visibility-rules-in-the-database/

rdf author 3/23/2020

@Mark and @Admin,
To make it clear, I attached the form that I want to turn into a form in PHPRunner.

rdf author 5/5/2020



Your image makes sense, looks like a typical invoice to me. What exactly causes the trouble?


Hi,
Sorry late reply.
I want to use table data as labels on the form.
For example, table_issue has the follow data entries:

  • Voltage output
  • UPS load


And on my application, I have a form that reads the tableissue and use the data entries as labels:
Status Comment

Voltage output __ __


UPS load __ ___
Any suggestion? Thank you.

Sergey Kornilov admin 5/7/2020

I feel we are running in circles. How to store labels in the database:

https://xlinesoft.com/blog/2015/12/04/storing-field-labels-and-visibility-rules-in-the-database/

rdf author 5/12/2020



I feel we are running in circles. How to store labels in the database:

https://xlinesoft.com/blog/2015/12/04/storing-field-labels-and-visibility-rules-in-the-database/


Ok thank you. I will give this a try.