I'm left scratching my head. I have made the form, entered data, sent data to database, all with ease. Now comes the hard part for me, retrieving and displaying the data. This should be easy, I'm sure that I can't see the forest because of the trees, so to speak. Easy form, 2 variables. It's an attendance form, only entering the date of the meeting and who was there. As the list of members is short (10), I opted to use the checkbox option. I created an item in the components tab using "menu creator", but it doesn't show me the checkbox listing, only the date (I have a field name for the checkbox, just no data in it). So I thought I would use the profile plugin, enter the date I want to see and have it fill in the checkboxes but I just can't figure out how to display the data to the screen. Can anyone point me in the direction I need to go? Thanks in advance.
Forums
Is there a tutorial to use Profile Plugin?
Hi electra,
Dates are tricky - you are going to need to make sure that what is entered is 'exactly' the same as what is in the db record - or do a conversion to make sure.
Run a trial with a simpler set of data - use the jos_users table for example - to prove that it all works, then sort out the date matching isssues.
Bob
Dates are tricky - you are going to need to make sure that what is entered is 'exactly' the same as what is in the db record - or do a conversion to make sure.
Run a trial with a simpler set of data - use the jos_users table for example - to prove that it all works, then sort out the date matching isssues.
Bob
Thanks for the reply, but the date thing is not my problem. How do I use profile plugin? Maybe I'm doing it wrong. I click on the form (only have one), then click on profile plugin, next page I fill in the required fields, and then save. At this point, I'm taken back to forms manager with a blue bar saying config saved. What config? This is not accomplishing my goal. Where is the tab/link/button to push to display the data in the database? I tried to run a trial with a simpler set of data before making this form and had the same problem, unable to display the data in the database. I’m sure that once I get past this, I’ll realize how thick headed I am.
Hi electra,
Sorry, I've read these posts several times now and I don't know what you are trying to do. Please can you spell it out.
What I think I understand is that you have some data saved in the database with records like: 'id'+'date'+'name'
You want to pull out all the record for some particular date and display the corresponding list of names as an array of checkboxes?
What do you then want to do with the checkboxes?
The Profile Plugin is only intended to return one record from the database - so, for example it will let you display the info for user_id=99 or record_id = XYZ, it won't return an array of several values.
If you want to display many records from the database then you can use ChronoConnectivity which is a much more flexible data display tool.
Bob
Sorry, I've read these posts several times now and I don't know what you are trying to do. Please can you spell it out.
What I think I understand is that you have some data saved in the database with records like: 'id'+'date'+'name'
You want to pull out all the record for some particular date and display the corresponding list of names as an array of checkboxes?
What do you then want to do with the checkboxes?
The Profile Plugin is only intended to return one record from the database - so, for example it will let you display the info for user_id=99 or record_id = XYZ, it won't return an array of several values.
If you want to display many records from the database then you can use ChronoConnectivity which is a much more flexible data display tool.
Bob
I've had a good nights sleep and have come to the conclusion that you’re right, profile will not do it for me. I will try ChronoConnectivity.
This is what I am trying to do. A weekly meeting is held with the same 10 people. These people are teenagers and their time at these meetings count toward community service hours required to complete high school. What is happening is that the teenagers are submitting paperwork to the meeting advisor (an adult) months later to sign stating the hours put in, but they always seem to add meetings where they are not present. So, I made a form that the advisor can check off the attendees. If any meeting is in question, then the advisor needs to input the date of the meeting, have the data of the checkboxes displayed on screen to confirm or deny that the individual was actually at the meeting. Only 2 variables, date and checkboxes, but I now believe that the checkboxes do not count as one record, that the record would change due to individuals missing meetings.
So as I see it, two forms are needed, one to input the data to the database and one to display the data for a past meeting. Or am I wrong about this?
This is what I am trying to do. A weekly meeting is held with the same 10 people. These people are teenagers and their time at these meetings count toward community service hours required to complete high school. What is happening is that the teenagers are submitting paperwork to the meeting advisor (an adult) months later to sign stating the hours put in, but they always seem to add meetings where they are not present. So, I made a form that the advisor can check off the attendees. If any meeting is in question, then the advisor needs to input the date of the meeting, have the data of the checkboxes displayed on screen to confirm or deny that the individual was actually at the meeting. Only 2 variables, date and checkboxes, but I now believe that the checkboxes do not count as one record, that the record would change due to individuals missing meetings.
So as I see it, two forms are needed, one to input the data to the database and one to display the data for a past meeting. Or am I wrong about this?
If you would go for ChronoForms (CF), you'd need 3 forms, or rather "functions". One to input the data, one to select the date, and one to show the data for the date.
With some creative coding, these "functions" could be combined into 1 or 2 forms.
However, to me, this sounds like a perfect application for ChronoConnectivity (CC).
Using CC, you devise a list-view (shows a listing of the database rows with whatever information you'd like for each row), where you also add tags for add/delete/modify record-links.
Next, you create the add/modify (frontend) form, in pretty much the same way you would do it in CF. No extra work is needed to display field data, etc.
Once published (with proper permissions), you'll first see a list of meetings with add/delete/modify-links related to each record. If you click on new, the form will be displayed without any data filled. Should you click modify instead, the very same form will be displayed, except all form fields are now filled with data from the selected record.
With some creative coding, these "functions" could be combined into 1 or 2 forms.
However, to me, this sounds like a perfect application for ChronoConnectivity (CC).
Using CC, you devise a list-view (shows a listing of the database rows with whatever information you'd like for each row), where you also add tags for add/delete/modify record-links.
Next, you create the add/modify (frontend) form, in pretty much the same way you would do it in CF. No extra work is needed to display field data, etc.
Once published (with proper permissions), you'll first see a list of meetings with add/delete/modify-links related to each record. If you click on new, the form will be displayed without any data filled. Should you click modify instead, the very same form will be displayed, except all form fields are now filled with data from the selected record.
This topic is locked and no more replies can be posted.
