Jump to content



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,524 posts
  • LocationWoodland, CA
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Mac OS X Yosemite
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 257d 19h 15m 38s

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