Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Change a text field to a dropdown on the update page

Change a text field to a dropdown on the update page

Thread began 12/10/2019 2:34 pm by Gizza372666 | Last modified 12/10/2019 7:08 pm by Ray Borduin | 284 views | 3 replies |

12/10/2019 2:34 pm | #1 Gizza372666

Change a text field to a dropdown on the update page

Hi!
Can you please help me?
I want to change the following text field to a dropdown in the update page:
The db needs to store and retrieve integer values 1 or 0.
When is 0 text on the dropdown to be: 'Customer Request Completed'
When the value is: 1 the dropdown to be: 'Active Customer Request'

Here is the section which I will need to change:
========================

<label for="UserEmailVerified" class="sublabel" >Requeste Activated:</label>
<input id="Paula" name="Paula" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("tblMembersupdate","Paula"):"".$WADAtblMembers_update->getColumnVal("Paula") ."")); ?>" class="formTextfield_Large" tabindex="23" title="Please enter a value.">

=============================
I hope it make sense what I'm trying to do.
Thanks

12/10/2019 3:40 pm | #2 Ray BorduinWebAssist

php:

<label for="UserEmailVerified" class="sublabel" >Requeste Activated:</label>

<select id="Paula" name="Paula">

  <option value="0" <?php echo((isset($_GET["invalid"])?ValidatedField("tblMembersupdate","Paula"):"".$WADAtblMembers_update->getColumnVal("Paula") ."") == 0?"selected":""); ?>>Customer Request Completed</option>

  <option value="1" <?php echo((isset($_GET["invalid"])?ValidatedField("tblMembersupdate","Paula"):"".$WADAtblMembers_update->getColumnVal("Paula") ."") == 1?"selected":""); ?>>Active Customer Request</option>

</select>

Did this help? Tips are appreciated...

12/10/2019 4:35 pm | #3 Gizza372666

Thanks!

You are a star!!!
How can I change the font colour?
I want the following to be red:
Active Customer Request
Thats the final question for this issue.
Thanks in advance.

12/10/2019 7:08 pm | #4 Ray BorduinWebAssist

You should be able to add a style tag to the option... it may not work on all browsers:

<option style="color:red" value="1" <?php echo((isset($_GET["invalid"])?ValidatedField("tblMembersupdate","Paula"):"".$WADAtblMembers_update->getColumnVal("Paula") ."") == 1?"selected":""); ?>>Active Customer Request</option>

Did this help? Tips are appreciated...

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.