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

    Getting Portal information into an email

    MarkBanin

      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]

      Loop

      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