Jump to content

dwdata

Members
  • Content Count

    215
  • Joined

  • Last visited

  • Days Won

    2

dwdata last won the day on October 12 2015

dwdata had the most liked content!

Community Reputation

16 Good

2 Followers

About dwdata

  • Rank
    FileMaker Ninja (enlightened)

Profile Information

  • Title
    FileMaker/PHP/mySQL Consultant/Developer
  • Industry
    Software Development
  • Gender
    Male
  • Location
    Irvine, California U.S.A.

Contact Methods

  • Website URL
    www.dwdataconcepts.com
  • Skype
    dwdata

Recent Profile Visitors

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

  1. Hey gang, FileMaker has a deal going for a limited time . - buy one get one: https://store.filemaker.com/individuals I am not doing too much FileMaker these days (more cloud PHP stuff), but I would like to have a copy of this just in case my old clients need me to work on their systems. Anyone interest in going 50/50 on this deal. I'd be willing to pay my part via PayPal. Contact me PRIVATELY if you are interest. Thanks!
  2. dwdata

    How do I calculate GCD?

    Let ( [ $a = 1920 ; $b = 1080 ; $GCD = "Case(Mod($a;$b)=0;$b;Let([$c=$a;$a=$b;$b=Mod($c;$a)];Evaluate($GCD)))" ] ; Evaluate ( $GCD ) )
  3. Another approach is to script the process to APPEND or ADD an new. The key to retaining the position in the content field, is to not COMMIT the record by clicking out of the TEXT box. In this attached sample, you can high light any text or place your cursor somewhere in the field, and still add notes. Check it out. Did not test via WebDirect, but I used script steps compatible with WD by using the FILTER script steps. dwdc_addnote.fmp12
  4. dwdata

    CF to index a TimeStamp List

    Hi Siroos, The Timestamp List is not records but a text list in a calculated field, so unless I am missing something, your suggesting won't cover my needs. I was able to to script the LOGIC I need, nut cannot migrate it to a CF successfully: Set Variable [ $source ; Value: " 1/6/2018 9:00 AM¶ 1/6/2018 9:10 AM¶ 1/6/2018 9:40 AM¶ 1/6/2018 9:50 AM¶ 1/6/2018 10:40 AM¶ 1/6/2018 10:50 AM¶ 1/6/2018 11:00 AM¶ 1/6/2018 11:40 AM¶ 1/6/2018 11:50 AM¶ 1/6/2018 12:00 PM¶ 1/6/2018 12:10 PM¶ 1/6/2018 12:20 PM¶ 1/6/2018 12:30 PM¶ 1/6/2018 …" ] Set Variable [ $unit ; Value: 10 ] Set Variable [ $counter ; Value: 1 ] Set Variable [ $index_counter ; Value: 1 ] Set Variable [ $index ; Value: "" ] Set Variable [ $max ; Value: ValueCount ( $source ) ] Loop Exit Loop If [ $counter > $max ] Set Variable [ $index ; Value: List($index; $index_counter) ] If [ GetAsTimestamp (Substitute(MiddleValues ( $source ; $counter + 1 ; 1 ); "¶"; "")) = GetAsTimestamp (Substitute(MiddleValues ( $source ; $counter ; 1 ); "¶"; "")) + Time ( 0 ; $unit ; 0 ) ] Set Variable [ $index_counter ; Value: $index_counter + 1 ] Else Set Variable [ $index_counter ; Value: 1 ] End If Set Variable [ $counter ; Value: $counter + 1 ] End Loop Show Custom Dialog [ $index ] Once again, appreciate any help! Don ;o)
  5. I have a CF that builds a list of TimeStamp intervals: 1/6/2018 9:00 AM 1/6/2018 9:10 AM 1/6/2018 9:40 AM 1/6/2018 9:50 AM 1/6/2018 10:40 AM 1/6/2018 10:50 AM 1/6/2018 11:00 AM 1/6/2018 11:40 AM 1/6/2018 11:50 AM 1/6/2018 12:00 PM 1/6/2018 12:10 PM 1/6/2018 12:20 PM 1/6/2018 12:30 PM 1/6/2018 12:40 PM 1/6/2018 12:50 PM I want to analyze this list and generate an index sequence (resetting the index back to 1 if there is a break in sequence) 1/6/2018 9:00 AM = 1 1/6/2018 9:10 AM = 2 1/6/2018 9:40 AM = 1 1/6/2018 9:50 AM = 2 1/6/2018 10:40 AM = 1 1/6/2018 10:50 AM = 2 1/6/2018 11:00 AM = 3 1/6/2018 11:40 AM = 1 1/6/2018 11:50 AM = 2 1/6/2018 12:00 PM = 3 1/6/2018 12:10 PM = 4 1/6/2018 12:20 PM = 5 1/6/2018 12:30 PM = 6 1/6/2018 12:40 PM = 7 1/6/2018 12:50 PM = 8 So the CF will produce this list: 1 2 1 2 1 2 3 1 2 3 4 5 6 7 8 Any insights would be appreciated. Thanks! Don
  6. dwdata

    Psychic

    Haha - my animal was a kitten - oh well ;oP
  7. Hi DanS, If you are still needing support, please contact me off list at donw@dwdataconcepts.com. We offer flexible development and support plans that might fit your needs. Thanks and I look forward to speaking with you.
  8. dwdata

    Creating a slideshow

    What buttons are you concerned about? Could you mock up a quick example file with the button issue you are concerned about. I will take look a make a few mods to deal with it (or at a minimum make a few suggestions).
  9. dwdata

    Creating a slideshow

    Hi Robert, You could always just set a VAR and wrap your advance slide script steps with some logic that looks to that VAR: -- Start Slide Show -- (button behavior set to Halt Script) Set Field['image', 'first image'] Set Variable [$$pause, 1] Loop Pause/Resume Script ['5'] Exit Loop If ['last image'] If[$$pause = 1] Set Field['image', 'next image'] End If End Loop -- Pause SlideShow -- (button behavior set to Resume Script) Set Variable [$$pause, ""] -- Resume SlideShow -- (button behavior set to Resume Script) Set Variable [$$pause, 1] -- Stop SlideShow -- (button behavior set to Halt Script) Set Variable [$$pause, ""] Set Field['image', 'starting splash page'] This is quick and dirty, but you get the idea.
  10. Hi Guy, I made a few mods to your architecture. Please review attached file. Let me know if it needs adjusting. Good luck! ERC Registry v2 Mod_dw.fmp12
  11. dwdata

    Text Field with image aligned

    Sorry I am way late on this thread - not sure if you solved it. Why not just use "Conditional Formatting" to BOLD and CHANGE THE COLOR? Will that work? Good luck!
  12. Seems like you are missing the FIELD object: //CREATE FILEMAKER OBJECT $fm = new FileMaker($database, $hostname, $username, $password); //GET THE LAYOUT AS AN OBJECT. $layoutObject = $fm->getLayout($layoutName); $fieldName = "your_field_name'; //GET THE FIELD FROM LAYOUT AS AN OBJECT $fieldObject = $layoutObject->getField($fieldName); //GET THE VALUE LIST ATTACHED TO THIS FIELD $valueList = $fieldObject->getValueList(); // FOR TESTING echo "<pre>"; print_r($valueList); echo "</pre>"; Good luck!
  13. dwdata

    Delete Related Records, what if multiple parents exist?

    Hi Roeland, If the goal is to keep the REMARK if other ANSWERS use it, then you will need to add scripting with logic to know when you want the CHILD deleted. Please check out the attached file Good luck! sample.zip
  14. dwdata

    HTML in Web Viewer shows too wide

    Hi Robin, Take a look at this sample file. Is the HTML/CSS looking okay in it on your computer? Let me know. Good luck! html_wv.zip
×

Important Information

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