AnsweredAssumed Answered

Getting Portal information into an email

Question asked by MarkBanin on Mar 4, 2017
Latest reply on Mar 16, 2017 by 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

Outcomes