load previously entered data (per suer)

  • Resolved mschtoni

    (@mschtoni)


    9 years, 1 month ago

    Hi,
    I took over a Website, where multiple forms where built using CFF. Some Forms contain user specific data, some forms contain project data (owned by a specific user).
    Processing and storing the form data in mysql works as expected.

    Now the customer would like to display and edit the stored data. If possible on the same page and in the same form as he created dataset.
    User specific data( user profile, adress…) should be loaded and prepopulated when a logged in user opens the form page.

    Project Data should be loaded in a form when choosing a project number (primary key) from a drop down list. On clicking save the data should be updated in database.

    I think they have something like MS-Access in mind;)

    Can this be done with your plug-in and the “user” add-on.
    Or do we need to fetch the data from mysql and write it in the value=”<?php echo…” attribute for each single form field, manually?

    Would you suggest building separate view-forms, new-forms and edit-forms? (they do this e.g. in Sharepoint)
    Thanks for advice
    Markus

    https://www.ads-software.com/plugins/calculated-fields-form/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    Hi,

    You’re talking multiple technologies in your project’s description (Like MS Access, Sharepoint, etc.), in reality our product is a WordPress plugins based on the technologies used by WordPress (database in MySQL, PHP as programming language, and JavaScript in the client side).

    If you want load the forms with some fields pre-populated, either with the information of the registered user, or the information of the selected project, you should install the Developer version of the plugin, and use in the form the “DS” fields (a set of fields whose data are gotten from external data sources like: Database in MySQL, a CSV file, the WordPress users, the posts data, or taxonomy data). Furthermore, the submitted information would be stored in the tables of the plugin, and the table or database you prefer.

    If you activate the “Users” add-on, will be available a new shortcode that loads the list of submissions belonging to an user, furthermore, if the add-on is configured to allow the user modify the submitted data, each entry in the list will display two new buttons, for deleting the row, or for editing its data, in whose case the form is loaded in a popup with the data submitted previously.

    Best regards.

    Thread Starter mschtoni

    (@mschtoni)

    Thank you for your answer. I had a closer look on the databse and now I see what the problem is.
    My customers tried to use your plugin as a databse builder, thinking calculated form fields would automatically create the required tables, columns and even relations in the background.
    Of course it should be the other way round: building up a databes and cretae forms afterwards.

    So if we use “DS” fields as you suggested, to load data from an db. Can all the calculating options of your plugin also be used on DS-fields? E.G. load a fields, do aome calculations and write the calculated data back on submit;
    My customers love your plugin, so I try to keep it.

    Plugin Author codepeople

    (@codepeople)

    Hi,

    The calculated fields are not “DS” fields, however, it is possible to load data from database with “DS” fields, and then, use the “DS” fields in the equations associated to the calculated fields as any other field in the form.

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘load previously entered data (per suer)’ is closed to new replies.

Tags