provided by Star2Billing S.L.

I've searched about everywhere I can think of and I can't seem to find the answer.

In the FormHandler class under function AddEditElement(), is there a more detailed usage format for field 15 (SQL CUSTOM QUERY)? I would like to figure out how to have a form update a custom table not matching the associated A2B_entity. From what I can gather, this would be done using the SQL CUSTOM QUERY field, but I cannot find a defined format for this query. It does not appear to be standard SQL from what I've seen in other entities that use it.

The only info I see is in {Trunk}/A2Billing_UI/lib/Form/Class.FormHandler.inc.php:801 as follows:

Any input would be much appreciated!

Thanks.

Hello Percivi,

What form are you trying to customize? It might be better for you to redo the form using conventional means and handle the form processing yourself. I would be really surprise if the FormHandler let you easily do what you are trying to do.

Cheers

Thanks for the response.

I am adding an AddEditElement to the FG_var_card.inc file, and that works fine. However, I want this one html field to update a database field for a separate table from 'cc_card'. For example, an AddEditElement that inserts its input value into 'customfield' of the 'cc_custom' table versus inserting it into 'definedfield' of the 'cc_card' table.

This way when someone creates a new customer using the create customer page, they are presented a new option that puts its value in a separate table from 'cc_card'. It would appear that this is already being done in this same form for the CALLERID field, but I cannot figure out the format of the php function parameter.

The code for the CALLERID field is as follows:
As you can see, it's updating the 'cc_callerid' table instead of the 'cc_card' table. This is exactly what I want to do but for a different table.

Thanks in advance for any help