• Resolved simplycarriacou

    (@simplycarriacou)


    I like the plugin. Makes life very easy, however I need to set up a member database that stores all the usual information but with a section for the number of hours a member has contributed to the project and when those hours were worked for example:

    member 1234
    1 Jan 13 – 5 hours – sweeping floor – comments – verification files to be uploaded
    2 Jan 13 – 3 hours – cleaning windows – comments – verification files to be uploaded
    3 Jan 13 – 2 hours – taking kids to school – comments – verification files to be uploaded

    Total hours – 10 hours

    Ideally I would like each member to be able to log on an update their own record as and when the hours are worked or at the end of a given period.

    Is this or something similar possible with this database.

    Thanks

    https://www.ads-software.com/extend/plugins/participants-database/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author xnau webdesign

    (@xnau)

    The plugin doesn’t have this kind of capability built in. If you know how to code PHP, you can create a custom form element that would have the properties you describe. It would be fairly complex, but if you have the skills, I can give you some pointers.

    Thread Starter simplycarriacou

    (@simplycarriacou)

    OK .. just learning PHP but good knowledge of HTML and CSS. I’m wondering how to work around this.

    Let me so some research and have a think and then will let you know if I need any more assistance – I don’t want to take up your time unnecessarily.

    Thanks

    Hi, i have to create a situation very similar. So, i just need to know what happen if in the future i have to change the member name. For example, i use Alex like member and one day i have to change Alex with Alex2. I loose the association with all the Alex field db or i can keep and subscribe just the member name like the wp_wordpress user function?
    Sorry for my english, i hope that you understand

    Thank you

    Plugin Author xnau webdesign

    (@xnau)

    Yes, you can do this because the record can always be identified by either the “id” or the “private_id” which you can’t change.

    Did I understand your question?

    Yes, thank you

    Hy,
    Appreciate the plugin very much too.
    It has helped me a lot uptil now.

    And having a situation similar to simplycarriacou, I was wondering about the progress or any hints to get this going.

    The way I was thinking was to start a new table using another plugin, e.g. with support for a custom form and then use the user login code as a hidden primairy key. Would this help?

    Any help appreciated.

    Plugin Author xnau webdesign

    (@xnau)

    I’m not sure I understand your proposal, but generally these kinds of implementations require a knowledge of WordPress development. I have built a programmer’s API into the plugin for this purpose. That should get you started. This kind of thing is not a feature I will build into the plugin, there are too many different ways people will want it to work.

    If you want to contact me about developing some custom code, please email me with a general outline of your needs. support AT xnau.com

    Thanks for your answer and the reference to the API.
    Unfortunately, I can’t see how the api could help me.

    Today, I have nearly finished my own implementation.
    What I’ve done is the following:
    + Create a new table holding my own information, e.g. the working hours from the first example.
    + Create a new class, e.g. MY_Working.class, based on the PDb_List_Admin class.
    + The new MY_Working class shows and handles two parts:
    + + a table listing the currently stored working hours,
    + + a table listing the fields for a working hour record to add a new record.
    + Create a new short code to include the new MY_Working class on a page.

    It took some php coding and extensive testing, but thanks to the source code already provided, it only took me two days uptil now…

    Thanks again and maybe this item can be closed now?

    Plugin Author xnau webdesign

    (@xnau)

    Glad you found a way to do it…if you’re happy, we should call it resolved.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Can I set up one to many database relationship field’ is closed to new replies.