User Entry Form

  • Resolved mlapl1

    (@mlapl1)


    3 years, 6 months ago

    Hello
    Still new and still struggling and still hugely impressed…
    I think I have the retrieval of information more or less under control.
    However… I would like to create a form that would enable users to enter, modify and (perhaps) retrieve their own information. Are there any forms that will enable me to do that and that are already integrated/integratable with WP Data Access? Not sure where to find it/them.

    Thank you for your help
    Andrew

    • This topic was modified 3 years, 6 months ago by mlapl1.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Andrew,

    Good to hear you are making progress! ??

    WP Data Access allows you to use the WordPress user info in your forms. The basics are described here:
    https://wpdataaccess.com/docs/documentation/data-projects/user-roles-and-where-clauses/

    To use this feature your students will need to have a WordPress account. The WordPress admin user needs to add the WordPress user id to the student information in let’s say the student table. Then you can use the $$USERID$$ variable in your default where to restrict the data shown on a student results page for example. This ensures that students will see only their own results.

    Does this help?
    Peter

    Thread Starter mlapl1

    (@mlapl1)

    Hello and thank you Peter.
    I was actually wondering whether users could change their own data. I think I understand about users VIEWING their own data, but changing it is a different story.

    Cheers
    Andrew

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Andrew,

    Good point! ??

    To prevent students being able to change their own data, you need to create two project pages and two project templates. On page level you can define which transactions are allowed. In the project templates you can for example hide the WordPress user id for students and make it editable for admins.

    Does that make sense?
    Peter

    Thread Starter mlapl1

    (@mlapl1)

    OK. Thanks Peter – good information. I will investigate the templates. It sounds like a template can work a bit as a form and enable editing of information (which is what I want in the context that I am working on at the moment).

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    >>> It sounds like a template can work a bit as a form

    Correct Andrew! A template allows to define which columns are shown on a table and a data entry form. You can handle different forms for different user groups with separate templates.

    Good luck ??
    Peter

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘User Entry Form’ is closed to new replies.