help regarding creating a table in database from text fields

[siva143viji]

hi

I need to create 12 text fields in the create oppurtunities page and store the values in the database. I have a drop down of the payment break up.It has values of the number of months

'payment_breakup_dom' =>
array (
'1' => '1-month',
'3' => '3-month',
'6' => '6-month',
'12' => '12-month',
'24' => '24-month',
'36' => '36-month',
),

i need to create text fields according to the value selected. for example if 3-months is selected. Then 3 text fields should appear. I know i can do this using javascript but i dont know how to create fields in the module and then make it hidden. Also how to make it to be stored seperate table and not in the opportunities table.I need to create a seperate table where i can enter the value entered in eact text box. I have tried to be clear in explaining this.If this explanation is not clear please let me know, i have to form 12 text fields and create a table in the database so that i can save the data in it

thank you for the help in advance

Siva

[tbivans]

Hi Siva,

I'm not sure if I can help you with this or not. I see that it's been awhile since your original post. Do you still need help with this?

I'm not clear on exactly what is needed. You said:

for example if 3-months is selected. Then 3 text fields should appear.

But when the user chooses 36 months, do you need 36 text fields! I would think not, but that seems to be the implication.

I could probably help you figure out the JavaScript side of it, but I'm not sure if I can get the JavaScript INTO Sugar. In fact I'm waiting for some help in that area myself. The forums have been less helpful lately, since right before the rollout of 4.5.1. Don't know if the Sugar Tean is too busy or what.

But anyway, if you can clarify what you are trying to do, I MIGHT be able to help you out.

Peace,


Tim