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. )

Outcomes