Hello,
My open URL button is passing 3 separate parameters dynamically as intended (Years, Months, Facility ID's), however I am approaching the URL character limit.
Is there a way to change my bolded query portion to not show all facility_id's within the URL Yield if the field remains un-selected (possible)?
URL QUERY
='https://devqvs.bedashboard.com/QvAJAXZfc/opendoc.htm?
document=OST%20PART%202%20FINAL.qvw&host=QVS%40eisdev-qvs0&Sheet=SH04
&Select=LB244,' & Concat(DISTINCT Year,',')
& if(isMonthSelected=1, '&Select=LB243,' & Concat(DISTINCT Month,',') ,'')
& if(IsFacilityNameSelected=1,'&Select=LB256,' & Concat(Distinct Facility_ID,','), if(IsFacilityIDPossible=1,'&Select=LB256,'& Concat(Distinct Facility_ID,','),''))
URL YIELD
https://devqvs.bedashboard.com/QvAJAXZfc/opendoc.htm?
document=OST%20PART%202%20FINAL.qvw&host=QVS%40eisdev-qvs0&Sheet=SH04
&Select=LB244,2015
&Select=LB243,Apr,Feb,Mar
&Select=LB256,22768,22769,22770,22771,22773,22775,22777,22778,22779,22780,22781,22782,22783,22784,22785,22786,22787,22788,22790,22791,22792,22793,22795,22796,22797,22798,22800,22801,22802,22803,22805,22806,22807,22809,22810,22811,22812,22813,22816,22818,22819,22820,22821,22822,22823,22824,22825,22826,22827,22828,22829,22830,22832,22835,22836,22837,22839,22840,22842,22843,22846,22848,22849,22850,22852,22853,22854,22855,22856,22858,22860,22861,22863,22865,22867,22869,22870,22871,22872,22874,22875,22876,22877,22878,22879,22880,22881,22884,22885,22887,22888,22890,22891,22893,22896,22897,22898,22899,22900,22902,22903,22904,22905,22906,22907,22909,22910,22911,22912,22913,22914,22915,22918,22919,22920,22921,22926,22928,22929,22930,22932,22933,22934,22936,22938,22939,22940,22942,22944,22945,22946,22947,22948,22949,22951,22952,22953,22955,22956,22957,22960,22961,22962,22963,22964,22965,22966,22967,22968,22969,22970,22971,22972,22973,22974,22975,22976,22977,22978,22979,22982,22983,22987,22988,22989,22990,22991,22992,22993,22994,22996,22997,22998,22999,23002,23004,23006,23008,23009,23010,23011,23012,23013,23014,23016,23018,23019,23020,23021,23022,23023,23024,23025,23026,23027,23028,23030,23031,23032,23033,23034,23035,23036,23037,23038,23039,23040,23041,23069,23073,23083,23084,23085,23086,23087,23088,23089,23101,23102,23103,23106,23107,23110,23111,23112,23113,23114,23115,23116,23117,23118,23119,23121,23123,23124
