Jump to content


FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.



Checkbox problem

  • Please log in to reply
1 reply to this topic

#1 haani  member

  • Members
  • 17 posts
  • FM Application:12 Advance
  • Platform:Mac OS X Mountain Lion
  • Time Online: 7h 18m 55s

Posted 06 November 2013 - 07:21 PM



I am working on a database and I have just found a problem with it that I can't seem to fix, as you can see from the image, I have added a portal row to a layout which includes check boxes and I have a send email button at the bottom which run the following script:



Set Field [ Case::chk box; 1 ]

Go to Layout [ “Quote View” (Consultant) ]

Set Variable [ $FilePath; Value: Get ( TemporaryPath ) & "Quote " & Case::Case Number & ".pdf" ]

Save Records as PDF [ File Name: “file:$FilePath”; Current record ]

Send Mail [ Send via E-mail Client; To: Case::Solicitor's Email; Subject: "New Quote: " & Case::Case Number & " "; Message: "Dear " & Case::Company Name & "¶¶" & "Please find the Quote attached "; Attachment: “file:$FilePath” ]

Go to Layout [ “Consultant” (Consultant) ]


now the issue is that if I select any checkbox, always the first row on the portal row is selected and then the email is sent, is there anyway I can modify the script to make it select the row where the check box is selected, I searched around and thought maybe set field would fix it, but it didn't, any help would be greatly appreciated!


sorry posted this is the wrong thread, this was meant to go in managing scripts thread!

Attached Thumbnails

  • filemaker.png

  • 0

#2 Lee Smith  I like the v13 layout tools

Lee Smith
  • Staff
  • 10,152 posts
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch
  • Platform:Mac OS X Mavericks
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 229d 7h 1m 12s

Posted 06 November 2013 - 07:54 PM

Have you tried using a second copy of the field (Edit) instead of the checkbox to get your value?

  • 0

FMForum Advertisers