Okay
  Public Ticket #1716492
Attendence Tracker
Closed

Comments

  • germac74 started the conversation

    I just have a question regarding the use of your plugin - wpdatatables
    I am just starting out with a web-page and my hope is that I can use your plugin as a type of attendance recording tool.
    The idea is that when I display the list form, it would list all of the names of the people in my group and have 2 check-boxes beside each of  them. These check-boxes would be "Present" or "Absent". I can them go down through each name on the list and select either of the check-boxes that applies to that person on the list. The result would then be stored in the participants database. The long-term plan would then be that I could go to this form, select a date from a drop-down and the names list would appear for that date. I would then complete the attendance check for each person on the list and submit for that date. The database would then store all of the data for each weekly attendance taken. 

    I have some web development experience with just putting together websites that use general plugins but I dont know how to code this function and can not find any other plugin that will do the same thing. I have been looking at Gravity Forms with wpdatatables and from reading your documentation it looks like it is very adaptable to individual needs. I understand how to use the plugin for general use but dont understand too much on how I can complete my intended use for the plugin. Is there a way that each person listed can have multiple entries for the same form item. For example, can someone be recorded as present for not just one date but for many throughout a year. How would I list each person from the list with the check-boxes beside there names instead of listed just one name field that is empty? Also is there a way that I can backup the database within a standard myphpadmin interface?


    I am prepared to purchase the Gravity Forms add-on for the plugin if you think this is the way to go with my idea.
    Any help would be greatly appreciated.

  •  472
    Isidora replied

    Hi germac74,

    Thank you for your purchase.

    Unfortunately making list with gravity form and then make table from it is not good solution because it will be render in wpdatatables like small table and it is not possible to filter it.

    If I understand you right you can do that just with wpdatatables. You can make manual table and add one column for date and all other columns will be names of your people. For each name column you can set column type to One line selectbox and insert Possible values (Present and Absent).

    Then in edit modal you can insert date and for each user you can set is it Present and Absent. Later on you can filter that table with specific date and you will see who was Present or Absent for that day.

    I hope that this is what you looking for.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables

  • germac74 replied

    Hi Milan, thanks for your response. Yes I have created the table in WordPress for attendance (Names, Dates, Absent, Present) and it displays fine in the back-end. What I would it to be able to do is have a form at the front-end of the website for a particular user of the site. When this user logs-on he will then see a form. (This form will hopefully reference the Attendance table). The front-end form would have a Date drop-down. The date here would reference the Date column in the Attendance Table. When a certain date is selected here by the user at the front-end, the form below it would appear with a list of the names from the same Attendance table. Beside each name in this form would be 2 check-boxes -  one for Absent and the other for Present. The idea would be that the user is using this form at the front end, would go down through the list of names and select either of the forms check-boxes - absent or present, for each name. And then submit the form. The form submission button would then update the Attendance table with the details.

    I was reading a bit about your products and the Gravity Forms add-on. I wouldnt be good at coding at all but would kind of understand how certain functions within the code and  plugin work by calling each other. I read somewhere on the site about dynamically populating fields and having forms reference tables, etc. But I dont know if this applies to what I would like to achieve here. Thanks for you help so far, I appreciate it.


    I do understand, as you have explained, that it can be done using just wpdatatables but we are hoping to have it in a form format, as there may be other items that we would like to add to the same form at a later stage.

    Gerry

  •  472
    Isidora replied

    Hi germac74,

    Unfortunately that is not possible with wpdatatables. When you create table in wpdatatables(manual table) it will be created table in database. With Gravity forms integrations it will not be created table in database, because this add on use already created gravity tables in database and all new data will be saved there. It is not possible to connect manual wpdatatables with gravity form with our add on.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables

  •   germac74 replied privately
  •  472
    Isidora replied

    Hi germac74,

    My suggestion is to contact support of Gravity forms and check is it possible to do that on front-end with the form. If is possible then you will be able to make table with Gravity form integration add on, but if that form have to be made with list type of the field in Gravity then in wpdatatables will be shown as small table in cell and you will hot be able to filter or sort the data right, but table will be editable.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables