/ Id-Extras Forum / How to enter excel list in drop down menu

  • Author
  • #6642 Reply
    Nik

    Hi, Ariel

    Is there is any way yo enter automatic excel list of items with more than 200 position in Drop down menu. I dont want to enter it one by one.

     

    Thank you

    #6643 Reply
    ~~Ariel~~
    Participant

    Hi Nik,
    You can use the method described here: https://www.id-extras.com/forums/topic/formmaker-pro-combo-box-export-values/
    Ariel

    #6645 Reply
    nikolayU
    Participant

    Hi, Ariel

    Thank you.

    I am sure that this will work because i know that after you make it it will work

    The problem is that  i can understand where you add the list item coming from Excel

    I create one combo field with  Form Maker and i name it “Country 1” and i have a excel with 24o country type one under another…..where in your script i have to paste the list which i will copy from the Excel

     

    Thank you

    #6646 Reply
    ~~Ariel~~
    Participant

    You have to convert the Excel list to a single line that looks like this:

    var l = this.getField("ListBox");
    l.setItems(["One", "Two", "Three"]);

    … where, instead of “ListBox”, enter the name of your field, and instead of “One”, “Two”, “Three” replace it with your list from Excel.

    As described in the post I linked to, this should be added as a Document script in FormMaker, and that Document script should be removed (in Acrobat) before you distribue the final PDF.

    This is a workaround, but it makes it a lot easier than using InDesign’s UI for the task.

Viewing 4 posts - 1 through 4 (of 4 total)

Tagged: 

Reply To: How to enter excel list in drop down menu
Your information: