scoony

I have a request from a colleague in the office to be able to search for records that only have a specific checkbox or checkboxes activated in a global field derived from a value list. Therefore ignoring those that have additional or other boxes checked. So far I have played with the following script. I'm typing this from memory so haven't added in error capture etc. Set Field ($search ; "==" & client::interests) Note. client::interests is selected by the user from checkbox options Enter FInd Mode [ ] Set Field (client::interests ; $gsearch) Perform Find [ ] So for example:- 3 records and the client::interest field options as follows. 1: Tennis, Football, horseracing, Rugby 2: Tennis Rugby 3: Rugby, Sailing, Tennis Set Field ($search ; "==" & "Tennis Rugby") Enter FInd Mode [ ] Set Field (client::interests ; $gsearch) Perform Find [ ] ONLY records 2 should be returned. It works but as an exact match if I ensure both client::interests and $gsearch are sorted A-Z and can fall over if carriage returns exists and so on. Just not confident this is the best and most robust way to solve the issue. Any thoughts appreciated. Thanks Zab

Your welcome, glad it helped.

Nakizimbo, This is part of iOS 9. To turn it off go to settings, keyboards and then turn off shortcuts. You might be able to use the new FM Go 14 script steps Show/Hide Menubar and Show/Hide Toolbars to ban it if required.

Hi I have created a script that will evoke a Dialog box and also using the beep script. So far under testing the Dialog box is only appearing if I remain in Filemaker Go 14. If I am reading an email in Mail the user will not get a notification pop up. I have seen script steps to Mail something or with the iPhone to call someone. Where are the scripts that connect to other Apple app like creating events in Calendar and reminders in Reminders All iOS 8. They must be somewhere, I must be looking in the wrong place. Thanks

Yes I have used conditional formatting on my MAC version of Filemaker to create the iPad database but the script trigger is not working when I test on my iPad Air. On the last Pop-up I have put an OnObjectModify script trigger. The script associated to the trigger is Go to Object [Object name: "Button Name"] It works on the Mac but not on the iPad. It just ignores the trigger and goes directly to the first Tab. I have added a file to show the problem. Popup Tigger issue.fmp12.zip

Hi All, I'm in the process of designing a Filemaker Go 13 solution for my company. One of the layouts has six questions which the relevant response in Pop-over menus. I have also set the tab order which opens the next questions Pop-over answer options. Once the last question has been answered I'd like to highlight a button.I realise that the tab order for iOS does not recognise buttons. I have tried to use the following with no success. Script Trigger on last question field: OnObjectModify with script GoTo Object naming the button I would like to highlight At the moment the script trigger is ignored and the first question is highlighted again, as in the tab order going in a loop. Any ideas would be much appreciated. Thanks Zab

Hi! I have a client database with two tables: Client, Contacts. Each client can have many contacts attributed to it but each client can have only 1 'Key Contact' which I would like to show in a list format based upon the Client table. What I have tried to create is a simple check box on the new contact layout to highlight which contact is the key contact and then be able to show that key contact field on the client list layout. As a newbie I can't determine if this requires a search, a validation to ensure no two related contacts have the 'key contact' field checked, or something along the lines of a if calculation. Any help would be much appreciated. Thanks!

Hi Pixi! Thank you very much for the file. I totally understand how you have put it together and the associated code. Zab

Hi Pixi!  Thanks for your help. I'm afraid I have a few very newbie questions. I don't understand 'oList', 'param' and can I add this script as a perform script under the button setup?  I've added a few screen shops to show what I've tried.  Thank you  Zab  Â

I have one layout with 3 'Tabs' - Client, Contacts, Achievements. For context, a client can have many contacts (portals used here) and likewise with Achievements. Each of these 3 'Tabs' has a separate layout to create a new record. This is all to be used on an iPad so if anyone has any better ideas I'd be really interested to know your thoughts. I would like to use one '+' button in the HEADER, as opposed to a button on each 'Tab', to add a new record which would go to a specific layout to create the new record. I can't seem to find a script that will give me the 'NAME' of the 'Tab' which I could then have a GoToLayout function. So if I were viewing the Client 'Tab' by clicking the '+' button it would navigate to the layout to enter new 'Client' details and if I were viewing the Contacts 'Tab' by clicking the '+' button it would navigate to the layout to enter a new 'Contact' details. Thanks Zab

