Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Title
  • Industry
  • Gender
  • Location
    los angeles

Contact Methods

  • Yahoo

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

FileMaker Partner

  • Certification
    Not Certified

kgasman's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Does anyone have an idea how to capture charging data made with the square app for a FM pro database
  2. From a thread in Filemaker Community: Just as a follow-up to document things for future readers of this thread: As HOnza noted, the techniques described earlier in the thread require that fmextscriptaccess be turned on for the file in question when using FileMaker 16 (File > Manage > Security, grant extended privileges to selected users). As I found out (and confirmed through implementation) in another thread, you may omit the 'tell Application "FileMaker Advanced"' tell block and just use the commands directly, since you are operating in the FileMaker context if your AppleScript is being run within FileMaker. This also avoids the problem where you don't know whether users will be running Pro or Advanced. So you can simplify TSuki's AppleScript even more: Tell application "Finder" set cap to get capacity of startup disk end tell set cell "Field1" of current record to cap It turns out if I modified my script to if (do shell script "ls /Applications") contains "QuickTime Player" then Set A to "QuickTime Player" end if set cell "ToBurnSound" to A this works perfectly even if I don't set privileges or use a Tell command
  3. I have seen the below statement in other responses, but I do not understand the script steps necessary to achieve this. I have the latest Plastic plugin Please help "But using Plastic can help make your practices PCI compliant. For example, if you use Authorize.net as your gateway, Plastic can submit payment card and ACH account numbers to Authorize.net's PCI-complient CIM database in exchange for a token, which is PCI-compliant to store in your database. Plastic then lets you run charges against these tokens, and Authorize.net looks up the corresponding account information in their CIM to complete each transaction"
  4. How do you script the your suggestion to get a "token" thanks
  5. Thank you I did set the privileges as you suggested and the AppleScript still does not set the Field... very strange
  6. Hello The following AppleScript is in a opening "Perform AppleScript" step in my database. In Filemaker Pro 13 this script set the Filemaker Pro field without out a problem. After upgrading to Filemaker Pro 16, the AppleScript no longer sets the Filemaker Pro Field Anyone have any ideas why? here is the AppleScript: --Make sure QuickTime exists; could be used to find any program if (do shell script "ls /Applications") contains "QuickTime Player" then --send information to FileMaker so opening script can set voicenotes properly tell application "FileMaker Pro Advanced" tell table "Preferences" tell record 1 set cell "ToBurnSound" to "QuickTime Player" end tell end tell end tell end if
  7. I currently have a database solution using the Plastic plugin. I do not use a terminal. The user enters the card information. Does anyone know if the plastic plugin works with the SwipeIt iPhone terminal. Anyone who has used it... what are the pluses and minuses?. thank you for any input
  8. I wanted to script a Find button for a solution I am writing. I found the following in the Help section of Filemaker pro 11 Set Error Capture [ On ] Enter Find Mode [ Specified Find Requests: Find Records; Criteria: ClientDatabase::LastName: “Enter Last Name then press Enter Key” ] [ Restore; Pause ] Perform Find [ ] If [ Get ( LastError ) > 0 ] Show Custom Dialog [ Title: "No Records Found"; Message: "No records were found. Click OK to modify your request or click Cancel to return to Browse mode."; Buttons: “OK”, “Cancel” ] If [ Get ( LastMessageChoice ) = 1 ] Modify Last Find Else Enter Browse Mode Show All Records End If End If It works well except you can't capture the error in "Modify Last Find" script step if the user doesn't find any records or clicks on cancel. I tried another "Get (LastError)" after the "Modify Last Find", but it doesn't work. I also tried this after the last "End If" Go to Record/Request/Page [ First ] If [ Get ( LastError ) = 101 ] Enter Browse Mode Show All Records End If Sort Records [ Specified Sort Order: ClientDatabase::LastName; ascending ClientDatabase::FirstName; ascending ClientDatabase::DateFirstEntered; ascending ] [ Restore; No dialog ] Adjust Window [ Resize to Fit ] Set Error Capture [ Off ] I thought if I captured for a found set of "0" that might work, but it didn't work. Any suggestions. I am sure there is an easy solution but I don't see it thanks for any help
  9. I will not do that since when I give the solution to my wife she will install it on her computer. I will not know the path in her computer. I guess that is why the reference path is so useful. thanks for all the help
  10. thanks I will try that. So I understand.... When I change the import script step from the "hard-coded" path to the reference; the field mapping will be maintained?
  11. Here is a problem with upgrade routine. I have five tables to import. Using the import records script; the script step does not select the correct table to import to the current layout (table). any thoughts Kevin
  12. Yes Billings is based on Billings table. I downloaded the demo. I will play with it to see how it works. thank you!!! Is there a particular order I should import the tables. Since the "Clients" table is related to many billings in the "Billings" table and the "Clients" table is related to many notes in the "Notes" table, I thought I would have to import the "Billings" table then the "Notes" table then the "Clients" table. Then I would reset the "clientID" field serial number. It didn't seem important when I import the "Preferences" table or "Values" table as these are for lookup purposes only. thanks for any help in advance
  13. I have a database I created for my wife's therapy practice. From time to time I make changes to scripts and database structure. In the past I have made a clone of the updated database and then manually imported the data from my wife's file into the updated clone. I thought I could create a script using the "import records" script step to automate this but one table will not import. Let me explain The database consistes of five tables Clients...this table contains the demographics of the client. "clientID" is the related record to Billing...this table contains records of each billing and payments for the client ("clientID" is the related record) notes...this table contains records of each of the therapy sessions for the client ("clientID" is the related record) preferences... this table has one record with all the preference settings for the file values... this table has multiple records for use in value lists during data entry. I can manually import the data into each of these tables. the problem is when I automate it by go to layout preferences import records go to layout values import records go to layout billings import records go to layout notes import records go to layout clients import records all the tables import except billings, it is always grayed out in the import dialog box any ideas? thank you
  14. I used no borders on the field in the layout which made the blank fields not visible. I used the following script to add a new value to the first empty field found. Not very elegant...any suggestions for improvement NewValueMS Set Error Capture [ On ] Go to Record/Request/Page[ First ] If [ Get ( LastError ) = 101 ] New Record/Request Set Field [ Valuelists::MaritalStatus ] Exit Script [ ] End If If [ IsEmpty ( Valuelists::MaritalStatus ) ] Go to Field [ Valuelists::MaritalStatus ] [ Select/perform ] Exit Script [ ] End If Go to Record/Request/Page[ Last ] Set Variable [ $lstrcd; Value:Get ( RecordNumber ) ] Go to Record/Request/Page[ First ] Loop Go to Record/Request/Page[ Next ] If [ IsEmpty ( Valuelists::MaritalStatus ) ] Go to Field [ Valuelists::MaritalStatus ] [ Select/perform ] Exit Script [ ] End If Exit Loop If [ Get ( RecordNumber ) = $lstrcd ] End Loop Set Error Capture [ Off ] New Record/Request Go to Field [ Valuelists::MaritalStatus ] [ Select/perform ] Exit Script [ ]
  • Create New...

Important Information

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