Highlighted
Super Contributor.. Super Contributor..
Super Contributor..
913 views

how to create new line entry in Form design;.

Jump to solution

Hi Expert,

Do like to do check is it possible create a data entry form, which create a new empty entry after the user enter one.
Do advice how to go about doing it?

e.g. like in the format control -> java script or validation section, when a new entry is enter and save a new empty text area and text fields are created.

Regards

Soong 

Regards
Soong
0 Likes
1 Solution

Accepted Solutions
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: how to create new line entry in Form design;.

Jump to solution

@soongwc,

I created one table based on your requirement, it looks like below, once you add a new line, system generate another line:2017-01-19_17-21-06.jpg

To do it, you need to create a dbdict, two formats like below:

dbdict: testtable

2017-01-19_17-23-38.jpg

format: testtable

2017-01-19_17-24-54.jpg

format: testtable.sub.g

2017-01-19_17-24-25.jpg

The code is attached as testtable.jpg, you need to rename as testtable.unl and load into the system.

Let me know if it helps,

Ling-Yan

View solution in original post

9 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: how to create new line entry in Form design;.

Jump to solution

You mean to change a form based on user actions ?

0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: how to create new line entry in Form design;.

Jump to solution

Hi, 

Not really changing the form. It is to add new fields.

e,g I had three field: start time, end time, comment
when the user entry value into these fields and save. A new set of empty field will be shown below.

example as shown below -> when we add a entry/line and save a new empty line is shown below

 

temp.jpg

Regards
Soong
0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: how to create new line entry in Form design;.

Jump to solution

You could add the hidden fields to the form and then set the visible condition based off whether the other fields were populated

0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: how to create new line entry in Form design;.

Jump to solution

Hi TomPowe,

Thanks for the suggestion, but it not what my customer requirement is, as we don't know the number of entry that the user wil enter, by making the entry invisiable will not help in my customer case.  Will required to be able to create the field when the user click save.

 

REgards

Soong 

Regards
Soong
0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: how to create new line entry in Form design;.

Jump to solution

If you want to mirror something like Format Control, then you'll need to setup the data and forms like it.

Look up formatctrl in the Database Dictionary and lookat how the queries and calculations sections are setup.  They are in array/structures.  You will need to do something like that. 

Then take a look at the formats of formatctrl.maint.valid.b.g and formatctrl.maint.valid.sub.b

 

0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: how to create new line entry in Form design;.

Jump to solution

Hi TomPowe,

Thanks , I had look at the suggested form, subform and data structure, but don't really understand how the creatation of new entry was being done, can please advice on how is was being done?

Regards

Soong 

Regards
Soong
0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: how to create new line entry in Form design;.

Jump to solution

I'm sure it has something to do with being a structure array.  I've not personally had to do anything like this before. 

Have you opened a ticket with HP Support to see if they can explain how it is working?

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: how to create new line entry in Form design;.

Jump to solution

@soongwc,

I created one table based on your requirement, it looks like below, once you add a new line, system generate another line:2017-01-19_17-21-06.jpg

To do it, you need to create a dbdict, two formats like below:

dbdict: testtable

2017-01-19_17-23-38.jpg

format: testtable

2017-01-19_17-24-54.jpg

format: testtable.sub.g

2017-01-19_17-24-25.jpg

The code is attached as testtable.jpg, you need to rename as testtable.unl and load into the system.

Let me know if it helps,

Ling-Yan

View solution in original post

Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: how to create new line entry in Form design;.

Jump to solution

Hi lingyanmeng,

It works, THANKS you so much. 🙂 

 

Regards

Soong

Regards
Soong
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.