The database currently has a container field using the GetMap custom function ( this same function can be found in the FM12 starter solutions). However, I am trying to find a method that will keep the map visible when the iPad in not connected to wifi. Ideally it would be great if the map automatically updated when one of the address fields was to be changed. Anyone any ideas would be VERY appreciated. Zab

Yes Eos I'm trying to integrate GetMap and if possible find a solution that will allow me to save a map.

Name & Parameters: GetMap ( webViewerName ; zoom ; address1 ; address2 ; city ; state ; postalCode ; country ) Description: Appologies if I have put this in the incorrect format. I have tried to import the GetMap custom function from the Filemaker 12 Contact sample database. I have fiddled with several fields and setting to no avail. I'm using FM 12 pro advanced. My aim is input the address, a map appears then remains with or without internet connection. Ideally would only update when the address is changed. Any pointers would be much appreciated. Recursive: ? Sample Input: Let ( [ address = Substitute ( address1 & " " & address2 & " " & city & " " & state & " " & postalCode & " " & country ; " " ; "+" ) ; size = GetLayoutObjectAttribute ( webViewerName ; "width" ) & "x" & GetLayoutObjectAttribute ( webViewerName ; "height" ) ] ; "http://maps.google.com/maps/api/staticmap?center=" & address & "&zoom=" & zoom & "&markers=" & address & "&size=" & size & "&sensor=false" ) Results: 400. That’s an error. Your client has issued a malformed or illegal request.That’s all we know. Formula: GetMap ( webViewerName ; zoom ; address1 ; address2 ; city ; state ; postalCode ; country ) Required Functions: Credits: Disclaimer: FM Forums does not endorse or warrantee these functions are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

Hi! I have two tables: Client and Contacts. The client table has a Portal that contains a list of Contacts (Emloyees, Contactors, Consultants) What I am attemping to do is one of two things: 1. Create a Value List from the Portal so I can choose one of the Contacts who is the Key Contact for that Client, or 2. Create a Conditional Value List that will list the Contacts related to that Client. For information I have a pop-up menu on my Contacts layout where you choose which client that Contact is related to. I have tried several things, I believe I must be messing upthe relationships. Any ideas?

Thanks for the advice bcooney. Regarding point 1 I haven't been able to find away of using either a drop-down or pop-up with find mode. Manually it works great but I would like to automate the process as the database with be used in iPad (initially) then iPod, iPhone. For point 2 I was conserned that when people view a record they could accidentally change information. What would you consider is the best way for users to for example request to up update information? i.e. another layout? Thanks Zab

I have been searching through the internet and forums for a solution to write a script for a button that can turn on/off the Browse mode field entry box. It would be preferable to have an edit button on the layouts rather than changes being allowed when viewing a record Do solutions for these issues revolve around 'Global Storage/Fields'? I don't have a grasp of this concept sadly Thanks

I am trying achieve two things: 1. Either use a drop-down or pop-up menu on a 'Client' layout that allows users, particularly for Filemaker Go, to select a client and then populates the other fields on the 'Client' layout. This info includes address etc. The layout also has a portal attached to it which lists staff contacts for that client. 2. I have been searching through the internet and forums for a solution to write a script for a button that can turn on/off the Browse mode field entry box. It would be preferable to have an edit button on the layouts rather than changes being allowed when viewing a record Do solutions for these issues revolve around 'Global Storage/Fields'? I don't have a grasp of this concept sadly Thanks

Wow! I didn't think to try to resolve the problem this way. I expected long and complicated scripts. Thanks for your help I've learnt a great deal from it. Much appreciated. Zab

Hi, I'm new to the forum so apologies if I have put this question in the wrong section. What I am attempting to do: I want to create a 'home page' that each consultant sees when the database opens on an iPad. The home page should have two pop-up menus, Client and the other Contact. For context, each Client with have multiple Contacts (generally employees and contractors) The consultants in the office want to be able to navigate to a Client they select from the pop-up menu on the 'home page'. The same process applies to the Contact pop-up menu. Many thanks if anyone has ideas how to achieve this.