Jump to content
  • 0

Form that filters data and then selects an option to send email





I am attempting to create a form that allows an employee to select a evaluator(teacher) to approve a Qual Card. I have created a table that has the following columns. 

Name, Evaluator, Evaluator_Email, QC_Number, Branch, Region

All columns are prefilled out and will act as dropdown options with the exception of name. The employee will enter their name. Then choose their branch and then choose the QC card that they are applying for. Once they hit submit, it will generate a list of Evaluators based of the criteria of QC_Number and Branch. I have gotten to this point. The problem I am facing is how to then let the employee choose from this list of the evaluators. Once they choose the evaluator the thought process is they will hit submit and an email will be sent to that Evaluator based off the assigned evaluator email. Any help would be appreciated.


Screenshot 2021-11-04 160811.png

Screenshot 2021-11-04 160841.png

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Okay, so let me verify if I got you correct.

You have a form which your user will their branch and then choose the QC card that they are applying for. After that, they will have a list of evaluators based on what they have selected there as you show on the tabular report. 

You already made up to this point.

The next step is that you want a form where your user will select will select which evaluators they want and sent an email to the selected evaluators. 

Is that the case?

If yes, what I would do is a bit of JS and trigger.

First Im going to set a submission form multi select listbox. This listbox should be a cascading listibox that will show only values that are generated for the current user. Then, in order to make it the listbox multi-selectable, please see this forum post: 

 or this

If things went well, you will have a comma seperated values of the names or ID of the selected evaluator. We can then use it on the triggered action to trace the email address of those evaluators and send email to them.


What I say for now is the concept based on what I understand from your inquiry. I hope it helps and feel free to ask if you need more specific details.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...