Hi Dave. I have struggled with this for long but never got a good answer. Do you have an example where in the view page: {{=form}} in the primary page is used but the page is not refreshing
On Sun, 26 May 2019, 11:16 Dave S <snidely....@gmail.com> wrote: > > > On Saturday, May 25, 2019 at 6:59:44 PM UTC-7, Cristina Sig wrote: >> >> Hello everyone, >> >> I have a table filled with records from a database. >> >> Also, I have a button to add a new record. Once I enter all the data for >> the new record and press the submit button, I want to update the content of >> the table without reloading the page (without F5). >> >> I'm struggling to find a solution to this so any suggestions would be >> welcomed. >> >> >> > Sounds like a job for jQuery or for the LOAD() helper . I use one to have > a secondary form on the same page as another; the DIV used by the LOAD gets > refreshed when I submit the secondayr form, but the page doesn't relaod. > > <URL:https://web2py.com/books/default/chapter/29/11/jquery-and-ajax#> > <URL: > https://web2py.com/books/default/chapter/29/12/components-and-plugins#Components-LOAD-and-Ajax > > > > Good luck! > > /dps > > [original post continues] > > Database >> >> db.define_table('Student', >> Field('name', 'string', label='Name'), >> Field('last_Name', 'string', label='Last Name'), >> Field('age', 'integer', label='Age'), >> Field('nationality', 'string', label='Nationality'), >> ) >> >> >> Controller (Tools.py) >> >> def studentNew(): >> formStudent=crud.create(db.Student) >> if formStudent.accepted: >> response.js = '(function($) >> {$("#myModalADD").modal("hide");}(jQuery));' //hide modal after press >> submit button >> response.flash = 'Record added successfully!' //displays message >> after press submit >> return dict(formStudent=formStudent) >> >> >> View >> >> <script> >> $(document).ready(function(){ >> tabla= $('#table').DataTable( { >> 'scrollX': true, >> 'responsive':true, >> 'sRowSelect': "single", >> }); >> </script> >> >> <div id="some_btn"><a class="btn btn-success btn-mini" >> data-target="#myModalADD" data-toggle="modal" >> data-backdrop="static" data-keyboard="false">Add New Student</a></div> >> >> <table id="table" class="tablaC table-striped hover cell-border" >> cellspacing="0" width="100%" > >> <thead> >> <tr> >> <th>Name</th> >> <th>Last Name</th> >> <th>Age</th> >> <th>Nationality</th> >> </tr> >> </thead> >> <tbody> >> {{for student in formListar:}} >> <tr> >> <td>{{=student.Student.name}}</td> >> <td>{{=student.Student.last_name}}</td> >> <td>{{=student.Student.age}}</td> >> <td>{{=student.Student.nationality}}</td> >> </tr> >> {{pass}} >> </tbody> >> </table> >> >> <div id="myModalADD" class="modal fade"> //Modal that contains the Add New >> Student Form and Submit button >> <div class="modal-dialog" role="document"> >> <div class="modal-content"> >> <div class="modal-header"> >> <h4 class="modal-title">Add New Student</h4> >> </div> >> <div class="modal-body"> {{=LOAD('Tools','studentNew', ajax=True, >> ajax_trap=True)}}</div> >> <div class="modal-footer"> >> <div class="col-md-6 col-md-offset-3 "> >> <button type="button" id="cancelar" class="btn btn-secondary" >> data-dismiss="modal">Cancel</button> >> </div> >> </div> >> </div> >> </div> >> </div> >> >> >> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to web2py+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/web2py/aa06f194-1787-4551-abc0-204e03b15146%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/aa06f194-1787-4551-abc0-204e03b15146%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAAcHJF-ozX%2BJ1i27vZ5u9DhsW6c7XFM%3DiBwcZpEZWTiHakfD7Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.