Page 1 of 1

Populate external table from LAUNCH-form

Posted: Thu Nov 16, 2023 1:51 pm
by kknm
There is a LAUNCH-form consisting of 5 sub-forms, on the basis of which a row for an external table is formed. For this, another sub-form (GRID type) is used.
Having collected data from 3 sub-forms, you need to write them into an external database table. I use nuRunPHPHiddenWhithParams, but after struggling with base64encode - base64decode I thought that perhaps there is a way to write data to an external table from js. But the problem is that all the source tables and the destination do not have a common foreign key.
obzor_1.jpg
I tried changing LAUNCH-form to BROWSE-EDIT...The save button appears when changing the GRID-form, but nothing is saved.

Re: Populate external table from LAUNCH-form

Posted: Tue Nov 28, 2023 10:24 am
by kev1n
kknm wrote: Thu Nov 16, 2023 1:51 pm I tried changing LAUNCH-form to BROWSE-EDIT...The save button appears when changing the GRID-form, but nothing is saved.
Try PHP BS and use nuSubformObject() to retrieve the subform data.

Re: Populate external table from LAUNCH-form

Posted: Tue Nov 28, 2023 2:45 pm
by kknm
I got the correct subform data except nuID which = -1. Shouldn't it be generated automatically? Maybe I need to generate it myself?