Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


siroos12 last won the day on April 29 2018

siroos12 had the most liked content!

Profile Information

  • Gender
  • Location

Contact Methods

  • Website URL
  • Skype

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Win 10

Recent Profile Visitors

4,233 profile views

siroos12's Achievements

Community Regular

Community Regular (8/14)

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

Recent Badges



  1. Thanks @bcooney So, for future references, A Deposit needed to be recorded in QB in order to distribute the payments and fees correctly. Here is the process: 1- Add invoice for $100 using "InvoiceAdd" SDK aggregate 2- Add a payment for $100 for that invoice using "ReceivePaymentAdd" SDK aggregate 2- Add a deposit with below steps: Set Variable [ $$Result; Value:PCQB_RqNew("DepositAdd" ; "") ] Set Variable [ $$Result; Value:PCQB_RqAddFieldWithValue( "TxnDate"; PAYMENTS::Date )] Set Variable [ $$Result; Value:PCQB_RqAddFieldWithValue( "DepositToAccountRef::FullName"; "CC Deposits" ) ] Set Variable [ $$Result; Value:PCQB_RqAddFieldWithValue( "Memo"; "Stripe transaction" ) ] #Add deposit lines #Add payment record as the first deposit line Set Variable [ $$Result; Value:PCQB_RqAddRelatedRecord( "DepositLineAdd"; "") ] Set Variable [ $$Result; Value:PCQB_RqAddFieldWithValue( "PaymentTxnID"; Payments::TxnId ) ] Set Variable [ $$Result; Value:PCQB_RqCloseRelatedRecord ] #Add payment processing fees as the second deposit line with negative amount Set Variable [ $$Result; Value:PCQB_RqAddRelatedRecord( "DepositLineAdd"; "") ] Set Variable [ $$Result; Value:PCQB_RqAddFieldWithValue( "AccountRef::FullName"; "CC Fees") ] Set Variable [ $$Result; Value:PCQB_RqAddFieldWithValue( "Memo"; "Stripe Processing Fees") ] Set Variable [ $$Result; Value:PCQB_RqAddFieldWithValue( "Amount"; - PAYMENTS::Stripe_Fees )] Set Variable [ $$Result; Value:PCQB_RqCloseRelatedRecord ] #Execute Set Variable [ $$Result; Value: PCQB_RqExecute ] This will add a Deposit with two lines deposited to "CC Deposits" account. First line is the payment of $100 and next line is the fee with negative amount of - $3. Total Deposited amount to "CC Deposits" account would be $97. I hope this helps someone else who encountered the same issue.
  2. Hi All, In my application, I process credit card payments and post them to QB under CC Deposit account. I use "ReceivePaymentAdd" SDK aggregate to push these payments to QB. i.e. I charge a client cc for $100.00 in my application and this breaks down to $97.00 paid to us and $3.00 cc card processing fee charged by Stripe. Currently, I post the invoice with its line items for $100.00 and a payment associated to it for $100.00. I need to find a way to post this $3.00 fees to QB as an expense using SDK. So, it would add an invoice for $100.00 a payment for $100.00 (In accounts receivable) and a cc processing fee for -$3.00 (In CC Fees Expense account). Which SDK aggregate would do this for me? Any advice is appreciated.
  3. You may either set a global variable at opening the popover to save the popover name and then use it in your record creating script or hardcode the popover name in script parameters. I hope that above does make sense. It would be easier if you could send us a mockup file so we could better understand the issue .
  4. Why not using script parameters to pass the name of the button to the script?
  5. You did not specify the folder name. Try something like this: /C:/Users/Siroos/Desktop/test folder/1.pdf The formula to achieve above can be something like this: Get ( DesktopPath ) & "test folder" & "/" & GetContainerAttribute ( Yourtable::YourContainerField; "fileName" )
  6. Can you type the path you used here so we can have a better idea?
  7. I am so sorry for this. Can you please retry. I tested it on 2 computers and a cellphone and a tablet and they all opened almost immediately. Sorry Comment, That is my mistake. I was not aware of Community Articles, Tips, & Techniques section. I will post my next posts in that area.
  8. Peter, Thanks for clarification. I am agreed with you in this subject but, we should try to find workarounds for existing shortcomings for the time being. Hopefully FileMaker will work on improving Quick Find functionality and any other known problems, but my experience with new releases of FileMaker tells me that solving most of the known issues take ages for FileMaker. For example, it is years that we all crying for being able to send html e-mails with multiple attachments from FileMaker and what we got after all these years is ability to attach multiple attachments into FileMaker native email script step with no chance of sending html emails. I mean, who sends text base emails these days? We need HTML formatted emails to attract attention to our email content and engage recipients to interact with us. All in all; from my point of view, workaround solutions are so handy, specially for beginners and intermediate developers.
  9. Hi every one, I’d recently been asked by a client to build an alternative method for FileMaker Quick find. The native FileMaker quick find use word-based search while there are lots of situations that users need to search for only a part of a word like a wildcard search. Also, you can not use FileMaker Quick Find on solutions that requires hiding the status area or when you open your solution on FileMaker go. Here is a blog post explaining two different techniques used to achieve a user-friendly quick find solution in FileMaker: https://iavenue.ca/filemaker-quick-find-alternative/ I hope these methods can help you with developing more robust and user-friendly solutions. Please spread the word if you think it can help other developers too! I am open to any comment or advise to improve the file. Thank you.
  10. Have you tried "Create directory" option on "Export Field Contents" or "Export records" in FileMaker 17 instead of "Send Event? https://fmhelp.filemaker.com/help/17/fmp/en/index.html#page/FMP_Help/export-field-contents.html Export Field Contents [ Create directories:Yes ] Export Records [ Create directories:Yes ]
  11. Happy that you could solve it. Please mark the correct answe. Good luck.
  12. Do you have any script trigger on any of the fields causing the commit?
  13. You should not commit the record until your data entry is not finished. I would suggest to set up tab orders for all the files so you can easily navigate between fields without committing. As soon as you commit the sort will trigger.
  14. If the list is stored in a field of the same table, it means that it stores the list on each and every record, therefore performing a find would results showing all records.
  15. Hi Wickerman, Is re-login script set to run script with full access privileges? If that is the case, "Get(CurrentPrivilegeSetName)" returns [Full Access]. That is why it does not set the custom menu. I'd suggest to set a variable for "Get(CurrentPrivilegeSetName)" and see what it returns using data viewer and script debugger.
  • Create New...

Important Information

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