Is there a way for a collection to pull the Text from a value field?

asked on October 21, 2020

We have an Evaluation form that has a grading scale for areas that are being evaluated. Each field for the area of evaluation, is a dropdown that has

Some areas being evaluated:

Attendance
Compliance
Dependability
Driving

Grading scale is as follows:

EP (Exemplary Performance) = 5
AS (Above Standard) = 4
MS (Meets Standard) = 3
RI (Requires Improvement) = 2
BS (Below Standard) = 1

The goal is to have a separate collection called Substandard that will list all the areas being evaluated that have a value of 1 or 2. For each area there will be a range of collections that autofills what area has a value of 1 or 2.

For each area that is substandard, it would create additional collections to document what needs to be worked on. Please help...

0 0

replied on October 21, 2020

There are a few way you can approach this, most will be kind of messy imo but should be possible with jQuery. Roughly speaking what you need to do is set a onChange listener event on the gradescale inputs. In that onChange function you'll need to:

Check to see if the new value is a grade 1 or 2, if it is continue otherwise do nothing
Simulate a click on the "add" link for the collection using the click jquery function.
Grab a reference to the substandard collection, and find the last collection item.
Auto fill what ever fields you need filled in on this collection item.

The roughly outlines one approach, and if you can get that to work then next you'd likely want to be able to undo all that if say the user decided to change their mind or accidentally selected a 1 or 2. The steps will be very similar. Hope this helps!

0 0

Question

Question

Is there a way for a collection to pull the Text from a value field?

Replies

Sign in to reply to this post.