Thank you Anthony. I got your point.
On Friday, 13 November 2015 20:13:32 UTC+5, Anthony wrote:
>
> web2py does not provide an out-of-the-box solution for this case. If you
> create a model like this:
>
> db.define_table('config2', ...)
>
> db.define_table('phone',
> Field('config2', 'reference config2'),
> Field('service_type', 'string'),
> Field('phone_number', 'string'))
>
> Then you could use SQLFORM.smartgrid to display/navigate the two tables
> and add records to each. However, you won't get a single view or form
> showing both the config2 fields and the phone fields at the same time.
> Otherwise, you will have to create a custom form to handle the input, and
> then write some custom code on the back end to handle inserting records
> into the two tables.
>
> Note, as an alternative to the two-table model above, you could include a
> single "phone" field in config2 with a "json" type, storing the list of
> phones as JSON. This would still require custom code to handle the form UI
> and post processing before insert.
>
> Anthony
>
> On Friday, November 13, 2015 at 2:15:05 AM UTC-5, at wrote:
>>
>>
>> Initially I was thinking the same, but results are not as desired:
>>
>>
>> db.define_table('phone',
>> Field('service_type', 'string'),
>> Field('phone_number', 'string'))
>>
>> db.define_table('config2',
>> Field('cell_phones', 'list:reference phone'), label=T('Dispatchers
>> Cell Phone #s'))
>>
>> Thanks,
>> AT
>>
>> On Friday, 13 November 2015 11:09:02 UTC+5, 黄祥 wrote:
>>>
>>> sorry, perhaps you can use list:reference type of field for that.
>>> - create table that store cell phone number and it's service type
>>> - then define config table that have list:reference to the table that
>>> store cell phone number and service type.
>>> - another thing is if you want to add new cell phone number and service
>>> type that not recorded yet and want to remain in that page form, consider
>>> use the modal that have form to input new data cell phone number and
>>> service type
>>>
>>> best regards,
>>> stifan
>>>
>>> On Friday, November 13, 2015 at 12:36:54 PM UTC+7, at wrote:
>>>>
>>>> Hi Stifan,
>>>>
>>>> Thank you for your prompt reply. This will not give the desired result.
>>>> After your suggested change, I get:
>>>>
>>>>
>>>> What I need is service-type and phone-number side-by-side, so when I
>>>> add a record it should add one service-name and one corresponding phone
>>>> number.
>>>>
>>>> Best Regards,
>>>> AT
>>>>
>>>> On Friday, 13 November 2015 09:56:32 UTC+5, 黄祥 wrote:
>>>>>
>>>>> pardon me, not sure what do you mean with free-text field? is it same
>>>>> like cello phone type of field (list:string)
>>>>> e.g.
>>>>> db.define_table('config',
>>>>> Field('cell_phones', 'list:string', label=T('Dispatchers Cell
>>>>> Phone #s') ),
>>>>> Field('service_provider_name', 'list:string', label=T('Service
>>>>> Provider Name') )
>>>>> )
>>>>>
>>>>> best regards,
>>>>> stifan
>>>>>
>>>>
--
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.
For more options, visit https://groups.google.com/d/optout.
