Getting started

7 Replies to “Getting started”

1. Hi there,
   I’m new to WP and WP Data Access. For project management I created several related tables and now it’s time for a nice frontend. Amongst other tables I have: 1. Project table, 2. Booked Hours, 3. Performed Work
   I’d like to have the open projects on top of the page (this is done)
   When I select a project, I’d like to filter the list below (Booked Hours) with the selected idProject.
   One or many items are be listed.
   Then again, if I pick one of the booked hours items, the 3rd list should be filtered by this idBookedHours.
   Is there any video or instruction how to pass a parameter (idProject) to another list on the same page?
   Thanks for any input on this!

   Reply

   1. Hi Peter,

      You can create master detail pages using Data Projects to manage your relationships. This is documented here:
      https://wpdataaccess.com/docs/documentation/data-projects/one-to-many-relationships/
      The tutorial is a bit outdated, but the it still works the same way.

      Data Projects makes your implementation easier, but it does not give you the freedom you have with a programming language. Pages are constructed in a standard format. You’ll need to check if this fulfill your needs.

      If necessary, you can add your own links to other pages with dynamic hyperlinks. This is documented here:
      https://wpdataaccess.com/docs/documentation/data-explorer/dynamic-hyperlinks/

      Dynamic hyperlinks allow you to create your own page flow, but each link requires a new page request, which is not needed with Data Forms (premium Data Projects solution). An example of a Data Forms application can be found here:
      https://wpdataaccess.com/docs/documentation/data-forms/project-demo/

      Hope this helps,
      Peter

      Reply

      1. Thanks Peter, I will check this out.

         Reply

      2. Yesss, the Data Forms (3rd link) did the trick 🙂
         I set up already all 1:n relations (1st link)
         One more thing: How, or better, where to change the layout of the tables?
         It seems to be limited to 50% of the browser window.
         Also the font size is way too large.
         My neighbour across the street is commenting on my projects 😉
         Cheers
         //Peter

         Reply

         1. Hi Peter,

            For you popups you can overwrite class wpdadataforms_modal. A menu is shown in a div containing class wpdadataproject_menu, pages are bundled in a div containing class wpdadataproject_menu_pages and each single page contains class wpdadataproject_menu_page. With these classes you should be able to style your Data Forms.

            Some individual elements might need individual styling. That often depends on your theme. You can use your inspector for fine tuning. Let me know if you have good ideas for improvements…

            Good luck,
            Peter

            Reply

            1. Thanks, Peter.
               Where would I find the class wpdadataforms_modal and the other class’ you mentioned.
               So far, I created a Project with several Pages, one for each table and also added the relations between the tables. Each Page has a ‘Template Set Name’ with ‘default’ setting.
               Thank you!
               //Peter

               Reply

               1. Hi Peter,

                  I believe I did not explain myself very well… This is not a code class. It is a CSS class, which you can easily overwrite.

                  Hope this helps,
                  Peter

                  Reply