Jump to content


  • Content Count

  • Joined

  • Last visited

Everything posted by Scott

  1. See below. I trigger a record to be inserted into the renewedlog_invoice when a record is tagged as renewed in the insurancehouse_members_db table. If the record is updated twice two entry are made in the Renewedlog_Invoice Table. Rather than a second record being inserted into the Renewedlog_Invoice Table I would prefer it update the first record that was created when it first triggered. I think similar Place works issue above your Have you tried the comparison type, "NOT IN"? May fix this for me??? Many Thanks for your help
  2. Glitch.... I have the same issue as Placeworks....Can you send a screenshot of your trigger so I can do a similar comparison......Can not open the file in the above message..... Thanks
  3. Thanks for the response BaySunshine....I have the trigger working whereby I insert records into a different table and then bring them back into the original table with the trigger on it....However the email section of the trigger is not working???? Thanks for your help.... See below screen shot of the trigger...
  4. I have a table who's population are a number of memberships with a "Start_Date" and "End_Date". I would like to run a trigger that renews the memberships "End_Date " with todays date using a timestamp when the membership field "renew" is set and updated to "YES". Following this an automated email is triggered to email the members "Email_Address" when the renew is set to "Yes" with the new "End_Date". I have tried doing this with a trigger in the same table but have a level 2 error and understand that update can be triggered in the same table. Does anyone have a work around
  5. On a Submission form I would like a button to validate all fields and records and run my imbedded HTML in my footer, similar to the checking of fields when the submit button is executed. When this checking button is executed and successful a confirmation of all details appears and the final execution button appears with the data and a submit button can be executed and insert the record in the table. The reasoning for this is I have some front of sales people who may at time enter incorrect information and I want them to check their entries prior to a final submission execution to the
  6. I have a field in a dataform. [@field:Rego] If a person enters "UNREG" into this filed I would like the field to populate with the [@field:AutoNumber] field on hitting the submission button. Any ideas???
  7. We are a membership based company that distributes via a number of third party stores. I have created a Capsio table that holds memberships for our business. The memberships are entered into the table via a form by each store we have. When submitted the store details are auto populated including email address from another table. On a monthly basis I would like to email a statement to each store for the memberships they have created. and once sent via email I will tag the records using another table field that they have been sent. I have not come across anything in capsio that wi
  • Create New...