First time posting a question here
- I have a grid with different jobs, and I’d like to create a form for people to apply to the jobs posted.
- I’d like to enable people who submit the form to choose a job title and company from a dropdown.
- I’d also like the enable them to upload their CV and cover letter, but without it affecting the fields in the grid (I don’t want the grid to include the files).
- Once submitted I’d like an automated email to be sent to the employers with all the details of the applicant (I’ll have the relevant email for each company in the grid, so I’ll have to pull this data in the automation).
How would you approach this?
I’d have two tables, one called
Jobs and one called
Applications, and create a link between the two.
I’d create a form view in the
Applications table, and allow users to select a record from the
Jobs table. They can also upload their CV and cover letter in the form; since it’ll go into the
Applications table, it meets your requirement of not going into the
After that, I would have an automation that would trigger if the field linking the
Jobs record to the
Applications record was updated, and make it send an email
@Adam_C thanks, that worked! Much appriciated!
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.