I am trying to do something similar but I am having trouble and I can't pinpoint the problem. I have tried adapting the script that was from the solution to Heather's question. I have listed the objective and the problem that I having along with attached screenshots of the script, the xls setup, and the example form.
Objective: Automate the pull of additional attributes based on the project ID pulled.
The user chooses a project using search appearance and list_one. Once the project is chosen, I would like to have the project title and the project amount auto-populate based on the user selection of the project id. The script will run with no errors but doesn't return the project title or the project amount.
I would appreciate any help or if someone can point me in the direction that would be great too.