AnsweredAssumed Answered

Email portal list sort order

Question asked by hunterkilla on Feb 1, 2016
Latest reply on Feb 1, 2016 by mikebeargie

I am running a script that sends an email with a portal list and I want to be able to set the sort order but it always puts the list in the order we entered it, on the screen I have set a sort field to move them around.


So the script does the following


Set Field [ Enquiries::combine ; List (Enquiries data::Product) 

Set Variable [$message; Value: "  <html> <p>Dear  " & Customers::First Name & "  <br><br>  MORE CODE HERE  

<td  > " & Enquiries::Combine  & "  </td>


Send Mail script command here


So this then does the email and drops in the portal fields from Enquiries date::product   BUT not sortable... is there a way to control sorting on an email


( yes doing it this way so I can send HTML emails direct from filemaker and include fields etc. )