clear form fields of datamaster names

Sonia Durán ●

Dear Oscar,

Can you elaborate more on what you mean? An example would help.

Best,

oscar ward ●

I just showed you what i meant attached to the question in my post was a screen grab of 2 fields as the page loads as a data entry form.

because i use the same form for edits, set value is being used to show the appropriate data in the fields.

Im asking is there a way to not have the data field the set value function references (as shown in the attached fields value.png That's what the actual fields look like when the form is displayed) not show up in the field if its opened and not having any info passed to it. if the form is linked to from a datalist all the fields fill in correctly....if the same form is just opened to use as a data entry form then it shows the field name of the set value function. i just dont want to create 2 forms so id like to not have that data ref shown when no value is assigned

Files:

eggroll ●

< comment deleted >

eggroll ●

Hi Oscar,

If I'm understanding your goal correctly, you could achieve it by not having your form connected to your data master. That is, your form would be individual inputs grouped together which either get populated by the user entering all of the values when creating a new manufacturer or by copying the values from an existing manufacturer's data record when editing that manufacturer (triggered by clicking on the hotspot associated with that record). Then, once the values in the form are correct, either a new record is created or an existing record is modified in the data master as appropriate utilizing the "Data Master Action" event attached to a create button or an update button, respectively.

I've created a prototype to demonstrate the implementation I am suggesting. Download the prototype and simply change the file extension from ".rar" to ".vp" and you will be able to open it in JIM. It is not a compressed file, so you do not need to unarchive it. Simulate the prototype and you will be able to verify that it enables you to both create new manufacturers and edit existing manufactures without the input boxes ever being populated with the names of the data master fields as you describe above. To create a new manufacturer, simply populate the input fields of the form with the appropriate values and click the "Create" button. To edit a manufacturer, click on that manufacturer in the data grid. When you do, the form will populate with the values of that manufacturer. Then, make any desired changes in the form and press the "Update" button to post the changes to the data master. In both instances, the data grid on the screen will update automatically. (Note: When you click on a record in the data grid to edit it, the "Create" button is hidden and the "Update" button is shown.)

I've also included some screenshots below. (In the sample data shown in these screenshots, I've intentionally left out values for the manufacturer "Massive Dynamic" for recording editing demonstration purposes.)

I hope this helps. If this is not exactly what you are looking to do, I'm happy to help you explore it further with additional information. Cheers.

--------------------------------------------------------------------------------

1. Initial Form and Data Grid

e57775c6ea7846f3e02e821fe9683792

--------------------------------------------------------------------------------

2. Form Populated with Values for New Manufacturer

2c263cd2787be5de03bec7b464c9dd78

--------------------------------------------------------------------------------

3. Form and Data Grid After Submission of New Manufacturer Values

0cd4bc6e577e766294e174b66827e66c

--------------------------------------------------------------------------------

4. Form Populated After Clicking Record in Data Grid

95ac38fb01e16053872280d11d1bab20

--------------------------------------------------------------------------------

5. Form After Adding Missing Value for Existing Record

ab0a3569df3d704ce1f6129f545a6639

--------------------------------------------------------------------------------

6. Form and Data Grid After Submission of Updated Manufacturer Value

b4735e977f485a270004ff7971909b2d

Hi Oscar,

If I'm understanding your goal correctly, you could achieve it by not having your form connected to your data master. That is, your form would be individual inputs grouped together which either get populated by the user entering all of the values when creating a new manufacturer or by copying the values from an existing manufacturer's data record when editing that manufacturer (triggered by clicking on the hotspot associated with that record). Then, once the values in the form are correct, either a new record is created or an existing record is modified in the data master as appropriate utilizing the "Data Master Action" event attached to a create button or an update button, respectively.

I've created a prototype to demonstrate the implementation I am suggesting. Download the prototype and simply change the file extension from ".rar" to ".vp" and you will be able to open it in JIM. It is not a compressed file, so you do not need to unarchive it. Simulate the prototype and you will be able to verify that it enables you to both create new manufacturers and edit existing manufactures without the input boxes ever being populated with the names of the data master fields as you describe above. To create a new manufacturer, simply populate the input fields of the form with the appropriate values and click the "Create" button. To edit a manufacturer, click on that manufacturer in the data grid. When you do, the form will populate with the values of that manufacturer. Then, make any desired changes in the form and press the "Update" button to post the changes to the data master. In both instances, the data grid on the screen will update automatically. (Note: When you click on a record in the data grid to edit it, the "Create" button is hidden and the "Update" button is shown.)

I've also included some screenshots below. (In the sample data shown in these screenshots, I've intentionally left out values for the manufacturer "Massive Dynamic" for recording editing demonstration purposes.)

I hope this helps. If this is not exactly what you are looking to do, I'm happy to help you explore it further with additional information. Cheers.

--------------------------------------------------------------------------------

1. Initial Form and Data Grid

e57775c6ea7846f3e02e821fe9683792

--------------------------------------------------------------------------------

2. Form Populated with Values for New Manufacturer

2c263cd2787be5de03bec7b464c9dd78

--------------------------------------------------------------------------------

3. Form and Data Grid After Submission of New Manufacturer Values

0cd4bc6e577e766294e174b66827e66c

--------------------------------------------------------------------------------

4. Form Populated After Clicking Record in Data Grid

95ac38fb01e16053872280d11d1bab20

--------------------------------------------------------------------------------

5. Form After Adding Missing Value for Existing Record

ab0a3569df3d704ce1f6129f545a6639

--------------------------------------------------------------------------------

6. Form and Data Grid After Submission of Updated Manufacturer Value

b4735e977f485a270004ff7971909b2d

Files:

eggroll ●

Not sure why the images are no longer showing above, so I'm posting them again.

--------------------------------------------------------------------------------

1. Initial Form and Data Grid

d142dcd118f00bd10eea0ef8ae157f38

--------------------------------------------------------------------------------

2. Form Populated with Values for New Manufacturer

40151edd0efb84d4e5d49ab331d8f0ec

--------------------------------------------------------------------------------

3. Form and Data Grid After Submission of New Manufacturer Values

9840c16318732117fb5d67d8540da4dd

--------------------------------------------------------------------------------

4. Form Populated After Clicking Record in Data Grid

7a0f87bcca85473083f323835a0d8cbc

--------------------------------------------------------------------------------

5. Form After Adding Missing Value for Existing Record

62f5eab93f19d9164a7e5ce32392370a

--------------------------------------------------------------------------------

6. Form and Data Grid After Submission of Updated Manufacturer Value

dce629e24450c4de9179cefc7ffef353