I am trying to create a Job board on bubble, and I am experiencing some difficulties creating the proper DB to interface with bubble correctly.
I need the following objects:
User - Email and more admin fields.
Profile - holding Name Phone and lots of other fields
Application - holding user field (and lots others)
The problem arises when I try to search for job applications. Let say I have Job listing A and a Candidate applying for that job. On the page where I can view the applications, I would like to sort the application seen by application status, phone, name, etc.
But this is only possible if I have the filed Name/phone/email on the application itself, meaning I need to duplicate many fields.
Without Keeping lists of objects of course ( as if i had a list of all the applicants it would get huge in a matter of days making the searches unusable).
Any solutions for that?