Single database for different pages Applications

Hi , I am building a job portal through wix. I have created a database collection where all applications will be collected. I want to posting multiple jobs on different pages and single page application form.
whenever a job seeker applies for a job he is redirected to application form. when he submits his application and resume it shows in database collection.
The problem is how i get to know in database for which job , job seeker applied?
Any other workaround there?

Hi,
I cant thoroughly understand what you are trying to achieve. Can you please supply more data? maybe some images of what you already built?

thanks!

I prepared a database of job requirements and showed them in a dynamic page which shows jobs accordingly to my already prepared database. Each job has a apply1 button which redirects to a user input form which is on static page and has fields ( name, email ID and resume upload).If some is interested in a job and he clicks on apply1 . it redirects to that user input form. now he complete that form in which he complete his name, email id and upload resume) when he click submit button on user input form page it doesnt show anything in database about the job for which he applied. how can i know for what job he has applied for? i am only getting the information which i have asked like name, email id and resume.

You can use url params.

When you redirect to the static page, add a url parameter with job id.
(for example: “http://www.myexample.com/myform?job=abc123”)

In the static form’s client side code you can use this to get the parameter

const url = new URL(window.location.href);
const job_id = url.searchParams.get("job");
console.log(job_id);

Sorry i am a noob in coding. so not able to understand. Can you please elaborate step by step?

when you redirect to the static page, you need to link to the static page by URL instead of by page.
in the URL you can add parameters. if your link is " http://www.myexample.com/myform " you add “?job=JOB_ID” in the end.

then, in the static page use the code I wrote above to get the job id.
Hope that helps.

This is my Dynamic page connected to Jobs Database.


then i changed the url code and selected open in new link as you said


Now i put the code in console for apply page as you said. these all user input connected to other database(candidate)


when i put my name(testing) and random code(KW123)


in this user input form . database showing name and code but not showing any link or connections that from where user submitted the information?
Please help?

I dont see where you wish to store this information. as I see it, you need to add a new column on your candidate table for job id and when you submit the data to the form, add the job id you got from the url parameter