Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


LaRetta last won the day on April 6

LaRetta had the most liked content!

Community Reputation

502 Excellent


About LaRetta

  • Rank
    Lifelong FM Student

Profile Information

  • Title
  • Industry
  • Gender
    Not Telling
  • Location

FileMaker Experience

  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi Grapes, It would also help if you complete your profile so we know your OS and FM versions. Thank you, and welcome to FMForums! 😀
  2. Instead of enter the path in the auto-enter calculation of the container, it needs to go in the Options > Storage (look to the bottom of that Storage tab). I think I misinterpreted your question. Sorry. And no way to delete my own post. 😱
  3. Hi Chris, The $i variable is a counter which increases with each loop. When first entering the loop, it sets $i = $i + 1 but because it is starting, the $i will be empty so its value will be 1. Each time it loops to that point again, it will test if it is greater than the value count of the list. If yes, it will exit but if not, it will again increment by 1. It is a cool counter technique. The first two steps inside the loop (the first which sets the $i and the second which tests) can also be written as a single step: Let ( $i = $i + 1 // increment the counter ; $i > ValueCount ( theList ) // and then boolean test if the loop should exit ) In addition, if you are using a counter in multiple loops, it can be useful to clear the $i so it does not conflict with its use in the next loop. It too can be a separate step (after you exit the first loop) or written all as one within the Exit Loop[] as: Exit Loop If [ Let( $i = $i + 1 ; If ( $i > ValueCount ( theList ) ; Let ( $i = "" ; True ) ) ) ] All methods are great; use the one easiest for you. 🙂
  4. Hi Eli, Whether you store your containers externally or internally in the file, you can have several tables share that Container file. Any information you include in in an auto-enter can be transferred to the Container table when you insert the photo or file into the container (please see attached). Hi Barbara! Nice to see you again! Added: If you are really worried about duplicates, you can include the table in each Parent table. Create an unstored calculation and include it in the relationship instead but most feel that isn't necessary. DataWithContainers.fmp12
  5. Hey John! If you mean the old Music Library, I happen to have it (attached). Music Library.fmp12
  6. Why use auto-enter (text) field instead of straight calculation? The only reason you might wish to use an auto-enter text field would be if the User must make a change to it but since this is only searching, it wouldn't matter. By making it a calculation, it would adjust if the User changes the field text. Otherwise, with auto-enter, you would need to remember to specify REPLACE existing value. Just a thought. Also, I just tested this and unless I'm mistaken, you can place that calc off screen and it will still be searched by Quick Find. That is kinda cool! 🙂 Wow, I didn't know about this: I'll need to add that to our word separator exceptions list!
  7. You might also consider a more generic approach. This 'on-the-fly' method of specifying global value lists is very familiar to Mr. Vodka as well. Having this trick in your tool kit is VERY handy (attached) and would work nicely in your situation, John! Global_VL.fmp12 By the way, if you do need to restrict values by removing those years already assigned, you can do that as well, right within the Let() statement itself. I wasn't clear if that was part of your need.
  8. Actually, I don't see a value of using JSON here and it means looping twice. I appreciate the attempt anyway!
  9. BTW, I want to restrict the x axis if over a certain number since the date range is open-ended. I realized I could use: 12 * ( Year ( EndDate ) - Year ( StartDate ) ) + Month ( EndDate ) - Month ( StartDate ) ... a calculation provided by Comment awhile back instead of the twisted calc I started to use in generating the x axis zeros (in the disabled section of my script).
  10. Thank you, Jeremy. I have used the method of specifying empty values before, picked up from Michael Horak (Comment) a few years back but it was when setting a flat 12-month (predictable) period where I could also hard-code the x axis (monthNames) but since I wanted an unspecified number (and names) of x axis, I was of course stuck! Just before you posted, I finished including an unspecified number of 0s but I disabled it instead deciding to include it in the loop itself (result is attached). I look forward to studying your creation since I'm just getting my head deeply into JSON and the more methods I understand, the better. 😀 Note: I decided to use true dates when incrementing through the months because then I wouldn't have to test whether I crossed a year boundary. It seemed simpler for me. InspectionsMOD2.fmp12
  11. Hi everyone, I have a simple chart which displays month's totals but some months have no data. I'm trying to adjust the script to set the 'empty months' in the date range to 0. Does anyone know if that is possible? I've attached sample of the script, chart and data. Date range is october, 2017 - current date. Notice there is no March 2018. Can I make that empty year/month 0? Thank you for ideas! I'm unsure whether best to set the $description ahead of time with all 0's then replacing the value or whether I should track the month number as I go and add the 0 when current month doesn't match prior or whether there is a better technique to either approach. I worry because I'll be crossing year boundaries so a simple + on month number will not work. Inspections.fmp12
  12. Comment, your CrossTabR.fmp12.zip file is extremely lightweight and easy to implement! Thank you for providing this - it absolutely ROCKS! 😀
  13. What still amazes me is that LotusSuite (Approach was their database) had crosstab functionality in 1998 and I used it all the time in designs yet FileMaker still has nothing similar.
  14. To suggest a new feature, post your suggestion here: Product Ideas But be prepared to answer the same question Comment is asking. 🙂
  15. Thank you for letting us know, Stephen. I will miss him too.
  • Create New...

Important Information

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