Jump to content
R81

If Field Loop Multiple Records

Recommended Posts

Hello,

I need to create a script to search all records in a found set and if a particular field for each are all the same value (0) then 'do something'.

To illustrate what i need see the attached.  

Record 1 there are 32 in total, 27 have been delivered and 5 remain
Record 2 there are 3 in total, 1 has been delivered and 2 are remaining

When the script runs to reduce the delivery remaining count I want it to check if all records for this field are now at 0 and if they are 'do something'

I suspect that I need an IF statement and a LOOP through the records but it is the "IF DeliveryRemaining = 0" for all records which i am confused at.

Hope that makes sense and someone can help.

Capture.PNG

Share this post


Link to post
Share on other sites

I am not sure I follow your description fully. It looks like you would want to perform Constrain Found Set (in a new window, to preserve your current found set) and see if any records are found.

Or, if you are looping, you could something like:

Go to Record [First ]
Loop
  If [ YourTable::DeliveryRemaining ]
    Set Variable [ $rem ; 1 ]
    Exit Loop If [ 1 ]
  End If
  Go to Record [Next; Exit after last ]
End Loop
If [ not $rem ]
  # ALL RECORDS  HAVE 0 REMAINING
End If

 

Share this post


Link to post
Share on other sites
2 hours ago, R81 said:

When the script runs to reduce the delivery remaining count I want it to check if all records for this field are now at 0 and if they are 'do something'

I wonder if it wouldn't be easier to create a summary field (maybe called sDeliveryRemaining' which is 'Total of DeliveryRemaining.  Then script could check this value as:

If [ not sDeliveryRemaining ]  ... then do 'the thing' you wish.

Sorry for the glitch.

Edited by LaRetta
finished calculation sentence
  • Like 1

Share this post


Link to post
Share on other sites

Yet another option: sort the found records by the DeliveryRemaining field, ascending (or descending) and check the value of the last (or first) record.

 

  • Like 2

Share this post


Link to post
Share on other sites

Great options! 

I will give the summary field a try later as that would probably fit easier to my script!

Thanks all.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Who Viewed the Topic

    1 member has viewed this topic:
    Terrible Toll 
×
×
  • Create New...

Important Information

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