nsdodgers
-
Content Count
9 -
Joined
-
Last visited
-
Convert to range of numbers
nsdodgers replied to nsdodgers's topic in Script Workspace and Script Triggers
Perfection again, comment -
Number Field Range Operation
nsdodgers replied to nsdodgers's topic in Calculation Engine (Define Fields)
It's the reverse of what we worked on in the other post. Going from a list to a range -
Hello, I'm working on a script to convert a list of numbers into a user friendly range of numbers. For example, here's a list of numbers 21 22 23 24 25 31 32 33 34 35 I would like it to set a field with: 21-25,31-35 I have a script that can easily deal with the first half, but I am struggling to make it work with multiple ranges. Set Variable [ $counter; Value:1 ] Set Variable [ $first; Value:GetValue ( range reverse::test unit numbers; $counter)] Set Variable [ $last; Value:$first ] Loop Set Variable [ $last; Value:$last+1 ] Set Variable [ $counter; Value:$counter + 1 ]
-
Hello, I have a text field with a number of ID's separated by a carriage return and am in need of help creating a portal filter to return all of the child records that have IDs that are in the list of IDs. I have been working on using pattern count to no avail. Thanks for the help!
-
Number Field Range Operation
nsdodgers replied to nsdodgers's topic in Calculation Engine (Define Fields)
Thank you so much comment, your file is perfectly clear. The next hurdle I am working on is to allow the user to have both in the same list. For example: 1-5,19+25,30-33 I believe I should turn the + and , into carriage returns first, then deal with the hyphens with a loop through the list entries somehow -
Number Field Range Operation
nsdodgers replied to nsdodgers's topic in Calculation Engine (Define Fields)
Thanks so much for your help, I have updated my profile and started work on the + and , -
Hello, I have a number field where I want the user to be able to enter things like: 42 (only item 42) 12+82 (only items 12 and 82) 1-5 (items 1 through 5) 31,33,35,37 (only items 31,33,35,37) So I am need of a way for filemaker to deal with the operators '+' '-' and ',' Do you have any advice on how I can separate out the item numbers? Thanks!
-
I solved it, it had no anchors, but adding one to the left fixed it Thanks!
-
Hello, I have a portal that is moving around my layout. In edit mode, where the columns are aligned properly with the headers. list view browse mode, where the portal has moved to the right. I don't have any sliding enabled. Thank you in advance for the help