Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Cable last won the day on August 15 2015

Cable had the most liked content!

About Cable

  • Birthday 04/29/1974

Profile Information

  • Industry
  • Gender
  • Location

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Windows 10, Server 2018

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

2,975 profile views

Cable's Achievements


Collaborator (7/14)

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

Recent Badges




Community Answers

  1. This one has me stumped. For years I have emailed links to iPads using the format: url:fmp://[serverurl]/[filename]?script=[script]&param=" & [parameter] It works great for hosted files. The iPad user opens their email, taps on the link, and Go opens the hosted file and performs the script. But now I have a local file saved on the iPad that records data while offline and then syncs it to a file hosted on the server. I want a user on the hosted file to be able to send a link back to the person on Go which will launch Go, open the local file, and then perform the script to go to the record in question. My usual URL format isn't working since it is a local file and not a hosted file. I thought I could just omit the server portion of the URL (like url:fmp://[filename]?script=[script]&param=" & [parameter]) but no joy. I tried a bunch of different permeations but always get errors that either [filename.fmp12] can't be found or ".fmp12" can't be found. How do I write the URL to launch a local Go file from email?
  2. Does anyone know if there is a sheetfed barcode scanner that could scan a bunch of barcodes on one piece of paper? I can use an iPhone or iPad to scan one line at a time but the concept is to feed a piece of paper with a list of barcodes and have all barcodes on the page scanned. Scanning them one at a time is not a practical solution.
  3. Yep, I'll be *******, that fixed it. I'm at a loss to explain but I'll take the win! 😆
  4. I don't think so. I might be onto something. I turned off indexing for the first number field to see if that would help. I was expecting it to put the zero in the first field not not any others. Instead, it put the zeroes in all of the field properly. Huh. However, I also paused the script at one point because I wanted to see something so maybe that had an effect. Running it again. Unfortunately, it takes almost an hour to run. So, testing is cumbersome!
  5. I have a script that distributes a quantity across various number fields using a "set field" script step. It is possible for the number being distributed to be zero. When I run the script with debugger, it puts zeroes in the number fields as expected. But if I run the script without debugger, it enters zeroes as null (blank). I have absolutely no idea why! I've tried modifying the script to specify the value with GetAsNumber and I've even tried adding to the Case statement (which determines the portion of the value to be distributed) that if the value to enter is not greater than zero to just enter a zero. Still makes the field blank. 99% of the time but not 100% of the time. I've checked to make sure all fields are set to be number fields. I've verified this happens for me in both FMP 18 and FMP 19 on two different Windows machines. For my use case there is a difference between a blank and a zero so it must be correct. Sometimes the field is legitimately empty. What should I be checking?
  6. Ok, I figure it out and I'll record the answer for posterity in case it happens to someone else. All of the fields in question had conditional formatting. Once I turned that off, entry was just fine.
  7. When I'm entering numbers in FileMaker Web Direct, they sometimes disappear! In the attached powerpoint screen recording, you can see me attempting to enter the number 12 in multiple fields while viewing records as a list. Sometimes it works but other times the number disappears after entry! Sometimes it only stores the 1 and deletes the 2. These numbers are being entered into a related table with "allow creating" turned on for the relationship. At first I thought it was just that there wasn't enough time for the record to be created but it even happens if you come back to an existing one. Anyone see something like this before or know what to do about it? I've tried script triggers to commit on record save or to commit on field exit but neither solved the problem. Disappear.pptx
  8. Based on your comment I did some testing and it turns out Paytrace does allow for a 30% increase. "Capture Amount can not exceed 30% of the original authorized amount."
  9. Ok, thank you for the explanation. Do I need to void an authorization if it is no longer needed?
  10. I want to be sure I'm using the correct procedure with Plastic when the captured amount is different than the authorized amount. Background: We're a wholesale plant nursery using FileMaker Web Direct for the customer portal on our website. In there, customers can place orders. I was asked to add the ability for customers to be able to pay for their orders with a credit card in the portal. The catch is, the final amount on their order will not necessarily match the amount when the order is placed. In fact, it almost never will. Sometimes the plant ordered has a problem (trimmed, caught a disease, got bugs) and can't be shipped so we check with the customer to see if they'll take a substitution. But, the main issue is freight. When we take the order we do not know how much it will cost to ship to the customer. Freight rates change daily and the total shipping rate can be shared if there is more than one customer on that truck (most truckloads do not go to just one customer). So the request from sales is to have the customer enter their credit card information and authorized with the current order amount plus an estimated freight rate. Then, the card would be charged the actual amount at the time of invoicing. They do not want the customer to log back in to pay the final amount. Current process is that the customer is notified of the final amount and says "yes" or "no" verbally or thru email. Our credit card processing vendor said the way to do this is to authorize an amount, then cancel the authorized amount and charge the actual amount. When reading the documentation for Plastic, I see that you can use authMode=AUTH_ONLY and then CCProcessAuthorizedPayment while referencing the previousTransactionId. It also notes, "The dollarAmount is not required to process the authorized payment. " My question is, can I do the CCProcessAuthorizedPayment step with a different dollarAmount than the AUTH_ONLY step to accomplish this goal? If not, do I need to do something to cancel the AUTH_ONLY or does it "timeout" after awhile?
  11. Thanks but none of that is even remotely helpful.
  12. Sure, if it was a date field. But this is a text field so that won't work.
  13. Ok, I think I understand. Like I said, create a relationship from the Inventory table to the bin table. Set the relationship to be the Bin in the Inventory table to relate to the Bin name and make that relationship "does not equal". But also set it so that the relationship does equal the key/foreign key for the item in inventory. Then, create a value list with the option "Use Values from field" and specify the BinName field. That will show you only bins where the item exists but excludes the bin it is currently in.
  • Create New...

Important Information

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