The Apps:
1) Jobs
2) Forms (This is not a SS form, the app name is Forms 🙂. Represents tempalte Forms)
3) Job-Forms (a junction table)
When the user is working on a JOB, they'll need to attach(add) forms to the job.
We can ask the user to go to the Job Forms app and create a new record (that will show up in the Jobs app as well).
However trying to achieve this all on the Jobs app.
As I click add a Job Form (link to Job Forms) on the Jobs app, the whole list of records are displayed and I need to filter using the dynamic filters to display only the Job Forms that belong to that job.
I need to check for the JobID (Link to Jobs) in JobForms = JobID (title field) in Job. Like the screenshot below and "no search results" is displayed.
Any reason for SS not allowing this to happen? 🤔
Or any possible workaround?
