I've got a CSV file with four columns, something similar to below:
dc_anchorage,Anchorage,APG ANC *,41544000
dc_albany,Albany,APG ALB *,31544000
dc_albuquerque,Albuquerque,APG ALQ *,153072000
dc_altoona,Altoona,APG ALT *,31544000
dc_atlanta,Atlanta,APG ATL *,103072000
dc_billings,Billings,APG BIL *,111536000
I'm looking for a way to capture the values of all columns when a single row is selected. For example, say on the form I have a dropdown for "dc_name". When Anchorage is selected, I need it as well as the other three columns to be captured in tokens and passed on to charts within the form.
I've got it working with multiple dropdowns on the form. When you choose the first option it does an inputlookup and the other inputs are populated with the values of the row, however I don't want 4 separate dropdowns on the form. Is there a way to accomplish this? This is what I have today, but my preference would be to have just two dropdowns; a time picker and DC Name.