Buy Now
Sign in

Update Field / Loop / Save

jformicola , January 31 2020, 19:26
J
jformicola 43
January 31 2020, 19:26 #390986
Please help. I'm copying the dynamic actions DEMO, but I can't get the update functionality to work on my form. I've got it to the point where the form loads the data, I can edit it, but my update button doesn't seem to do anything. I'm going to include a screen shot of everything below. Please help.
FormView.jpg
Debugger (Array that loads when the connection loads, there is a bunch of fake data in there from when I was testing the "new" buttton)
[div][div][div][div]
Array
(
[Itemid] => 279
[option] => com_chronoconnectivity6
[view] => connection
)
Array
(
[subject] => Array
(
[log] => Array
(
)

[var] => Array
(
[0] => Array
(
[subject] => Array
(
[ID] => 1
[Subject] => MRI - Changing Database
[Notes_For_Trainer] => Do before 9:30, You won't be able to if there are items on any calendar
[Instruction_Resource_1] =>
[Instruction_Resource_2] =>
)

)

[1] => Array
(
[subject] => Array
(
[ID] => 2
[Subject] => MRI - Calendar - Advancing the date
[Notes_For_Trainer] =>
[Instruction_Resource_1] => http://trainkamson.com/index.php/instruction/1-mri-manual/file#page=8
[Instruction_Resource_2] =>
)

)

[2] => Array
(
[subject] => Array
(
[ID] => 3
[Subject] => MRI - Calendar - Navigating
[Notes_For_Trainer] => Be sure the trainee knows how to look forward and behind and is clear on the distinction between advancing and navigating.
[Instruction_Resource_1] => http://trainkamson.com/index.php/instruction/1-mri-manual/file#page=6
[Instruction_Resource_2] =>
)

)

[3] => Array
(
[subject] => Array
(
[ID] => 4
[Subject] => Your Requested Information About Lakeview Apartments
[Notes_For_Trainer] => asdfasdf
[Instruction_Resource_1] => asdfasdfad
[Instruction_Resource_2] => asdfasdf
)

)

[4] => Array
(
[subject] => Array
(
[ID] => 5
[Subject] => Lakeview Apartments Information
[Notes_For_Trainer] => asdfasdf
[Instruction_Resource_1] => asdfasdfad
[Instruction_Resource_2] => asdfasdf
)

)

[5] => Array
(
[subject] => Array
(
[ID] => 6
[Subject] => asdfdasf
[Notes_For_Trainer] =>
[Instruction_Resource_1] =>
[Instruction_Resource_2] =>
)

)

[6] => Array
(
[subject] => Array
(
[ID] => 7
[Subject] => aaaaaaa
[Notes_For_Trainer] =>
[Instruction_Resource_1] =>
[Instruction_Resource_2] =>
)

)

[7] => Array
(
[subject] => Array
(
[ID] => 8
[Subject] => bbb
[Notes_For_Trainer] =>
[Instruction_Resource_1] =>
[Instruction_Resource_2] =>
)

)

[8] => Array
(
[subject] => Array
(
[ID] => 9
[Subject] => ccc
[Notes_For_Trainer] =>
[Instruction_Resource_1] =>
[Instruction_Resource_2] =>
)

)

[9] => Array
(
[subject] => Array
(
[ID] => 10
[Subject] => fdfdf
[Notes_For_Trainer] => dfdfd
[Instruction_Resource_1] => dfdfd
[Instruction_Resource_2] => dfdfd
)

)

[10] => Array
(
[subject] => Array
(
[ID] => 11
[Subject] => bbb
[Notes_For_Trainer] => bbb
[Instruction_Resource_1] => bbb
[Instruction_Resource_2] => bbb
)

)

[11] => Array
(
[subject] => Array
(
[ID] => 12
[Subject] => vvv
[Notes_For_Trainer] => vvv
[Instruction_Resource_1] => vvv
[Instruction_Resource_2] => vvv
)

)

)

)

)
Event1.jpgEvent2.jpgEvent3.jpgEvent4.jpgEvent5.jpgView1.jpg
View2.jpg
View3.jpg
View4.jpg
View5.jpg
View6.jpg
View7.jpg
View8.jpg
View9.jpg
Function1.jpg
Function2.jpg
Function3.jpg
Function4.jpg
[/div][/div][/div][/div]
healyhatman 9
January 31 2020, 22:56 #390989
There's a lot of pictures there that I can't follow all of them but just be aware that in an event, nothing after {redirect: in your event will actually happen. Unless you specifically need a redirect you should use {event:
If you press F12 and go to the Network tab, and THEN click update, one of the things you see will be the data your form sends to the server and its response. Have a look at that
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
I
ieraora 130
February 02 2020, 11:20 #391004
Hi jformicola, than you for you screenshot, with these I resolved my questions in this post
https://www.chronoengine.com/forums/posts/t108015/loop-multiple-field.
J
jformicola 43
February 04 2020, 21:09 #391036
Healyhatman - Thanks, but I don't understand your comment. Where do I hit f12? The redirect isn't the issue from what I can tell, I removed it.
Ieraroa - Thank you for your comment, I'm glad that my confusion helped you out somehow. I've tried to use your screenshots in conjunction with the demo setup and the best I can manage thus far is to get one field to update. I've tried using your screenshots to be able to update multiple, but to no avail.
Here are the debugs and some screen shots of the configuration I have now, which is allowing me to update just the "Subject" field. If someone could tell me how to now make it so I can update the remaining three fields at the same time, that would be helpful.
Healy - I was thinking about throwing a donation your way for the last one you helped me with, where do I do that? Please help!!!!
FormView.jpg
ReadData.jpg
SaveSubjectsLoop.jpg
Update_Subject_SaveData.jpg
Subject_Field.jpg
Notes_Field.jpg
Resource1_Field.jpg
Resource2_Field.jpg
After update:
[div][div][div][div]
Array
(
[conn] => add-edit-training-subjects-topics
[event] => update
[subject] => Array
(
[1] => PHYSICS
[2] => Start with chapter4
[3] => asdfadsf
[4] => asdfdasf
[15] => MATH
[16] => Start with Chapter1
[17] => http://Resource1
[18] => http://resource2
[14] => EXCEL
[19] => Start with chapter 5
[20] => asdf
[21] => asdf
)

[Itemid] => 279
[option] => com_chronoconnectivity6
[view] => connection
)
Array
(
[update_subject] => Array
(
[data] => Array
(
[conn] => add-edit-training-subjects-topics
[event] => update
[subject] => asdf
[Itemid] => 279
[option] => com_chronoconnectivity6
[view] => connection
)

[_success] => Data saved successfully
[log] => Array
(
[0] => UPDATE `tbltrainedtopics` AS `subject` SET `subject` = 'asdf' WHERE `ID` = '21';
)

[var] => Array
(
[subject] => asdf
)

)

)
[/div][/div][/div][/div]
On load:
[div][div][div][div]
Array
(
[Itemid] => 279
[option] => com_chronoconnectivity6
[view] => connection
)
Array
(
[read_data] => Array
(
[log] => Array
(
[0] => SELECT COUNT(`data`.`ID`) AS `data.count` FROM `tbltrainedtopics` AS `data`;
[1] => SELECT `data`.`ID` AS `data.ID`, `data`.`subject` AS `data.subject`, `data`.`Notes_For_Trainer` AS `data.Notes_For_Trainer`, `data`.`Instruction_Resource_1` AS `data.Instruction_Resource_1`, `data`.`Instruction_Resource_2` AS `data.Instruction_Resource_2` FROM `tbltrainedtopics` AS `data` LIMIT 30;
)

[var] => Array
(
[0] => Array
(
[data] => Array
(
[ID] => 1
[subject] => ENGLISH
[Notes_For_Trainer] => Start with chapter4
[Instruction_Resource_1] => asdfadsf
[Instruction_Resource_2] => asdfdasf
)

)

[1] => Array
(
[data] => Array
(
[ID] => 15
[subject] => MATH
[Notes_For_Trainer] => Start with Chapter1
[Instruction_Resource_1] => http://Resource1
[Instruction_Resource_2] => http://resource2
)

)

[2] => Array
(
[data] => Array
(
[ID] => 14
[subject] => EXCEL
[Notes_For_Trainer] => Start with chapter 5
[Instruction_Resource_1] => asdf
[Instruction_Resource_2] => asdf
)

)

)

)

)
[/div][/div][/div][/div]
Attachments
ReadData.jpg
ReadData.jpg
(135.06 KiB)
131 Downloads/Views
SaveSubjectsLoop.jpg
SaveSubjectsLoop.jpg
(118.17 KiB)
94 Downloads/Views
Update_Subject_SaveData.jpg
Update_Subject_SaveData.jpg
(145.15 KiB)
96 Downloads/Views
SaveSubjectsLoop.jpg
SaveSubjectsLoop.jpg
(118.17 KiB)
131 Downloads/Views
Update_Subject_SaveData.jpg
Update_Subject_SaveData.jpg
(145.15 KiB)
129 Downloads/Views
Subject_Field.jpg
Subject_Field.jpg
(124.88 KiB)
130 Downloads/Views
Notes_Field.jpg
Notes_Field.jpg
(125.84 KiB)
129 Downloads/Views
Resource1_Field.jpg
Resource1_Field.jpg
(147.67 KiB)
131 Downloads/Views
Resource2_Field.jpg
Resource2_Field.jpg
(132.44 KiB)
132 Downloads/Views
FormView.jpg
FormView.jpg
(59.86 KiB)
128 Downloads/Views
healyhatman 9
February 04 2020, 21:27 #391037
 Answer
You have your text fields named incorrectly it looks like. They should be of the form group[number][name]. So for example your subject field should be called
groupname[{var:table1.row.data.id}][subject]
and then you loop through {data:groupname}, and the value will be retrieved in each loop from {var:loop_event_name.row.subject}
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
J
jformicola 43
February 04 2020, 22:21 #391039
That worked! Thanks so much! I'll make a donation
One further question - in my haste to get this to work, I ended up destroying the work I did on the "new" button (it was working at one point). Do I have to create another set of fields to use in the "Form Area" section that the "new" button event points to?
Thanks again!
J
jformicola 43
February 05 2020, 15:23 #391046
I ended up adding new text fields for the "New" button and everything seems to be working. Thanks again for your help!
g'day mate!