siroos12

Thank you for all advises. I appreciate your time.

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

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.

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,

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.

This below link might help: http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists

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)

My pleasure, is your calculation filed set to return numbers or text?

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) )

Thanks, would you rather doing it through a relationship or ExecuteSQL ?

Hi comment; Is there any way of doing this using "ExecuteSQL "?

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.

if that is a text field, then replace the field content with: Left( FieleName ; length(FieldName) / 2)

Does attached file help? I hope it is simple enough to understand. Contact Sample_V1.fmp12

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