Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Relational table insert, only if one of checkbox is ticked

Relational table insert, only if one of checkbox is ticked

Thread began 5/18/2017 2:09 pm by Kumel | Last modified 5/22/2017 1:23 pm by Ray Borduin | 1227 views | 6 replies |

5/18/2017 2:09 pm | #1 Kumel

Relational table insert, only if one of checkbox is ticked

i have added relational table behaviour to a page. On clicking submit all records are submitted irrespective of certain selection ie. radio boxes.

So i want those records to be added when one of the radio is ticked.
Screenshot added.

So whenever any radio is ticked for each row then it must enter data.
So if i have ticked only one radio then 1 record must be entered not the rest

5/18/2017 3:55 pm | #2 Ray BorduinWebAssist

Can I see a copy of the page? It should be possible, but I'd have to look at how your form elements are named and how you have it applied to comment on what to change.

Did this help? Tips are appreciated...

5/20/2017 3:33 pm | #3 Kumel

file attached..

1386 line:

<p>
      <label>
        <input <?php if (!(strcmp($row_QuestionTextArea['SAType'],"C"))) {echo "checked=\"checked\"";} ?> type="radio" name="SAType_<?php echo $RepeatSelectionCounter_4; ?>" value="C" id="SAType_0_<?php echo $RepeatSelectionCounter_4; ?>" />
        Clear</label>
      
      <label>
        <input <?php if (!(strcmp($row_QuestionTextArea['SAType'],"P"))) {echo "checked=\"checked\"";} ?> type="radio" name="SAType_<?php echo $RepeatSelectionCounter_4; ?>" value="P" id="SAType_1_<?php echo $RepeatSelectionCounter_4; ?>" />
        Pending</label>
      
      
      
      <label>
        <input <?php if (!(strcmp($row_QuestionTextArea['SAType'],"D"))) {echo "checked=\"checked\"";} ?> type="radio" name="SAType_<?php echo $RepeatSelectionCounter_4; ?>" value="D" id="SAType_2_<?php echo $RepeatSelectionCounter_4; ?>" />
        Deviate</label>


    </p>

Its related relational codes : Line 200:

// WA DataAssist Manage Relational Table 2
if (isset($_POST["submit"]) || isset($_POST["submit_x"])) // Trigger
{
  $WA_arrayOrFieldList = 1;
  $WA_joinLoopedField = "SAQASID";
  $WA_loopedField = "WADA_RepeatID_QASID";
..
..
...

5/22/2017 9:27 am | #4 Ray BorduinWebAssist

I think you can probably manually add some code to do this on line 237.

I think you can update it to:
if (WA_AB_checkLoopedFieldsNotBlank(array("SAType"), $WA_mrtLoopCounter) && WA_AB_checkLoopedFieldsNotBlank(array($WA_joinLoopedField), $WA_mrtLoopCounter) && WA_AB_getLoopedFieldValue($WA_loopedField, $WA_mrtLoopCounter) == WA_AB_getLoopedFieldValue($WA_joinLoopedField, $WA_mrtLoopCounter)) {

Did this help? Tips are appreciated...

5/22/2017 11:54 am | #5 Kumel

Parse error: syntax error, unexpected $end in /home/content/39/10368039/html/webgen/infideal/admin/be-application-details.php on line 1869...

I had made some changes in page all this time so lines might have changed.

My new file is attached here. Can you refer to me with this?

5/22/2017 1:04 pm | #6 Ray BorduinWebAssist

It looks like you updated code on line 1388 when I said to update line 237.

Change that line back to what it was.

You should just be updating line 237 from:

if (WA_AB_checkLoopedFieldsNotBlank(array($WA_joinLoopedField), $WA_mrtLoopCounter) && WA_AB_getLoopedFieldValue($WA_loopedField, $WA_mrtLoopCounter) == WA_AB_getLoopedFieldValue($WA_joinLoopedField, $WA_mrtLoopCounter)) {

to:

if (WA_AB_checkLoopedFieldsNotBlank(array("SAType"), $WA_mrtLoopCounter) && WA_AB_checkLoopedFieldsNotBlank(array($WA_joinLoopedField), $WA_mrtLoopCounter) && WA_AB_getLoopedFieldValue($WA_loopedField, $WA_mrtLoopCounter) == WA_AB_getLoopedFieldValue($WA_joinLoopedField, $WA_mrtLoopCounter)) {

Did this help? Tips are appreciated...

5/22/2017 1:11 pm | #7 Kumel

it works. thanks a lot. You saved me from mess up!

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.