Jump to content

Recommended Posts

Aloha All,

DISCLAMER

I'm not a programmer nor a technical writer and also is ESL. So my writing is tailored to me or someone like me aka noobie as F* (toward me not you). Detail and step by step and as clear as possible. Please let me know if i’d missed something or grammar correction.

System: As of 04-20-2016 (not potting around) macOS 10.11.4 (yeah I’m using macOS name form now on instead of OS X), iOS 9.3.1, Filemaker Pro Advance 14.0.5 and GO 14.0.4 

OBJECTIVE

Make merge variable to show the slide control panel's object name (the name of the front most slide panel). So when the file is open the merge variable will show the name of the from most slide control panel letting you know which slide you're on.

ISSUE

Merge Variable does not show value on open first window. Please read entirety below.

WORKAROUND

Although it's a lame hack that I prefer not to use but it does the job. I'd included these two ugly steps in the script Go To Object [ Object Name: "Panel2" ] then Go To Object [ Object Name: "Panel1" ] to have the merge variable show Panel1 name on opening of the file.

# the number symbol or the hashtag is to comment as a note to yourself and others about the script line(s) (ignored when the scrip is performed functional line).

Set Variable [ $$panelName; Value:GetValue ( Get ( TriggerTargetPanel ) ; 2 ) ] 
#The "2" is the result value which is the name of the objectName that you gave it in the inspector panel. Number "1" will return the number of the panel. As in 1 (which is the first) of 3 panels or 2 (which is the second) of 3 panels or 3 (which is the third) of the 3 panels.

Go to Object [ Object Name: "Panel2" ]
Go to Object [ Object Name: "Panel1" ]

#Refresh Window will work the same but I think it'll refresh the whole layout. FYI: "MVpanelName" is the object name of the merge variable "<<$$panelName>>."
Refresh Object [ Object Name: "MVpanelName" ]

 

ENTIRE HOW TO

  1. Create a new file. 
    1. Choose File menu > New Solution…
    2. https://www.filemaker.com/help/14/fmp/en/html/create_db.8.5.html
  2. Enter Layout Mode.
    1. Choose View menu > Layout Mode or press COMMAND + L keys.
    2. https://www.filemaker.com/help/14/fmp/en/html/fmp_basics.3.7.html
  3. Insert Slide Control.
    1. Choose Insert menu > Slide Control
    2. https://www.filemaker.com/help/14/fmp/en/html/create_layout.9.42.html
  4. Name the each slide panel.
    1. Choose View menu > Inspector or press the COMMAND + I keys.
    2. Choose Position tab > Enter Name field. Press the Enter/Return key to commit the name to the object.
    3. Choose the next slide and repeat.    
  5. Create a script with the above script.
    1. Choose Scripts menu > Script Workspace…
    2. Type or copy and paste the script in the code box above in the the WORKAROUND section of this post.
    3. https://www.filemaker.com/help/14/fmp/en/html/create_script.14.3.html
  6. Choose Insert menu > Merge Variable.
    1. Name it the EXACT same as the name use in Set Variable objectName ($$panelName).
    2. https://www.filemaker.com/help/14/fmp/en/html/create_layout.9.35.html#1064499    
  7. Set File Script Triggers. (not a 100% sure this is needed)
    1. Choose File menu > File Options...
    2. Choose Script Triggers tab > click checkbox OnFirstWindowOpen > click Select button > choose your script > click OK button > click OK button.
  8. Set Layout Script Triggers. (not a 100% sure this is needed)
    1. Choose Layouts menu > Layout Setup...
    2. Choose Script Triggers tab > click checkbox OnLayoutEnter > click Select button > choose your script > click OK button > click OK button.
  9. Set Object (slide control) Script Triggers. (this is a must)
    1. Right click on the Slide Control Panel object > select Set Script Triggers...
    2. Click checkbox OnPanelSwitch > click Select button > choose your script > click OK button > click OK button.
  10. Enter Browse mode.
    1. Choose View menu > Browse or press the COMMAND + B keys.

SEEKING HELP

Please reply if you have a better solution to this terrible workaround.

 

