How to connect Dropdown items with Database

  • Nicole
        Has successfully completed the online course Basics (100)
      3 years ago #27701

      Hi everyone,

      how can I use the dropdown widget that gets its items from a column of a table which I created in the Database Designer?

      Thanks and best regards.

       

      Dan
          Has successfully completed the online course Introduction
          Has successfully completed the online course Intermediate (200)
          Has successfully completed the online course Advanced (300)
          Has successfully completed the online course Basics (100)
        3 years ago #27716
        Up
        1
        Down
        ::

        Hey Nicole,

        to do this follow these steps

        1. Make sure that there’s only one item inside your dropdown (use the tree inside the UI designer)

        2. Select the dropdown and activate the property “itemsTemplate”. You can use the search bar on the right side to find this property faster

        3. Inside the process designer create a story or open the story you want the logic to be put in

        4. Subscribe to the event you want to trigger the loading (e.g. a button press or the onBeforeRendering event of a screen)

        5. Drag and drop a data service inside the story and connect it to your event. Select the data service node and and select the schema you created in the database designer.

        6. Select the entity set (aka table) you want to read the data from

        7. Inside the output mapping drag and drop a soure parameter from the left side, double click it and select the desired columns.

        8. Drag and drop a widget from the right side and select your dropdown widget. in the third column “properties and aggregations” you’ll have to select the aggregation (drawer icon) and there “items”.

        9. Select the dropdown_item and add the properties you want to map (e.g. text and key) by pressing the corresponding plus buttons. Confirm your selection.

        10. Connect the name of your table from the source parameter to the “Screen >> Dropdown >> items” node and the columns of your table to the text / key / etc. Confirm your selection

        11. Deploy. You now should be able to see all entries from this specific column

        Please let me know if everything’s working for you.

        Best Regards,

        Dan

        Nicole
            Has successfully completed the online course Basics (100)
          3 years ago #27719
          Up
          1
          Down
          ::

          Hi Dan,

          thanks for your help!

          Everything is working.

           

          Best regards,

          Nicole

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

        You must be logged in to reply to this topic.