Forums

Hi,

this is my form code:

<div class="ccms_form_element cfdiv_custom" id="container_div_1" style=""><font color="#2d619b"><b>INSERT VALUES</B></font><br/><br/><div class="clear"></div><div id="error-message-input_custom_1"></div></div>
<div class="ccms_form_element cfdiv_custom multiline_start" id="USD_container_div" style="width: 100px;margin-top: 30px">
<img src="images/tabella/FlagofUnitedStates.png"><font color="#2d619b"><b>100 USD</B></font>
<div class="clear"></div></div>
<div class="ccms_form_element cfdiv_text label_over multiline_add" id="USD_buy_container_div" style=""><label><font color="#2d619b"><b>BUY</B></font></label><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="USD_buy" />
<div class="clear"></div><div id="error-message-USD_buy"></div></div>
<div class="ccms_form_element cfdiv_text label_over multiline_add" id="USD_sell_container_div" style=""><label><font color="#2d619b"><b>SELL</B></font></label><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="USD_sell" />
<div class="clear"></div><div id="error-message-USD_sell"></div></div>
<div class="ccms_form_element cfdiv_custom multiline_start" id="GBP_container_div" style="width: 100px;">
<img src="images/tabella/FlagofUnitedKingdom.png"><font color="#2d619b"><b>100 GBP</B></font>
<div class="clear"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="GBP_buy_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="GBP_buy" />
<div class="clear"></div><div id="error-message-GBP_buy"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="GBP_sell_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="GBP_sell" />
<div class="clear"></div><div id="error-message-GBP_sell"></div></div>
<div class="ccms_form_element cfdiv_custom multiline_start" id="CAD_container_div" style="width: 100px;">
<img src="images/tabella/FlagofCanada.png"><font color="#2d619b"><b>100 CAD</B></font>
<div class="clear"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="CAD_buy_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="CAD_buy" />
<div class="clear"></div><div id="error-message-CAD_buy"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="CAD_sell_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="CAD_sell" />
<div class="clear"></div><div id="error-message-CAD_sell"></div></div>
<div class="ccms_form_element cfdiv_custom multiline_start" id="AUD_container_div" style="width: 100px;">
<img src="images/tabella/FlagofAustralia.png"><font color="#2d619b"><b>100 AUD</B></font>
<div class="clear"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="AUD_buy_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="AUD_buy" />
<div class="clear"></div><div id="error-message-AUD_buy"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="AUD_sell_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="AUD_sell" />
<div class="clear"></div><div id="error-message-AUD_sell"></div></div>
<div class="ccms_form_element cfdiv_custom multiline_start" id="RUB_container_div" style="width: 100px;">
<img src="images/tabella/FlagofRussia.png"><font color="#2d619b"><b>1000 RUB</B></font>
<div class="clear"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="RUB_buy_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="RUB_buy" />
<div class="clear"></div><div id="error-message-RUB_buy"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="RUB_sell_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="RUB_sell" />
<div class="clear"></div><div id="error-message-RUB_sell"></div></div>
<div class="ccms_form_element cfdiv_custom multiline_start" id="CHF_container_div" style="width: 100px;">
<img src="images/tabella/FlagofSwitzerland.png"><font color="#2d619b"><b>100 CHF</B></font>
<div class="clear"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="CHF_buy_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="CHF_buy" />
<div class="clear"></div><div id="error-message-CHF_buy"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="CHF_sell_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="CHF_sell" />
<div class="clear"></div><div id="error-message-CHF_sell"></div></div>
<div class="ccms_form_element cfdiv_custom multiline_start" id="JPY_container_div" style="width: 100px;">
<img src="images/tabella/FlagofJapan.png"><font color="#2d619b"><b>10000 JPY</B></font>
<div class="clear"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="JPY_buy_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="JPY_buy" />
<div class="clear"></div><div id="error-message-JPY_buy"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="JPY_sell_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="JPY_sell" />
<div class="clear"></div><div id="error-message-JPY_sell"></div></div>
<div class="ccms_form_element cfdiv_custom multiline_start" id="CNY_container_div" style="width: 100px;">
<img src="images/tabella/FlagofChina.png"><font color="#2d619b"><b>100 CNY</B></font>
<div class="clear"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="CNY_buy_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="CNY_buy" />
<div class="clear"></div><div id="error-message-CNY_buy"></div></div>
<div class="ccms_form_element cfdiv_text multiline_add" id="CNY_sell_container_div" style=""><input maxlength="8" size="0" class=" validate['number']" title="" type="text" value="" name="CNY_sell" />
<div class="clear"></div><div id="error-message-CNY_sell"></div></div>
<div class="ccms_form_element cfdiv_submit" id="input_submit_71_container_div" style="text-align:left"><input name="input_submit_7" class="" value="Salva" type="submit" />
 <input type='reset' name='reset' value='Pulisci' class='' /><div class="clear"></div><div id="error-message-input_submit_7"></div></div><div class="ccms_form_element cfdiv_empty" id="empty_container_div" style=""><div class="clear"></div><div id="error-message-empty"></div></div>
<input type="hidden" value="1" name="cf_id" />
<div class="ccms_form_element cfdiv_empty" id="empty_container_div" style=""><div class="clear"></div><div id="error-message-empty"></div></div>

In this way, I have to insert all values every time, even when they don't change.

Is it possible to leave some empty field and no overwriting it on DB?

Thanks

Hi Belii,

There are two ways to do this.

a) load the data from the DB into the form. then when it saves it will save all of the data correctly;

OR

b) use a Custom Code action to check the submitted data and unset any empty values so that they are not saved.

<?php
if ( isset($form->data['CNY_sell']) && !$form->data['CNY_sell'] ) {
  unset($form->data['CNY_sell']);
}
?>

Bob

Hi Bob,

honestly I'd prefer the first way, but in this faq (http://www.chronoengine.com/faqs/61-cfv4/cfv4-tutorials/2698-how-to-load-one-row-from-a-db-table-into-your-form.html) the loading is not automatic when I open the form's page: I have to add in my url &token=(cf_uid value).

How can I make this in automatic?

Thank you

One of my favourites adage: "Trying (and getting wrong)...you learn!"

In ADVANCED window (step no.7) I added cf_uid=my_value in WHERE statement.

Now it works right!

Have a nice day😉