lutfishah

Perfect @OlgerDiekstra you did it It works. Great thanks And thanks to @comment as well

Sorry, it didn’t work

Thanks for your reply Correct that Conditional formatting is not a validation but we just are using it for visual validation that if a value is incorrect then it should only highlight it by filling a red colour. Please see my code below. Case ( Filter (Left(myfield ; & Middle(myfield ;6; 4) & "-" & Middle(myfield ;11; 4) & "-" & Right(myfield ; 4); "abcdefghijklmnopqrstuvwxyz_@!#$%&'*+/=?^_`{|}~") ; 0 ; 1) = 0 or If (Length ( myfield ) = 19 ; 1 ; 0 ) = 0 and IsEmpty (myfield ) ≠ 1

Dear All, I am trying to put a conditional formatting validation which turns Red when the value is entered wrong. Basically all my tries have failed so I would like your help here. The criteria of entering a value is xxxx-xxxx-xxxx-xxxx 1111-2222-3333-4444 1. Length of value is = 19 OR this should be a 16 digit number, in groups of 4 separated with dashes 2. Non-Digits characters are not valid. Please could you help me with this and I will really appreciate. Many thanks Regards Lutfi

Dear All, I'm struggling with the "open url" script step where I am trying to switch between a FileMaker (v17) database in web direct to another website. But rather than opening the web page in the same tab it opens up a new tab. Is there any way to open a web site in a browser in the same tab when using Open URL script step. Many thanks for your help

Hi Nuos, Thanks very much for your help. I have managed to make it work. So for the time being I'm fine. Sorry I couldn't reply to any of the posts as I was away. Best regards.

Sorry about that. Yes all invoices per hour per calendar date. Basically current date. Yes I have the time field. So lets say there are sales made Date: 18/03/2015 Invoices 09:00 --- 100.00 09:05 --- 200.00 09:30 --- 50.00 10:00 --- 90.00 10:15 --- 300.00 ... so on Totals Per hour 09 hrs = 350 10 hrs = 390 ... Thanks so much ... I will quickly create a test file for you. Cheers

Thanks for your reply. Would you know a better way of calculating the sums of invoices per hour. I need a calculation please.

Hello, I need a bit of help with my filemaker database. I'm not really good at using Filemaker charting system. I want to display the hourly sales in a chart. So if someone could please let me know a better way of getting totals of the invoices per hour of one day and then displaying them on a chart per hour. so x-axis = 09:00 10:00 11:00 12:00 13:00 ..... y-axis = the totals of the invoices. Many Thanks for you help

Hi, I'm creating a POS (Point of sale) database using Filemaker on a Windows (PC). Do you guys know which hardware to use? I'm in the UK Basically I need to know which Kiosk screen, Cash Drawer, Thermal Printer, Barcode Printer and Debit/Credit Card Machine(chip and pin / EMV) I should use. If someone has tried any plugins please let me know. I will really appreciate it. Many THanks Lutfi

Thanks Cabinetman for the nice idea but please can you show me how to set a variable on xsl : ) Thanks

