Search the Community
Showing results for tags 'workaround'.
Found 3 results
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 Create a new file. Choose File menu > New Solution… https://www.filemaker.com/help/14/fmp/en/html/create_db.8.5.html Enter Layout Mode. Choose View menu > Layout Mode or press COMMAND + L keys. https://www.filemaker.com/help/14/fmp/en/html/fmp_basics.3.7.html Insert Slide Control. Choose Insert menu > Slide Control https://www.filemaker.com/help/14/fmp/en/html/create_layout.9.42.html Name the each slide panel. Choose View menu > Inspector or press the COMMAND + I keys. Choose Position tab > Enter Name field. Press the Enter/Return key to commit the name to the object. http://help.filemaker.com/app/answers/detail/a_id/6147/~/naming-objects-in-filemaker-8.5-and-later Choose the next slide and repeat. Create a script with the above script. Choose Scripts menu > Script Workspace… Type or copy and paste the script in the code box above in the the WORKAROUND section of this post. https://www.filemaker.com/help/14/fmp/en/html/create_script.14.3.html Choose Insert menu > Merge Variable. Name it the EXACT same as the name use in Set Variable objectName ($$panelName). https://www.filemaker.com/help/14/fmp/en/html/create_layout.9.35.html#1064499 Set File Script Triggers. (not a 100% sure this is needed) Choose File menu > File Options... Choose Script Triggers tab > click checkbox OnFirstWindowOpen > click Select button > choose your script > click OK button > click OK button. Set Layout Script Triggers. (not a 100% sure this is needed) Choose Layouts menu > Layout Setup... Choose Script Triggers tab > click checkbox OnLayoutEnter > click Select button > choose your script > click OK button > click OK button. Set Object (slide control) Script Triggers. (this is a must) Right click on the Slide Control Panel object > select Set Script Triggers... Click checkbox OnPanelSwitch > click Select button > choose your script > click OK button > click OK button. Enter Browse mode. 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!
I have posted previously about the PDF creation in a runtime solution. People have offered suggestions although things like monkey bread software etc.. seem a bit complicated. I have created a runtime solution and this is the last piece of the puzzle. The customer is getting ticked off that this last part has become complicated. The PDFs they create are multi layout then I have append in a script to create one PDF across tables etc... One of my solutions was to have the endusers purchase a subscription to Filemaker and then we wouldn't have to worry about the limitations of runtime. The customer was not receptive to this idea. I've looked into plug ins but most are a little too costly. One day when I was searching I ran across a solution about moving the PDF libraries to the runtime solution. Someone had done it, and I didn't bookmark then link and cannot locate the information again. Anyone aware of this method. Any other suggestions, I didn't want to have learn iText etc... I have attached an example of the PDFs we create. Thank you, I've been pulling out my hair! Test.pdf
I am new to this forum. I joined because I am pretty new to Filemaker and I have just come through a problem I do not know how to solve. The Filemaker has, among others, 2 DB tables: Books and Artists. They are both related through a N:M (many to many) relationship. The user can select an Artist on the Filemaker solution, and then relate a few books to that artist. The user CAN NOT relate any artist to a previously selected book: this option oes not and will not exist. I would like to create a drop-down box for Book Title, but store the Book ID. I would like the user to be able to type the first few letters of the book title and have it cycle through the list so they don't have to scroll through 5000 titles. I have tried Manage Lists with the first field (BookID) stored and only show the second field (Bookitle), but then the auto-complete doesn't work (it doesn't work when the list is set to "Also display values from second field" or "Show values only from second field" or "sort by second filed"). This is so basic, I must be missing something. Could you please help me? Thank you so much!