dwdata

Feel free to check out my OPEN SOURCE version of Appointment 1.0v9. FULLY UNLOCKED and CUSTOMIZABLE Resource Calendar module. http://appointment10.com Good Luck!

Hello Group, I have been working FileMaker for 22 years and building custom web systems for the last 8 years in PHP/mySQL. Recently, my company has hit a dry slump (a few larger projects have pause development and the projects in the pipe are delaying) and I am current putting out a few feelers letting people know I am available for sub-contracting or a sharp shooter to get you over the hump. Please contact me PRIVATELY, if you are interested in my services. Thanks!

Looks like COMMENT added a simple LOOKUP scheme. This replaces the entire field. If that is what you need, then go with that. If not, please specify what needs to change. Thanks!

Here is a quick little demo on how to INSERT TEXT into an existing text field based of the last Position of your cursor in the text field. A few key points: 1) There are some script triggers that reset and set CURSOR POSITION. a) OnRecordLoad - I set start and end to NULL (Warning - you must click into the TEXT field first) b) OnObjectExit - I set start and end of last cursor position. This includes if you selected a string in the text field. 2) Relationship to Terms to allow the selection of a term and set it in the INSERT POINT. Selectable from a global text field formatted as MENU displaying values of the Terms. Feel free to tear it apart and ask questions. InsertParagraph_dwdc.zip

Sorry Lola - Did you figure this out? I don't check the site much these days and I did not get an email echoed that you replied. So did you just want to total each column? I added that. Hopefully this helps. If not please let me know! HoursRev2.fmp12

Hello Lola, I added a new table that stores your ProjectCodes. Then a few calculated fields to streamline the report you are trying to generate. Check out the last LAYOUT I created. As far as Isolating Users, simply populate the gUser field accordingly 😉 Good Luck!!! Hours.fmp12

Maybe from a financial/labor standpoint, it might be better to use something that already exist. I just "Googled" searched, found this product, did a rough browse of site. Looks feature packed and web-based. http://www.bandhelper.com Good luck!

Thanks COMMENT! With a little fudging I got it working with your suggestion. Happy New Year!!!

Hi Gang, I am reaching out to see if anyone can assist (or maybe point me in the right direction) with some ExecuteSQL() issues I am having in my my next version of my product. I want to execute a query like the following: SELECT code FROM Appts WHERE appt_id IN (’14’,’10’,’8’,’9') ORDER BY FIELD(appt_id, ‘9', ‘10', ‘8', ‘14’) I have tried several times for this to return a working result with NO LUCK. Do you know if FMP allows this sort of query or does it fall short. Appreciate any help. Thanks!

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!

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 ) )

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

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)

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

Haha - my animal was a kitten - oh well ;oP

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.

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).

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.

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

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!

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!

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

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

Hey gang, Dealing with a little quirky report part issue in FileMaker. I am wondering how other developers deal with this. Below is the use case scenario and attached is a sample file I zapped up. ISSUE: I have a simple List Report (Header, Body, Trailing Grand Summary, and Footer). Sometimes, depending on the quantity of records in the found set, the Trailing Grand Summary breaks to a new page with NO BODY ROWS. This is quite confusing to the recipient. It would be nice to have at least one row present in this case for continuity purposes. I am wonder if someone has a slick way to cause that last record to push to the next page if the Trailing Grand Summary is going to be by itself. If the BODY part was fixed, I could group the records and add a sub-summary (with page break after occurrence) to push the next record to next page. When the body height varies via field sliding this does not work and falls short. Any thoughts on this would be greatly appreciated. Thanks! tr_grand.fmp12