Jump to content

siroos12

Members
  • Content count

    158
  • Joined

  • Last visited

  • Days Won

    5

siroos12 last won the day on July 28

siroos12 had the most liked content!

Community Reputation

11 Good

About siroos12

  • Rank
    member

Profile Information

  • Gender
    Male
  • Location
    Canada

Contact Methods

  • Website URL
    www.iavenue.ca
  • Skype
    siroos.jafary

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Win 10

Recent Profile Visitors

1,751 profile views
  1. Thank you for all advises. I appreciate your time.
  2. Please receive attached. What I am after is to replace the first two lines of the "Parent script" with a set variable script step which the variable would be a custom function to set the $test and run the script called "Show Card". The problem is when I put the "Show Card" script in a custom function, it will run after the parent script is run completely. It is supposed to pause the parent script, then run the Show Card and wait for user to click on the button on Card Layout. After user clicks on the button, it should close the window and resume the parent script. I am not considering to take apart the parent script and run the second part of it after running the Show Card script as a solution due to the structure of my file. Regards, test.fmp12
  3. Hi, Thanks for comments, I am actually trying to open new window in the middle of my script and do some other tasks after that and then pause for user input. So far everything is clear to me and easy to achieve, the only problem is that in this way, I have to add several lines of script to open up that new window and then pause the parent script. I considered custom functions cause I though it might be possible to make a custom function to run the subscript and pause the parent script. This way I could replace all the script lines with one line of custom function as a variable.
  4. Hi everyone, How can we run a script using custom functions? By either employing plugins or native FileMaker methods? I have checked plugins like Scriptmaster and BaseElements and they work pretty well, but their problem is that the called script got queued in scripts queue and wait for current running scripts to finish and then the called script via plugin would run. I need a solution, to pause the running script, then run the recently called script, go back to parent script and wait for user to resume it. Thanks in advanced for your time. Regards,
  5. Rank function

    Are you sure that you uploaded the correct file to your post? On the other hand, please edit your description and clearly explain your problem step by step. the current description is not clear. Thanks.
  6. This below link might help: http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists
  7. Based your description, I would assume that you have SupplierID field and a global field for year in Supplier table, also a SupplierIDfk and a Year field in Scorecards table. Make a relationship between table of current layout (in this case Suppliers) and the Scorecards table using 2 fields as below: Suppliers::SupplierID = Scorecards::SupplierIDfk AND Suppliers::Year = Scorecards::Year You may call the TO of the Scorecards anything like "Scorecard Filter". Now, to calculate the total for Shipped pieces, simply make a calculation field with below calculation: Sum(Scorecard Filter:Shipped pieces)
  8. Force Answer when = ?

    My pleasure, is your calculation filed set to return numbers or text?
  9. Force Answer when = ?

    Maybe this? if(Round ( If ( IsEmpty ( Cash Sales Total Sales Value )=1 ; 0; (Cash Sales Total Last 7 Days-(Landed Cost*Cash Sales Total Last 7 Days)*1.2) / Cash Sales Total Sales Value ); 2) = "?"; 0 ;Round ( If ( IsEmpty ( Cash Sales Total Sales Value )=1 ; 0; (Cash Sales Total Last 7 Days-(Landed Cost*Cash Sales Total Last 7 Days)*1.2) / Cash Sales Total Sales Value ); 2)) more professional method is using Let function: Let( Calculation = Round ( If ( IsEmpty ( Cash Sales Total Sales Value )=1 ; 0; (Cash Sales Total Last 7 Days-(Landed Cost*Cash Sales Total Last 7 Days)*1.2) / Cash Sales Total Sales Value ); 2); if(Calculation = "?";0;Calculation) )
  10. Thanks, would you rather doing it through a relationship or ExecuteSQL ?
  11. Hi comment; Is there any way of doing this using "ExecuteSQL "?
  12. Find prior Wednesday

    You may achieve that using get(CurrentDate) and DayOfWeek( get (CurrentDate)) the formula would be something like this: get(CurrentDate)-If ( DayOfWeek( get (CurrentDate))≥ 4;DayOfWeek( get (CurrentDate))-4;DayOfWeek( get (CurrentDate))-4+7 ) This would return the date of the last Wednesday.
  13. I assume this is simple...

    if that is a text field, then replace the field content with: Left( FieleName ; length(FieldName) / 2)
  14. Script to go to a related record in another table

    Does attached file help? I hope it is simple enough to understand. Contact Sample_V1.fmp12
  15. Script to go to a related record in another table

    You are right Comment, it is all depends on the business roles. To show up the contact name, we could also use the ContactName field from Contacts table directly instead of storing it in Activities table using lookup. There are cases that clients do want to store the contact name in child record and not change it even if the contact name has been changed. In this case lookup would do the job. Thanks for the comment
×

Important Information

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