I managed to get it going, thanks for highlighting that mistake
*form=SQLFORM(db.store_registration)if form.process().accepted:
response.flash=T('Details Registered')student_id =
form.vars.id_number# Redirect to payments view with student's name
as parameterredirect(URL('default', 'payments', vars={'student_id':
student_id}))return locals()def payments():student_id =
request.vars.student_id# Load student's information from the database
student = db(db.store_registration.id_number ==
student_id).select().first()if student is None:raise
HTTP(404, "Student not found")*
*db.payments.student.default=student.idform = SQLFORM(db.payments)
#form.vars.student = student.id # Set the student reference in the
payment formif form.process().accepted:response.flash =
T('Payment details submitted')redirect(URL('default',
'student_registration'))return locals()*
On Sunday, August 20, 2023 at 3:25:43 PM UTC+2 Clemens wrote:
> Hi,
>
> could it be that the problem is, you're passing the students name
> (vars={'student_name': student_name}) but then reference
> to form.vars.student as student.id?
>
> Regards
>
> On Sunday, August 20, 2023 at 1:04:51 PM UTC+2 mostwanted wrote:
>
>> I have a student registration form that immediately after registering a
>> student I want to use those details in another form, a payments form to
>> enter that student's payment status but my code keeps returning none like
>> student is not available, I am doing something wrong here please assist me
>> figure it out or show me a better way of doing achieving the same logic:
>>
>> *CODE:*
>> *def registration():*
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *form=SQLFORM(db.store_registration)if form.process().accepted:
>> response.flash=T('Details Registered')student_name =
>> "{form.vars.first_name} {form.vars.last_name}"# Redirect to
>> payments view with student's name as parameter
>> redirect(URL('default', 'payments', vars={'student_name': student_name}))
>> return locals()def payments():student_name =
>> request.vars.student_name# Loading student's information from the
>> databasestudent = db(db.store_registration.first_name + ' ' +
>> db.store_registration.last_name == student_name).select().first()if
>> student is None:raise HTTP(404, "Student not found")*
>>
>> * form.vars.student = student.id # Set the student
>> reference in the payment form*
>>
>>
>> *form = SQLFORM(db.payments)if form.process().accepted:
>> response.flash = T('Payment details submitted')return locals()*
>>
>> Regards
>>
>
--
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/9525a8bb-682d-4f8a-adb1-7685ee81d26bn%40googlegroups.com.
