I think we also need to see the code that creates and processes the form.
On Saturday, June 22, 2013 4:53:51 PM UTC-4, lesssugar wrote:
>
> Anthony, here's more info.
>
> In my form, you need to choose a department to generate respective list of
> ranks. The tables involved:
>
> db.define_table('department',
> Field('name', length = 30),
> format=lambda r: r.name
> )
>
> db.define_table('rank',
> Field('department_id', db.department),
> Field('name', length = 50),
> format=lambda r: r.name
> )
>
>
> I reference the tables in my user profile table (user has i.a. department
> and rank).
>
> When user wants to insert data, the view generates a custom crud form
> (below) -- nothing fancy here. However, I need to modify the piece of code
> which deals with *rank *- to auto-populate it based on department chosen:
>
> {{=form.custom.begin}}
> {{=form.custom.widget.department}}
> {{=form.custom.widget.rank.label}}
> <div class="w2p_fw">
> {{if request.vars.department:}}
> <select class="generic-widget" id="seafarer_experience_rank"
> name="rank">
> {{=XML(result)}}
> </select>
> {{else:}}
> {{=form.custom.widget.rank}}
> {{pass}}
> </div>
> ....
> {{=form.custom.end}}
>
> So, when user displays the form, the *department *variable is not set
> (True) yet. In that case all ranks are being displayed in the select_2
> (else: ...). Then, when user chooses an option from select_1 (department),
> jQuery change() triggers and ajax() sends department variable to *populate
> *function. The variable is used in the query (my first post) to retrieve
> ranks connected with the department chosen, and send it back to the view as
> <option></option> tags -- {{=XML(result)}}.
>
> As I said - it works for inserting data. Does not when I try to update.
>
> I use the same HTML + web2py code as in the form code above for both
> insert and update forms.
>
> If I'm still being not clear enough, let me know. And thanks.
>
>
> On Saturday, June 22, 2013 8:04:39 PM UTC+2, Anthony wrote:
>>
>> Sorry, it wasn't clear that it was failing upon change of select_1. It
>> might help to show more of the code that creates and displays the form, as
>> it is not quite clear how everything is working. In particular, I don't
>> quite get what that view code is doing and where it is used.
>>
>> Anthony
>>
>> On Saturday, June 22, 2013 1:55:18 PM UTC-4, lesssugar wrote:
>>>
>>> Yes, of course you're right, I guess I wasn't clear enough. The real
>>> problem is this: what if a user needs to change the value of select_1 in
>>> order to update their data? Then, depending on what they choose, select_2
>>> should still be auto-populated.
>>>
>>> I don't get why code which works for insert form fails when it comes to
>>> update. Can it be connected to the fact that the update form shows specific
>>> value of select_1? Not sure. But jquery change() should anyway spot the
>>> select change action and trigger ajax().
>>>
>>> On Saturday, June 22, 2013 7:39:05 PM UTC+2, Anthony wrote:
>>>>
>>>> $('#select_1').change(function()
>>>>
>>>> You're using a "change" event handler, so it will only fire when the
>>>> value of select_1 is changed. When the update form is first loaded, the
>>>> existing record's value for select_1 is shown, but there is no change
>>>> event
>>>> to trigger the retrieval of the select_2 values.
>>>>
>>>> Note, for an update form, it should be possible to populate select_2 on
>>>> the server rather than via ajax, since you already have the value of
>>>> select_1.
>>>>
>>>> Anthony
>>>>
>>>> On Saturday, June 22, 2013 1:29:02 PM UTC-4, lesssugar wrote:
>>>>>
>>>>> I have 2 select boxes. I managed to auto-populate second select box
>>>>> based on value from the first one. All of the code below works just fine
>>>>> when I create new record - second select is being populated. However,
>>>>> when
>>>>> I try to update the same record, select_2 does not get populated, as if
>>>>> the
>>>>> *department* variable never reached the *populate* function. As a
>>>>> result, there's a view rendered within select_2 instead of
>>>>> <option></option> elements. This occurs only in the update form.
>>>>>
>>>>> The script passing *department *variable from select_1:
>>>>>
>>>>> <script>
>>>>> $('#select_1').change(function() {
>>>>> ajax('populate', ['department'], 'select_2');
>>>>> });
>>>>> </script>
>>>>>
>>>>> *populate *function which uses "department" var to get respective
>>>>> data:
>>>>>
>>>>> def populate():
>>>>>
>>>>> ranks = db(db.rank.department_id ==
>>>>> request.vars.department).select(db.rank.id, db.rank.name, orderby=
>>>>> db.rank.name)
>>>>>
>>>>> result = ""
>>>>>
>>>>> for r in ranks:
>>>>> result += "<option value='" + str(r.id) + "'>" + r.name +
>>>>> "</option>"
>>>>>
>>>>> return XML(result)
>>>>>
>>>>> view:
>>>>>
>>>>> <div class="w2p_fw">
>>>>> {{if request.vars.department:}}
>>>>> <select class="generic-widget" id="seafarer_experience_rank"
>>>>> name="rank">
>>>>> {{=XML(result)}}
>>>>> </select>
>>>>> {{else:}}
>>>>> {{=form.custom.widget.rank}}
>>>>> {{pass}}
>>>>> </div>
>>>>>
>>>>>
>>>>>
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
