Help me with this query with a reference to variables

Hello @watsonbriant and welcome to the forums!

A couple of things that stand out to me right away:

  1. the currentYear variable you are using should be referenced with {{currentYear.value}} which should at least supply the data properly, however...
  2. ...it appears that your value is being set AFTER the trigger for the query that uses it. You have a list of events being triggered on a single click but it may be a better idea to chain the events using the Success/Failure handlers on each query. You can also trigger queries using the Run Script event on the current click handler and set your variable or pass relevant component/app data using the additionalScope option .
1 Like