Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!
  • Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.


    To learn more about how to use our BBCode feature, please click here.

    Thank you, Code Forum.

HTML & CSS Autofill

Hey, the dropdown in red is connected to my sheets and displays products within it. I want to fill the rest of the boxes with the related information to the product but I'm having issues can any one help ?
 

Attachments

  • Screenshot_20210124-203303_Mes en plaice.jpg
    Screenshot_20210124-203303_Mes en plaice.jpg
    182.4 KB · Views: 4
[CODE title="G/s J/s"]Google Script

/*GET DROPDOWN LIST */
function getDropdownList(range){
var list = readData(globalVariables().spreadsheetId,range);
return list;
}

JavaScrip


//RETRIVE DATA FROM GOOGLE SHEET FOR COUNTRY DROPDOWN
function createCountryDropdown() {
//SUBMIT YOUR DATA RANGE FOR DROPDOWN AS THE PARAMETER
google.script.run.withSuccessHandler(countryDropDown).getDropdownList("Data!B2:B1000");
}

//POPULATE COUNTRY DROPDOWNS
function countryDropDown(values) { //Ref: https://stackoverflow.com/a/53771955/2391195
var list = document.getElementById('country');
for (var i = 0; i < values.length; i++) {
var option = document.createElement("option");
option.value = values;
option.text = values;
list.appendChild(option);
}
}
[/CODE]
 

New Threads

Latest posts

Buy us a coffee!

Back
Top Bottom