What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Sales target table for more than 150 sales engineersAsked by mohammednadeem on January 29, 2017 at 02:03 AM
we have a requirement, where we need to give a sales target letter of each month to around 150 sales engineer and they will have 2 button (accept/reject) and upon acceptance, it will generate a pdf file and send it to their manager and same for rejection also. example of the table :
Note: each sales engineer, upon login with their PIN, they can able to see their own sales target data/table, how we can achieve this by using jotform?
AR % Overdue
Gross Margin %
Unfortunately, the table that you have shared did not reflect here on the forum. Perhaps you can upload a screenshot instead?
But based on how you have explained it, I believe it's only partial on what you have stated that JotForm can accomplish. If you wish to send an individual email with the PDF to each one of your 150 sales engineers, that's possible. You can make use of the email alerts feature to send these emails to your sales engineers individually. But if you wish to send to all 150 on a single click, I would recommend to make use of other services like MailChimp or Madmimi for mass emailing services.
If your method of sending email is by submitting a form one by one, then it's possible to make use of JotForm and allow your recipients to edit the form submission where they can accept and reject.
You can check this guide to know more about email alerts: https://www.jotform.com/help/30-Explanation-of-Email-Notification-and-Autoresponder-Settings
And check this guide for editing submissions for possible instances of your sales engineers to do acceptance/rejections: https://www.jotform.com/help/325-How-to-Edit-Submissions-Made-on-Your-Forms
If I am missing something, or if you can provide a more details of the flow that you wish to make happen, please let us know.
HI, thanks for your reply
please see the screenshot of table, how it looks like only 2 rows are appearing, where as 12 rows are there actually (12 months), regarding email, need to send to individual only at one time. but here, how we can show different tables in a form to each sales engineer?
I'm sorry if I did not understand this part, but will the data in the table be populated by you, or by your users?
You can use a Matrix field for collecting tabular information:
By showing a different table to each person, if you meant to pre-fill the table that you send to each person with different values, then you can simply use our form prepopulation feature and prepopulate the fields with desired values that way:
Then, you would send each engineer their own prepopulated form link, so they can fill out your form with their personalized data and submit it.
Please try it out, and let us know if there is anything else we can do to help.