Field: Assigned inspector is in Choices worksheet.
Field: Contract is in Choices worksheet & shows a dropdown specific to the usersname.
pulldata('Contract_working2019', 'ContractName','ContractNumber',${Contract})
Field: Licensee data is in a csv file in the media folder & uses the Contract number to pull data.
This field works with last year’s data which shows the "number showing as text" error flag.
This year’s fields no longer show the "number showing as text" error flag and they are breaking the link.
*See attached for a better explanation.
Is there another way I can do this, so next year we won't have this issue?
I've tried changing the fields in the choices worksheet to text, and general, but I don't get the error flag. I've also changed the .cvs column to number, text, and general to no avail.
