Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Jira Legacy
serverSystem JIRA
serverId5443b7f3-2f11-3f32-ba15-42d15098c09a
keySLAT-20

moved from https://tufts.box.com/s/fzubsi6d5r8hww8rmap0d1n0beciq6sa

ISSUE: Cannot get data to display, AND be from multiple forms.

...

Page Properties
idbug-details

Slate Instance

TUH

Requestor/Reporter

Elizabeth Storrs

Date

Status

Status
colourGreen
titlecomplete

Bug Description

cannot get reference forms to display data correctly

SUMMARY/CURRENT STATUS:

...

  • prompt field values do not respect form rankings. This has been submitted to Technolutions, and maybe some day we will get a response.

...

  • Work-around in making sure all of the data is in free text fields has been accomplished for 2023 cycle

...

    • Manual Query->Import of newly completed recs

...

    • All previous recs from this cycle that used the old form have been imported

...

    • All NUTR defers have had their letters ported over

...

    • Working on report to find anyone in GSBS who is using last year’s letters.

...

  • And Technolutions gets back in touch 3 months later to tell us the answer was something we already tried and it didn’t work before

...

  • So, revert text fields/manual process back to the way it was displaying before.

  • Completed for 2024 cycle. See the troubleshooting and conversion notes below.

RESEARCH

https://knowledge.technolutions.com/hc/en-us/articles/360032612272-Custom-PDF

This is what we get without a Merge query—two forms with different data, like there should be, but not custom fields.

...

Things that DO NOT WORK

Brackets in the custom pdf

...

Things that DO work

 

...

+

...

=

Gets me A DIFFERENT ANSWER FOR EACH FORM!

...

For the top of the .pdf, I used the delivered Merge fields, as well as their “new” version without the NUM:

...

And this gets me

...

 Takeaways:

  • System > Merge queries must be application scoped.

  • The old NUM nomenclature, even if you choose a system field from the drop down, does not work any more

  • System fields, whether or not they are in the “available” list, do not need to be added to the Merge query.

  • The cache has to be broken in order to refresh the data. Have an easy thing to look at to determine if the .pdf you are reviewing has actually changed, and have a group of records you can cycle through.

  • Add Prefix, first, last and title, organization just as their own fields (rather than trying to get a concatenate to work) got me to:

...

The \2022_reference_uploads\People with imported old ref STATUS TRACKING.xlsx document has the status updates for everyone who was checked; 12/13 added new refs for Bootwala; still only Ryan and Clement are outstanding.

...

Amanda Holder (Technolutions)

Jan 30, 2023, 7:08 PM EST

Hi Elizabeth, 
 
Thank you for submitting this request and for your patience as we work through a high volume during this time. In reviewing the /apply/GSBS/reference.pdf it appears that the original reference scoped prompt based fields could have been added without the initial tag of reference which would cause the behavior you saw with the field not populating the value. In the Custom PDF KB article, it discusses that when adding a reference scoped field to the custom PDF, the initial tag of reference_  that is placed in front of the field id is required. Currently the custom reference scoped text fields have this which is why the fields are pulling data. 
 
In the test environment, we tested this by adding the original prompt based reference scoped fields and added the reference_  tag to the beginning. With that tag, the fields started to display the value for that question. The cache on the application has to be broken to get this updated as well.
 

Image Modified


We hope this information is helpful. We will go ahead and set this request to solved for now but if you have additional questions please let us know. 
 
Best Regards, 
Amanda & the Technolutions Team!


 
 

...

 State of affairs at end of 2023 cycle for both GSBS and NUTR:

...

I have copied this over and renamed it to be reference2023, and will work on the original reference.pdf. I believe all I need to do is revert what shows here to the old fields (with the billion boxes). The test case shows that if I follow the instructions Technolutions gave (at the end of the 2023 document), things work.

...

This also seems to indicate that I do not have to make any changes in order for the 2023 references to be re-used in 2024….all I have done is remove the necessity to turn the values into text.

Confirmed that data is showing correctly in the non-text version of the forms; have cleaned these up, and reference.pdf are now available across the entire instance.