Hi Folks, I am trying to export some data in xml format from filemaker using XSLT. I want to display the same data in three places on the xml. I was displaying the data once by using for-each tag. <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <xsl:for-each select="fmp:COL[3]/fmp:DATA"> <marker> <name> <xsl:value-of select="."/> </name> <xsl:variable name="pos" select="position()" /> <comment> <xsl:value-of select="../../fmp:COL[6]/fmp:DATA[$pos]"/> </comment> <in> <xsl:value-of select="../../fmp:COL[4]/fmp:DATA[$pos]"/> </in> <out> <xsl:value-of select="../../fmp:COL[5]/fmp:DATA[$pos]"/> </out> </marker> </xsl:for-each> </xsl:for-each> But when I want to export the above data in three different places in the same XML, It fails. I'm not an XML person so my apologise in the begining if I'm not clear. Thanks very much in advance for your help. <?phpxml version="1.0" encoding="UTF-8" ?> <xsl:stylesheet version="1.0" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" exclude-result-prefixes="fmp"> <xsl:output method="xml" indent="yes" /> <xsl:template match="/"> <xmeml version="1"> <sequence id="test_clip"> <name>test_clip</name> <duration>7704</duration> <rate> <ntsc>FALSE</ntsc> <timebase>25</timebase> </rate> <timecode> <rate> <ntsc>FALSE</ntsc> <timebase>25</timebase> </rate> <string>01:00:00:00</string> <frame>90000</frame> <source>source</source> <displayformat>NDF</displayformat> </timecode> <in>-1</in> <out>-1</out> <media> <video> <format> <samplecharacteristics> <width>1024</width> <height>576</height> <anamorphic>FALSE</anamorphic> <pixelaspectratio>Square</pixelaspectratio> <fielddominance>none</fielddominance> <rate> <ntsc>FALSE</ntsc> <timebase>25</timebase> </rate> <colordepth>24</colordepth> <codec> <name>H.264</name> <appspecificdata> <appname>Final Cut Pro</appname> <appmanufacturer>Apple Inc.</appmanufacturer> <appversion>7.0</appversion> <data> <qtcodec> <codecname>H.264</codecname> <codectypename>H.264</codectypename> <codectypecode>avc1</codectypecode> <codecvendorcode>appl</codecvendorcode> <spatialquality>1023</spatialquality> <temporalquality>0</temporalquality> <keyframerate>0</keyframerate> <datarate>0</datarate> </qtcodec> </data> </appspecificdata> </codec> </samplecharacteristics> <appspecificdata> <appname>Final Cut Pro</appname> <appmanufacturer>Apple Inc.</appmanufacturer> <appversion>7.0</appversion> <data> <fcpimageprocessing> <useyuv>TRUE</useyuv> <usesuperwhite>FALSE</usesuperwhite> <rendermode>YUV8BPP</rendermode> </fcpimageprocessing> </data> </appspecificdata> </format> <track> <clipitem id="testclip3 "> <name>testclip3</name> <duration>7501</duration> <rate> <ntsc>FALSE</ntsc> <timebase>25</timebase> </rate> <in>0</in> <out>7501</out> <start>203</start> <end>7704</end> <pixelaspectratio>Square</pixelaspectratio> <enabled>TRUE</enabled> <anamorphic>FALSE</anamorphic> <alphatype>none</alphatype> <masterclipid>testclip3 1</masterclipid> <logginginfo> <good>FALSE</good> </logginginfo> <file id="testclip3 2"> <name>testclip3.mov</name> <pathurl>file://localhost/Users/itsupport/Desktop/testclip3.mov</pathurl> <rate> <timebase>25</timebase> </rate> <duration>7501</duration> <media> <video> <duration>7501</duration> <samplecharacteristics> <width>1024</width> <height>576</height> </samplecharacteristics> </video> <audio> <rate> <timebase>48000</timebase> </rate> <trackcount>2</trackcount> <samplecharacteristics> <depth>16</depth> </samplecharacteristics> </audio> </media> </file> <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <xsl:for-each select="fmp:COL[3]/fmp:DATA"> <marker> <name> <xsl:value-of select="."/> </name> <xsl:variable name="pos" select="position()" /> <comment> <xsl:value-of select="../../fmp:COL[6]/fmp:DATA[$pos]"/> </comment> <in> <xsl:value-of select="../../fmp:COL[4]/fmp:DATA[$pos]"/> </in> <out> <xsl:value-of select="../../fmp:COL[5]/fmp:DATA[$pos]"/> </out> </marker> </xsl:for-each> </xsl:for-each> <sourcetrack> <mediatype>video</mediatype> </sourcetrack> <link> <linkclipref>testclip3 </linkclipref> <mediatype>video</mediatype> <trackindex>1</trackindex> <clipindex>1</clipindex> </link> <link> <linkclipref>testclip3 3</linkclipref> <mediatype>audio</mediatype> <trackindex>1</trackindex> <clipindex>1</clipindex> <groupindex>1</groupindex> </link> <link> <linkclipref>testclip3 4</linkclipref> <mediatype>audio</mediatype> <trackindex>2</trackindex> <clipindex>1</clipindex> <groupindex>1</groupindex> </link> <fielddominance>none</fielddominance> </clipitem> <enabled>TRUE</enabled> <locked>FALSE</locked> </track> </video> <audio></audio> </media> <ismasterclip>FALSE</ismasterclip> <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <xsl:for-each select="fmp:COL[3]/fmp:DATA"> <marker> <name> <xsl:value-of select="."/> </name> <xsl:variable name="pos" select="position()" /> <comment> <xsl:value-of select="../../fmp:COL[6]/fmp:DATA[$pos]"/> </comment> <in> <xsl:value-of select="../../fmp:COL[4]/fmp:DATA[$pos]"/> </in> <out> <xsl:value-of select="../../fmp:COL[5]/fmp:DATA[$pos]"/> </out> </marker> </xsl:for-each> </xsl:for-each> <filter> <effect> <name>Distort</name> <effectid>deformation</effectid> <effectcategory>motion</effectcategory> <effecttype>motion</effecttype> <mediatype>video</mediatype> <parameter> <parameterid>aspect</parameterid> <name>Aspect</name> <valuemin>-10000</valuemin> <valuemax>10000</valuemax> <value>33.3333</value> </parameter> </effect> </filter> </sequence> </xmeml> </xsl:template> </xsl:stylesheet>