Mahalo All!

 
Edited by tdub808

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By Asu
      Hello FM experts, 
      this is a concept step for a more complex script but I need a script that has 2 independent features:
      1: it selects the field it is attached to as a button
      2: it can be attached to any arbitrary field and it does the same on that field.  
      The imaginary script step would be this:
      Select field [the one I am attached to] The problem I am running into is that "go to field" can not be defined by calculation, while "go to object" gets confusing between the script and the field being grouped, as the problem detailed here [https://www.soliantconsulting.com/blog/story-about-go-to-object] seems to be a complicating factor.
       
      Thanks
      Asu
    • By Richard Carlton
      FileMaker Coaches' Corner - Tip 7 - Slide Panel & Button Bar
      https://youtu.be/pjLL38KIkZo
      Download the free sample file here: http://bit.ly/2E2lAO1
      For this Coaches’ Corner tip, Myles Debski demonstrates how to use a slide panel & button bar as an alternative to trying to hide a tab panel.  
      http://fmstartingpoint.com/downloadform2.php
      http://www.fmcoachescorner.com
      Most Recent Upload https://goo.gl/Dbn9fm
      Get up to speed with the FileMaker Pro 16 Video Training Course! 
      Top Rated Course by FileMaker Expert, Richard Carlton. 
      http://learningfilemaker.com/fmpro16.php
      Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions. 
      The course is 50 hours of video content!
      Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. 
      Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. 
      He has offices in California, Nevada, and Texas.
      Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration.
      Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.
      Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
      Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.
      RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA.
      http://www.rcconsulting.com/
      Please feel free to contact us at support@rcconsulting.com
      FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web
      Transform your business with the FileMaker Platform
      Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos
      50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos
      https://www.youtube.com/watch?v=KpQqLLDcZ8I
      Playlist https://www.youtube.com/watch?v=KpQqLLDcZ8I&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_&index=13
      Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16
      https://www.youtube.com/watch?v=urh8iHOCxkg
      Playlist https://www.youtube.com/watch?v=urh8iHOCxkg&t=130s&index=1&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_
      Sharing your Database with Other Devices and Users-FileMaker 16 News-FileMaker 16 Database Sharing
      https://www.youtube.com/watch?v=GF82vkYtCtA
      Playlist https://www.youtube.com/watch?v=GF82vkYtCtA&index=8&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_
      Introduction to FileMaker WebDirect 16-FileMaker 16 News-Online FileMaker 16 Training Videos
      https://www.youtube.com/watch?v=uaZKIpBjMAM
      Playlist https://www.youtube.com/watch?v=uaZKIpBjMAM&list=PLjTvUZtwtgBSVV1-4pFG4SHAhCIP3Yy-I&index=17&t=10s
      A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data
       
      Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project
      http://learningfilemaker.com/FIAS.html
      https://sites.google.com/site/filemakerprotrainingd2n/home/filemaker-training
      https://drive.google.com/file/d/0ByHcthu5EL9NSmowQm9OUDdZZ1k/view?usp=sharing
      Free FileMaker videos check out ...http://www.filemakervideos.com
      Download the FileMaker Pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com
      Download FileMaker Go 16 video training at http://learningfilemaker.com/FMGO-16/fmgo16.php
      Download FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscription.php
      FileMaker Video Training Review-FileMaker 16 Video Course Review-FileMaker Pro 16 101 Course Review
      https://www.youtube.com/watch?v=mF6Uor0KmKo
      Playlist https://www.youtube.com/watch?v=mF6Uor0KmKo&list=PLjTvUZtwtgBT8tNHuzF6cOKC_37zCTQl6&index=18
      Use FileMaker to create an app with the FileMaker Training Series
      FileMaker Pro is a cross-platform relational database application from FileMaker Inc.
      Comment, Like & Share Our Videos.
      Feel Free to Embed any of Our Videos on Your Blog or Website.
      Follow Us on Your Favorite Social Media
      https://www.facebook.com/FileMakerVideos
      https://twitter.com/filemakervideos
      https://plus.google.com/+FileMakerVideos/videos
      #FileMakerCoachesCorner
      #FileMakerPro16Training
      #FileMakerPro16Videos
      Playlist: https://goo.gl/ycpCqW
      Google RSS Feed : https://goo.gl/hxtYvW
    • By wedgeman
      I've been searching for some clear answers on db vulnerability, specifically related to scripting.
      We have a particular solution running in FMP13, with EAR. This is a peer-shared file design, which has hundreds of installations in peer-shared environments.
      User access accounts have been severely limited in released versions (no admin, no [full access]), limited menus, etc..
      Users are heavily striated by account privilege set.
       
      I've read bits here & there mentioning that initial opening scripts (onwindowopen, etc) at startup are particularly vulnerable, but haven't found anything definitive.
      1. is an opening script trigger a legitimate security flaw?? We use it to determine layout paths, check/confirm licensing, etc, so if it is 'hackable', what alternate option is there?
      2. I noticed that even attempting to bypass script triggers, the system requires a full access name/password.. BUT it also displays the name of the particular script (seems like a point of weakness to me)... Is there a way to prevent this?
    • By NewBoard
      I have used the combination of ExecuteSQL and ValueCount quite a few times throughout my databases before, with almost no issues. Generally what I will do is set a variable by running an ExecuteSQL, then take a ValueCount of that variable. Then with that ValueCount I will loop through my original ExecuteSQL variable.
      However, I am now trying to do something different with this combination. Instead of using the ValueCount variable for a loop, I'm trying to use it as a Global Variable that will be displayed on the main menu. Here is an example of the code I'm trying to use:
      Set Variable [$source; Value: ExecuteSQL ( "SELECT UUID FROM Inspections WHERE Inspector = ? AND Accepted ≠ Accepted" ; "" ; "" ; $$fullName )] Set Variable [$$accepted; Value: ValueCount ( $source )] The UUID field is, as expected, an auto-entered "Get ( UUID )" field. The Inspection table is a table containing all of our part inspections. Each inspection begins with it's Accepted field having a value of "Rejected", if the correct parameters are met this field will become "Accepted". The Inspector field contains the first and last name of whomever conducted the part inspection. The $$fullName variable is set previously in this same script by comparing the user's Username to a Table that contains all of our user's Usernames and Full Names.
      What I was hoping to do is use a Merge Variable on our main menu that displays our $$accepted variable, showing the user how many unaccepted inspections from that particular user in our database.
      However, it only ever displays a value of "1". One of our users has 6 unaccepted inspections in our database currently, but this script only shows that he has 1.
      I am wondering if you can't use Merge Variables or ExecuteSQL in this way, or if I'm simply missing something obvious.
      Please let me know of any more information I should provide. Thank you for any assistance you may offer!
    • By Joel Shapiro
      Hiya
      Can FMPerception show the elements that have script triggers that call a specific script?
      Thanks,
      -Joel
       
×
×
  • Create New...

Important Information

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