2 Replies Latest reply on Mar 16, 2017 10:36 PM by MarkBanin

    Getting Portal information into an email


      I have a recruitment business where the candidate table has a child table which is being used to hold each candidate's previous jobs.  What I need to do is create an email in which the candidates jobs and details are listed.


      I can't help feeling that the fundamental way I'm trying to do this is wrong:



      I create a loop, that goes through the portal and pulls out the info into a local variable:


      At the time of action, this is being actioned whilst on the employer table (related)


      Go to Layout["Candidate" (Candidate)]

      Go to Object[Object Name: "Experience Tab"]


      Go to Portal Row [First]


      Set Variable [$Experience1;

      Value: CandidateExperience::DateFrom&" - "&CandidateExperience::DateTo&" "&CandidateExperience::Area&"¶"&

      "Children: "&CandidateExperience::Ages&"¶"&

      "Hours worked: "&CandidateExperience::Hours&"¶"&

      "Childcare Duties: "&CandidateExperience::ChildcareDuties&"¶"&

      "Housework Duties: "&CandidateExperience::HouseworkDuties&"¶"&

      "RFL :"&CandidateExperience::RFL&"¶"&

      "Ref: "& If ( CandidateExperience::Ref = "Yes" ; "Available" ; "TBA" )&"¶¶"]

      Set Variable [$AllExperience&$Experience1]

      Go to Portal Row [Next; Exit after last]

      End Loop



      Unfortunately, it only lists the first job - 8 times!


      Should I be doing this another way?


      Thanks to anyone in advance