Jump to content

Return Marker under conditions


This topic is 7574 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am writing data from a repeating field(s) into a text field. This text field is then sent off as an email notice to internal users. I want each repetition cell to show on a separate text line (easier to read), no problem so far. But my problem is this, if, for example, repetition 2 has no entry, the code will leave a blank line (because of the return marker). It's this blank line I want to prevent, so I need to correctly set into the statement a condition that if the case fails, the return marker is not envoked. In this sample I am checking a field cell that would contain a "P" or "C" (partial or complete"), if it meets this criteria then get the data from a specific repeating field. Here's part of my code

Case(GetRepetition(x_PO::rec.P_C_pg1,1) = "C",GetRepetition(LineString1,1), GetRepetition(x_PO::rec.P_C_pg1,1) ="P",GetRepetition(LineString1,1),"") & "

Link to comment
Share on other sites

This topic is 7574 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.