It is possible to find records with a certain name (fe john) and put his data (email, company etc) in a javascript array? Thanks for helping.
You can’t legally put customer details like this in your front end, would be a data breach.
Hi Mike, thanks for the response. I totally agree. I want to calculate the average of their scores (via Forms). It is not about their personal data.
Okay in that case I am not sure I understand the question, yes you can convert any dataset to a JavaScript array. Which scores are you thinking? I’ve used excel in the past to reformat a dataset into a way I wanted it by adding my code in columns and exporting the data as cvs and removing commas. Janky workaround, I mean you could programtically do the same easily enough in anything. Why a JavaScript array? Internal reporting?
In a form I am asking 3 questions on how happy people are in their team. They can score from 1 to 5 on
1. Your Overall score of the team
2. Do you have a clear role in the team?
3. Are you happy in the team?
if 20 people fill out the form I want to calculate the average score per question.
And present this immediately after filling in the form, on a landing page.
Each of the 20 team members receive a teamcode, they need to fill that in the first formquestion.
thanks for helping.
Do you have calculation fields?
I dont think they will update fast enough to use as they are dependants.
Would emailing them be okay? that way you can build in the time for the calculation field to update into the workflow so the information is there.
If not you can do it again via email, send them a link and use hidden personalisation fields with the scores, and then reconstruct with javascript on the front end.
You could also test using the personalisation field calculated in the post form page, but I am almost 100% that will not work.
If you have to get them to a new page, and the calculation field does not work, you could reconstruct the URL with a query string in javascript putting the scores into the parameters that you could then access with hubl and calculate the score there,you’ll need to use a raw html form for that so you can edit the submit url
I missed a bit, to aggregate the scores you’ll need to push the data up to the company record with a workflow and do that bit there
Hi Mike,
Thanks for the response. I need those average scores in Javascript to do more calculations.
I already have the individual scores in Javascript and I can present them to the individuals (based on their email) on the landingpage.
Right so pull them from the company record with account.fieldname ?
Hi Mike, that’s a good idea. Can you show me how to do that in Javascript?