Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About JTSmith

  • Rank

Profile Information

  • Gender

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I'm struggling... does anyone have a quick/easy way to format the below as a standard date? Input: 2018-11-14T11:31:26.113 I would like it to format to: 11/14/2018 so I can use filemaker to sort by date, etc. Any help would be greatly appreciated!
  2. OK, I'm using FM16 and trying to figure out an API call. I'm not an expert when it comes to APIs. I have a shopify store, and I can use Insert from URL to get the JSON info on each order. I want to be able to "PUT" and upload parts of the order. Every order has a "Note" field that I can add notes. Per the shopify API documentation, to add an order note, you do the following: Add Note to order PUT /admin/orders/#{id}.json { "order": { "id": 450789469, "note": "Customer contacted us about a custom engraving on this iPod" } } Can someone help me with what I put in the cURL options area? Any help would be appreciated. I think I have the URL and Target figured out. Thank you!!
  3. Yes, couldn't find one that works with my format
  4. I'm hoping someone can help me... I'm trying to convert the following Timestamp to Date. The timestamp format is: 2017-10-30T14:47:12-06:00 . I've tried to simply use the Left function to make it 2017-10-30, but I still can't convert that to a regular date. Any advice? Thank you!
  5. I have data which has the problem where it's duplicated text in the fields Example: Bob SmithBob Smith David JonesDavid Jones Henry MorrisHenry Morris I just want to delete the duplicate in the field so it just shows Bob Smith, not Bob SmithBob Smith. Any help would be greatly appreciated!
  6. Yes, my goal is to calculate next month's rent unstored. So if their move date is 12/15/2014, it should calculate 15/31 * rent, but if their move out date is 1/1/2015 on, it should be equal to rent. Or if it's prior to 12/1/14, it should be zero.
  7. Thanks. This is what you helped me with on daily rates: Let ( [today = Get ( CurrentDate ) ;m = Month ( today ) ;y = Year ( today ) ;start = Max ( JOBS::move_in ; Date ( m + 1 ; 1 ; y ) ) ;end = Min ( JOBS::move_out ; Date ( m + 2 ; 0 ; y ) )] ; JOBS::rent * Max ( end - start + 1 ; 0 )) I can't seem to figure out how to do the same with monthly... Your calc works great for determining number of days in the next month, thanks. Any advice on how to calculate days they are renting? Sorry for asking, I just can't seem to figure out the calc...
  8. I have a calculation I use to know how much rent to bill for the next month (thank you Comment on that one). I am switching my rental rates from daily to monthly, so I need it to work like this: Rent: $1,000 MoveOut: 12/15/2014 It's November, so next month is December. December has 31 days, thus the rent is $32.26 per day ($1,000 / 31), times 15 days equals $483.87. I can't seem to figure out how to count the number of days in the next month... Also if the move out is anytime after December, for example, January 5th, then the rate would be $1,000 since it's a full month's rent. Any help would be GREATLY appreciated!
  9. Thanks. My issue is I have attachments that I use with SendMail... I have reasons why I can't use server send, I need it to open in the client. Not sure how to fix it. I have Outlook 2013 on my main machine, but not Windows 7. Stressful... Thanks for the help though, unless you know how to configure an attachment with Open URL...
  10. I have 2 machines, the one remotely using my FM13 Advanced copy never had any issues. The computer died, and I moved FM13 to a new machine with Windows 8 and Outlook 2013. Every time the SendMail script runs it crashes FM on that machine. It opens Outlook, and as soon as you hit Send on the email, FM sticks constantly with the "thinking" spinning circle until it crashes. I setup a test file which simple had a SendMail blank script, same problem. Any idea on what the problem could be? Any help would be greatly appreciated! ***Update, Outlook 2013 is 32bit.
  11. I know, I have learned my lesson on checkboxes. Thanks for the help, worked like a charm!
  12. I have a field called Sizes, which is a check box. The options are Studio, One / One, Two / One, Two / Two, Three / Two. I'm trying to make a calculation field, export_sizes, which would be in this format: One Bed, Two Bed, Three Bed I don't care about studios. But if a record has sizes one/one and three/two, it should be calculated at "One Bed, Three Bed". If a record has sizes two/one and two/two, is should be calculated at "Two Bed". This should be simple, but I can't seem to make sense of it... Any help would be greatly appreciated.
  • Create New...

Important Information

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