Variables linking

• 
  Are you saying that the dataset of the first dropdown changes? I'm not sure how that would work.

  KathiK May 09, 2020 18:18

  - 0 +
• 
  Can you upload an image of what this report looks like?

  KathiK May 09, 2020 18:24

  - 0 +
• 
  I'm thinking that you probably want to use a stored procedure for the dataset if your data is in SQL Server.

  KathiK May 10, 2020 18:05

  - 0 +
• 
  Hi Kathi,
  
  The first dropdown would dictate the whether we wanted to know the data for departures, or returns for a certain date, fed in by another parameter date dropdown. let's say it's an Holiday Scheduler. And i want to know the Airport, Airline, departure time, passenger info etc for all holidays for a date. But depending on the first dropdown, the reports is going to give me departures for that date, or returns for that date. 
  
  So the query would be 
  
  Select DepartureDate From Schedule 
  Or 
  Select ReturnDate From Schedule
  
  Hope that makes it clearer.
  
  Thanks

  TLA May 11, 2020 14:49

  - 0 +
• 
  Probably the easiest way to do this would be to have the second drop down be based on a stored procedure that has an IF so that the correct query runs. But, you might be able to do something with a UNION of the two queries. I have a meeting in a couple of minutes, but I'll get back to you with some pseudocode after that.
  
  

  KathiK May 11, 2020 14:55

  - 0 +
• 
  Assuming that the first parameter is called @Type and it returns a string of either "DepartureDate" or "ReturnDate" then this query would work: 
  
  

  SELECT DepartureDate AS TheDate

  FROM Schedule 

  WHERE 'DepartureDate' = @Type

  UNION ALL 

  SELECT ReturnDate 

  FROM Schedule 

  WHERE 'ReturnDate' = @Type

  KathiK May 11, 2020 15:32

  - 0 +
• 
  To link two variables in your scenario, you can use conditional logic based on the first drop-down selection. If the user selects "Departure Date" or "Return Date" from the first drop-down, this would dynamically filter the data source to show the corresponding column (Departure or Return) in the second drop-down, which is the date selector. This approach ensures the correct date is linked to the appropriate data.https://trafficrider.racing/
  

  zainabbas October 19, 2024 17:45

  - 0 +
• 

  To link the two drop-downs:

  1. First Drop-down (Source Selector): Let the user select between "Departure Date" or "Return Date."
  2. Second Drop-down (Date Selector): Populate the second drop-down with dates based on the first drop-down selection.

  Implementation:

  • When the first drop-down selection changes, dynamically filter the second drop-down to show either departure or return dates from your table.

  Example (pseudo-code):

  javascript

  Copy

  firstDropdown.addEventListener("change", function() {    var selectedSource = firstDropdown.value;    dateDropdown.innerHTML = ''; // Clear previous options    // Populate second dropdown based on selected source    if (selectedSource == 'Departure Date') {        populateDates(departureDates);  // Use departure dates array    } else if (selectedSource == 'Return Date') {        populateDates(returnDates);  // Use return dates array    } }); function populateDates(dates) {    dates.forEach(function(date) {        var option = document.createElement("option");        option.value = date;        option.textContent = date;        dateDropdown.appendChild(option);    }); }

  This way, the second drop-down dynamically updates based on the first selection.
  
  Traffic Rider APK is an absolute must for motorcycle game enthusiasts. The modded version gives you a ton of freedom with no restrictions, allowing you to experience the game to its fullest. Plus, the variety of environments and challenges keeps things fresh and exciting!

  lurkerdipts February 26, 2025 09:18

  - 0 +

Add comment

Please sign in to leave a comment.