R81 Posted January 10, 2017 Share Posted January 10, 2017 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. Link to comment Share on other sites More sharing options...
comment Posted January 10, 2017 Share Posted January 10, 2017 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 Link to comment Share on other sites More sharing options...
LaRetta Posted January 10, 2017 Share Posted January 10, 2017 (edited) 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 January 10, 2017 by LaRetta finished calculation sentence 1 Link to comment Share on other sites More sharing options...
comment Posted January 11, 2017 Share Posted January 11, 2017 Yet another option: sort the found records by the DeliveryRemaining field, ascending (or descending) and check the value of the last (or first) record. 2 Link to comment Share on other sites More sharing options...
LaRetta Posted January 11, 2017 Share Posted January 11, 2017 Even better! Link to comment Share on other sites More sharing options...
R81 Posted January 11, 2017 Author Share Posted January 11, 2017 Great options! I will give the summary field a try later as that would probably fit easier to my script! Thanks all. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2656 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 accountSign in
Already have an account? Sign in here.
Sign In Now