Ok, then if i understood everything right…
- DATABASE-A connected via a DATASET with your DYNAMIC-PAGE.
- In DATABASE-A you have stored your “Job-ID”.
That means, every time when you choose a job from your Drop-Down-List, you will be redirected to your “Dynamic-Page”, where you also show the “Job-ID”.
So in this case, you already have the ID…
$w.onReady( () => {
$w("#YOUR_DYNAMIC_Dataset").onReady( () => {
let itemObj = $w("#YOUR_DYNAMIC_Dataset").getCurrentItem();
console.log(itemObj)
console.log(itemObj.items)
console.log(itemObj.items.title)
} );
} );
Modify the code by your needs. DATASET = your dynamic-dataset.
This code will give/show you all infos about the current selected item.
Take a look into CONSOLE in PREVIEWMODE (very bottom of the screen),
or press F-12 on keyboard when you are using GOOGLE-CHROME and go to —> CONSOLE).
First step done.
Further you also know the current selected index in your dataset, if you are using a Drop-Down.
Index of DropDown = Index of selected item in DATABSE
Now you have an “Apply”-Button on your dynamic page. When pressing the button you want to be redirected to a special page (NON-DYNAMIC-PAGE), where you have the “Job-Form”…
…and where you wants AUTOMATICALY load the ID into FORM…
$w.onReady( () => {
myForm.value = the ID i already have got before
})
Now you should have the ID in your form.
And at least, you have a “Submit”-Button, which lets the ID be saved in DATABASE-B…(for example like this)
$w.onReady( () => {
$w("#YOUR_Dataset").onReady( () => {
$w("#YOUR_Dataset").setFieldValue("column-ID", "ID.value of the ID-INPUT-FIELD here");
} );
} );
Something like this would be the theoretical way to a solution.