My problem is currently this: I am using sendMail to send an email confirmation on the insert of a new Order, and using »indoogrid:idvalue« as the Order Confirmation ID. There is a drop-down on the order form to select an inspection to add to the order, and a trigger will fire to create a record in a separate table for this order.
When the trigger fires, and the insert occurs on a different table, the »indoogrid:idvalue« returns the new record ID of the other table instead of the source table!
I need AMtblOrder.»indoogrid:idvalue«, but I am getting AMtblInspections.»indoogrid:idvalue« instead in the email.
Running IndooGrid 2.06.01
Behind the scenes in SQL, the following trigger occurs on Insert:
Alter Trigger trig_NewPublicOrder on R1389_dbadmin.AMtblOrder
for insert as
If isnull((Select PublicInspIDChoice1 From inserted), '') <> '' and (Select PublicInspIDChoice1 From inserted) <> 18
Begin
INSERT INTO R1389_dbadmin.AMtblInspections (OrderID, InspType, InspDueDate)
Select ID, PublicInspIDChoice1, PublicDueDate1
From inserted
End
------------------------- Here is the email confirmation code placed in the module header text:
»sendMail: user@domain.com||New Inspection Order|»gridEditColumn:PropAddress«|
<html><body>
<p>Thank you for placing this order online!</p>
<p>Your order confirmation number is: <strong>»indoogrid:idvalue«</strong></p>
<table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr>
<td><table width="100%" cellspacing="0" border="0" cellpadding="1" >
<tr>
<td><table width="100%" cellspacing="0" border="1" cellpadding="1" >
<tr>
<td colspan="2" align="center">Property Information</td>
</tr>
<tr>
<td width="10%" >Address - </td>
<td width="28%" >»gridEditColumn:PropAddress«</td>
</tr>
<tr>
<td >City - </td>
<td >»gridEditColumn:PropCity«</td>
</tr>
<tr>
<td >State - </td>
<td >»gridEditColumn:PropState«</td>
</tr>
<tr>
<td >Zip - </td>
<td >»gridEditColumn:PropZip«</td>
</tr>
<tr>
<td >County - </td>
<td >»gridEditColumn:PropCounty«</td>
</tr>
<tr>
<td >Development - </td>
<td >»gridEditColumn:PropDevelopment«</td>
</tr>
<tr>
<td >Property Type - </td>
<td >»gridEditColumn:PropType«</td>
</tr>
</table></td>
<td><table width="100%" cellspacing="0" border="1" cellpadding="1" >
<tr>
<td >Listing Price - </td>
<td >»gridEditColumn:PropListingPrice«</td>
</tr>
<tr>
<td >Age in Years - </td>
<td >»gridEditColumn:PropAge«</td>
</tr>
<tr>
<td >Occupied - </td>
<td >»gridEditColumn:PropOccupancy«</td>
</tr>
<tr>
<td >Utilities On - </td>
<td >»gridEditColumn:PropUtilitiesOn«</td>
</tr>
<tr>
<td width="13%" >Lockbox-Combo - </td>
<td width="20%" >»gridEditColumn:PropLockboxCombo«</td>
</tr>
<tr>
<td >Combination - </td>
<td >»gridEditColumn:PropLockboxCombination«</td>
</tr>
<tr>
<td >Security System - </td>
<td >»gridEditColumn:PropSecuritySystem«</td>
</tr>
<tr>
<td >Foundation - </td>
<td >»gridEditColumn:PropFoundationType«</td>
</tr>
</table></td>
<td><table width="100%" cellspacing="0" border="1" cellpadding="1" >
<tr>
<td >Attic - </td>
<td >»gridEditColumn:PropAtticType«</td>
</tr>
<tr>
<td >Beds - </td>
<td >»gridEditColumn:PropBeds«</td>
</tr>
<tr>
<td >Baths - </td>
<td >»gridEditColumn:PropBaths«</td>
</tr>
<tr>
<td >Garage - </td>
<td >»gridEditColumn:PropGarageNum«</td>
</tr>
<tr>
<td >Garage Type - </td>
<td >»gridEditColumn:PropGarageType«</td>
</tr>
<tr>
<td >Add. Heater - </td>
<td >»gridEditColumn:PropAddHeater«</td>
</tr>
<tr>
<td width="14%" >Add. Electric Panel - </td>
<td width="15%" >»gridEditColumn:PropAddElec«</td>
</tr>
<tr>
<td >Add. Water Heater - </td>
<td >»gridEditColumn:PropAddWaterHeat«</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" cellspacing="0" border="0" cellpadding="1" >
<tr>
<td align="right"><span >Who is ordering this inspection - </td>
<td align="left">»gridEditColumn:PartiesOrderedBy« </td></tr>
<tr>
<td><table width="100%" cellspacing="0" border="1" cellpadding="1">
<tr>
<td colspan="2" align="center">Customer/Buyer</td>
</tr>
<tr>
<td width="9%" >Customer - </td>
<td width="26%" >»gridEditColumn:CustName«</td>
</tr>
<tr>
<td >Phone - </td>
<td >»gridEditColumn:CustPhone«</td>
</tr>
<tr>
<td >Cell - </td>
<td >»gridEditColumn:CustPhone2«</td>
</tr>
<tr>
<td >Email - </td>
<td >»gridEditColumn:CustEmail«</td>
</tr>
<tr>
<td >Attending - </td>
<td >»gridEditColumn:CustAttending«</td>
</tr>
<tr>
<td colspan="2" align="center"> </td>
</tr>
<tr>
<td colspan="2" align="center">Settlement</td>
</tr>
<tr>
<td >Settlement Date - </td>
<td >»gridEditColumn:SettlementDate«</td>
</tr>
<tr>
<td >Attorney Name - </td>
<td >»gridEditColumn:AttorneyName«</td>
</tr>
<tr>
<td >Phone - </td>
<td >»gridEditColumn:AttorneyPhone«</td>
</tr>
</table>
<br>
<br>
<br>
<br>
<br>
<br></td>
<td><table width="100%" cellspacing="0" border="1" cellpadding="1">
<tr>
<td colspan="2" align="center"> Buyers Agent </td>
</tr>
<tr>
<td width="11%" >Buyers Agent - </td>
<td width="23%" >»gridEditColumn:SellName«</td>
</tr>
<tr>
<td >Company - </td>
<td >»gridEditColumn:SellCompany«</td>
</tr>
<tr>
<td >Phone - </td>
<td >»gridEditColumn:SellPhone«</td>
</tr>
<tr>
<td >Cell - </td>
<td >»gridEditColumn:SellPhone2«</td>
</tr>
<tr>
<td >Fax - </td>
<td >»gridEditColumn:SellFax«</td>
</tr>
<tr>
<td >Email - </td>
<td >»gridEditColumn:SellEmail«</td>
</tr>
<tr>
<td >Attending - </td>
<td >»gridEditColumn:SellAttending«</td>
</tr>
<tr>
<td >Disclosure - </td>
<td >»gridEditColumn:SellDisclosure«</td>
</tr>
<tr>
<td ></td>
<td > </td>
</tr>
<tr>
<td colspan="2" align="center">Sellers Agent </td>
</tr>
<tr>
<td >Sellers Agent - </td>
<td >»gridEditColumn:ListName«</td>
</tr>
<tr>
<td >Company - </td>
<td >»gridEditColumn:ListCompany«</td>
</tr>
<tr>
<td >Phone - </td>
<td >»gridEditColumn:ListPhone«</td>
</tr>
<tr>
<td >Cell - </td>
<td >»gridEditColumn:ListPhone2«</td>
</tr>
<tr>
<td >Email - </td>
<td >»gridEditColumn:ListEmail«</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" cellspacing="0" border="0" cellpadding="1" >
<tr>
<td><table width="100%" cellspacing="0" border="1" cellpadding="1" >
<tr>
<td width="14%" >Inspections Needed <br />
</td>
<td width="19%" >Inspection Due Date</td>
</tr>
<tr>
<td >»sqlQuery:SELECT AMtblInspectionTypes.Type FROM AMtblInspectionTypes WHERE AMtblInspectionTypes.ID=»gridEditColumn:PublicInspIDChoice1««
</td>
<td >»gridEditColumn:PublicDueDate1«</td>
</tr>
<tr>
<td >»sqlQuery:SELECT AMtblInspectionTypes.Type FROM AMtblInspectionTypes WHERE AMtblInspectionTypes.ID=»gridEditColumn:PublicInspIDChoice2««</td>
<td >»gridEditColumn:PublicDueDate2«</td>
</tr>
<tr>
<td >»sqlQuery:SELECT AMtblInspectionTypes.Type FROM AMtblInspectionTypes WHERE AMtblInspectionTypes.ID=»gridEditColumn:PublicInspIDChoice3««</td>
<td >»gridEditColumn:PublicDueDate3«</td>
</tr>
<tr>
<td >»sqlQuery:SELECT AMtblInspectionTypes.Type FROM AMtblInspectionTypes WHERE AMtblInspectionTypes.ID=»gridEditColumn:PublicInspIDChoice4««</td>
<td >»gridEditColumn:PublicDueDate4«</td>
</tr>
<tr>
<td >»sqlQuery:SELECT AMtblInspectionTypes.Type FROM AMtblInspectionTypes WHERE AMtblInspectionTypes.ID=»gridEditColumn:PublicInspIDChoice5««</td>
<td >»gridEditColumn:PublicDueDate5«</td>
</tr>
<tr>
<td >»sqlQuery:SELECT AMtblInspectionTypes.Type FROM AMtblInspectionTypes WHERE AMtblInspectionTypes.ID=»gridEditColumn:PublicInspIDChoice6««</td>
<td >»gridEditColumn:PublicDueDate6«</td>
</tr>
<tr>
<td >»sqlQuery:SELECT AMtblInspectionTypes.Type FROM AMtblInspectionTypes WHERE AMtblInspectionTypes.ID=»gridEditColumn:PublicInspIDChoice7««</td>
<td >»gridEditColumn:PublicDueDate7«</td>
</tr>
</table>
<br></td>
<td><table width="100%" cellspacing="0" border="1" cellpadding="1" >
<tr>
<td colspan="2" align="center">Inspection Schedule Request</td>
</tr>
<tr>
<td width="26%" height="22" ><div align="center" >Date</td>
<td width="26%" ><div align="center" >Time</td>
</tr>
<tr>
<td >»gridEditColumn:RequestedDate«</td>
<td >»gridEditColumn:RequestedTime«</td>
</tr>
<tr>
<td >»gridEditColumn:Requested2Date«</td>
<td >»gridEditColumn:Requested2Time«</td>
</tr>
<tr>
<td >»gridEditColumn:Requested3Date«</td>
<td >»gridEditColumn:Requested3Time«</td>
</tr>
<tr>
<td > </td>
<td > </td>
</tr>
<tr>
<td >Inspector Requested? </td>
<td >»gridEditColumn:InspectorRequested«</td>
</tr>
<tr>
<td >Inspector - </td>
<td >»sqlQuery:SELECT Users.DisplayName FROM Users WHERE Users.UserID=»gridEditColumn:InspectorID««</td>
</tr>
</table> </td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" cellspacing="0" border="1" cellpadding="1" >
<tr>
<td width="42%" align="center">Comments - <br />
»gridEditColumn:PropNotes«</td>
</tr>
</table>
</body></html>||»getObject:viewPage.isGridEditValidPost«|AMtblEmailErrorLog«