FileMaker Loop Script Tutorial

Поділитися
Вставка
  • Опубліковано 20 гру 2024

КОМЕНТАРІ • 26

  • @xfilecat
    @xfilecat 5 років тому

    Thank you Sunny, excellent tutorial, brilliant and simplistic as always.

  • @1968aliben
    @1968aliben 5 років тому +1

    thank you very much for everything you do

  • @mulaukaraoke
    @mulaukaraoke 5 років тому

    You know What. This tutorial Saves me

  • @armandogutierrez2880
    @armandogutierrez2880 5 років тому

    That was great shoot thanks a lot once again, nice and clean explanation.

  • @davesolomon4367
    @davesolomon4367 5 років тому

    Best tutorial on loop script!

  • @McLovinYoMuffin
    @McLovinYoMuffin 5 років тому

    Awesome lube script tutorial!

  • @TheLofiDragon
    @TheLofiDragon 4 роки тому

    Great explainion

  • @wsforster
    @wsforster 4 роки тому

    I love loop scripts also and I think you did a great job explaining it - however in the example you chose, I'd have done a simple replace command . First, find all IPX record, then in the new code field insert IP10 and replace [command = ]

    • @FMBeginner
      @FMBeginner  4 роки тому

      You are right! For a single field calculation, replace is definitely a better solution for this example.

  • @MrDiertje
    @MrDiertje 5 років тому

    Great, as usual Sunny

  • @kishancanoo8328
    @kishancanoo8328 5 років тому

    Great tutorial. Keep it up!

  • @petitmar1
    @petitmar1 5 років тому

    Hello Sunny,
    You are very good in what you' re doing. I have a question?
    How to post periodic data in a database. I mean let's say I want to post the payroll each month. How to proceed?
    Thanks in advance

  • @johndavey2715
    @johndavey2715 5 років тому

    Great explanation, thanks.

  • @ahtfilemaker
    @ahtfilemaker 5 років тому

    You are wonderful man

  • @g4training
    @g4training 4 роки тому

    Thank you very much. Q. I want a script that creates a set number of new records in a table.
    For example I want the script to generate 100 new records. I know how to make a script and copy it to repeat and I understand the basics of Looping thanks to you but I don't know what to script in the 'Exit loop if' to get it to repeat the script exactly 100 times and then exit the loop or if this is even the best option. Any help is much appreciated. Thank you.

    • @FMBeginner
      @FMBeginner  4 роки тому

      Hi David, here is a hint, you can use set variable to help you with that. $count -> 1, $max -> 100, increment the count within the loop with $count -> $count + 1

  • @HestiNurnaningsih
    @HestiNurnaningsih 5 років тому

    Hi, Sunny. I'm beginner in filemaker and still figuring out how to use filemaker for my work. I have a question for you. Is it possibly for me to make an integrate multiple file on filemaker? Thank you for your answer

  • @eugenio4038
    @eugenio4038 4 роки тому

    Thank you so much for this tutorial! I have a question : in the case that you explained, what is the difference between a loop script and a simple calculation field? Thank you

    • @FMBeginner
      @FMBeginner  4 роки тому +1

      The context of this tutorial is to calculate text result. Both calculation and loop script can do that, so in this example theres no difference.
      But loop script is much more versatile in use and potential for many other stuff. For example, I can use a loop to check each customer to see if it is his birthday, and if yes, send an birthday email to them... etc. This is something that can't be done with just calculation field.

  • @antoniocarlosfuertes7810
    @antoniocarlosfuertes7810 5 років тому

    Hope you can create a tutorial about Graph or Chart Related Records.

  • @SAMARTHGROUP
    @SAMARTHGROUP 4 роки тому

    Hello Friend How we can copy records from one portal table to another table by loop script method .

    • @FMBeginner
      @FMBeginner  4 роки тому

      Hey Santosh, you can loop thorough portal by a script called "Go to portal row [next]"

  • @michaeldavid1431
    @michaeldavid1431 2 роки тому

    Hello Sir new subscriber here, and also new FM user, How to get total and subtract from other table for ex. From table1- total subtract To Table2 total. please help.

  • @wensen532
    @wensen532 3 роки тому

    I Like it,thank