I also use it to use one form for each staff member contact email.  When someone clicks on the "contact this person" button on their staff listing, I pass their employee number to the form which can be used in the Machform notification logic to send the email to that person.

Maybe this will help someone out there!

I have been wishing for a forms plugin for CMSB like Machform.  It would be a welcome addition to the add-ons!

Thanks for your input!

I attached a couple of screenshots.

If you don't get it, it's probably a good thing!  LOL

This looks very promising!

In the locations table list, Get options from database (advanced)

Section Tablename -states

Use this field for option values - abbreviation

Use this field for option labels - name

I tried to upload a screenshot but something is wrong.  It refuses to accept the file. 

I am late for an appointment and can continue this later if you need more assistance.  I could send you the states table schema and data but the file upload is not working. LOL

SELECT num, CONCAT(city. ', ',abbreviation, ' - ', address)
  FROM `<?php echo $TABLE_PREFIX ?>locations`
  ORDER BY 'abbreviation, city'


Just a thought.

First, you need to change the location lookup field List Options to Get Options fro MySQL query (advanced)  Then enter the following in the query. (I am assuming that the table and field names match your database)

SELECT num, CONCAT(name, ' - ',address)
  FROM `<?php echo $TABLE_PREFIX ?>locations`

This will concatenate the name, a spaced hyphen and the address in the lookup dropdown list.  I attached a screenshot.

As for default check boxes ... very simple .. set default to checked.  See attached screenshot.

Hope this helps!

Here is where I got the solution when I needed it

http://www.interactivetools.com/forum/forum-posts.php?postNum=2233847#post2233847

You will just need to concatenate the city and address or whatever to suit your needs.

<img alt="<?php echo $image['info1'] ?>" src="<?php echo $image['thumbUrlPath'];?>" /> 

If the rendering script does not handle a blank alt attribute (alt=""), then you may have to conditionally display the alt attribute only if it contains data.

<?php if($image['info1']): ?>
  <img alt="<?php echo $image['info1'] ?>" src="<?php echo $image['thumbUrlPath'];?>" />
<?php else: ?>
  <img src="<?php echo $image['thumbUrlPath'];?>" />
<?php endif ?>


Hope this works for you!

I sent you an email on this ... hope I had the right address.

You will just need to be aware of the modified editor when upgrading that it doesn't get overwritten.

Have a great day!

Paragraphs are entered as Text Blocks, Page Headings as H1 Heading, Sub headings as H2 Heading, Sliders as an upload array, Photo Gallery as an upload array etc   The rendering code for each element type is stored in Include files and called in a page rendering loop that accesses the related element table.

I found that modifying the WYSIWYG editor causes so many problems that it was not worth the effort.  Furthermore, it inspired me to create a better mousetrap.

See attached screenshot.

  <?php foreach ($categoryRecords as $categoryRecord): ?>
    <?php $aClass = 'indentclass' // Default to indented class ?>
      <?php if ($categoryRecord['depth'] == 0): // if this is top level ?>
        <?php $aClass = 'boldclass' // Apply bold unendented class ?>
      <?php endif ?>    
    ?>
    <li class = $aClass>
      <!-- Put your link code here -->
    </li>
  <?php endforeach ?>



If you allow more levels, the code gets a bit more complex.  I purchased the Instant Website template some time ago and I have used the code for the accordion menu and modified it to suit different applications.

I hope this points you in the right direction.

<?php // load the top points records assuming you only want the top leader
  list($houseRecords, $houseMetaData) = getRecords(array(
    'tableName'   => 'house', // or whatever the table name is
        'orderBy' => 'points+0 DESC' // bring highest points to top   
        'limit'       => '1',
    'allowSearch' => false,
  ));
  $topRecord = @$houseRecords[0]; // get first record only
?>
<div class="some-wrapper">
  The leaders are <?php echo $topRecord['name'] ?> with <?php echo $topRecord['name'] ?> points.
</div>