Orlando

Hi, Check your active state condition on the segments, matches the inactive state, the only time I have seen this occur with individual button segments is when its active and the active state has a different padding. -- Orlando

Hi, Does anyone know if FTPeek supports SSH Key Pair Files or in any way? We have built a system using FTPeek to upload and download data to a 3rd party SFTP site, all working great, except the 3rd party now want us to setup an SSH Key Pair and provide them the public key, and control the security from our side, but I am unable to get FTPeek to connect without errors. Has anyone done this? Many thanks for any help that you can provide. -- Orlando

Hi, I have got FTPeek working with another companys SFTP site, and all is going well, until I needed to connect to another server of theirs. If I use exactly the same function for SFTP, with correct IP Address username and password I get “Could not authenticate SSH client: FAILED” Another test of adding 990 to the IP Address “###.###.#.#:990” and specifying “ImplicitFTPS” I get an error “The remote computer does not appear to support the SSH protocol” I am able to connect using FTP Voyager with the same details, includeing "FTP over SSL (Implicit) Port 990" I have also tried the FTPS and get a “Read timed out” error. I am at a loss with what to do next, have also posted the same message to there IT department. Any help or advice will be very much appreciate Thanks -- Orlando

Position Title: Junior FileMaker Developer Description of Duties: We are currently looking for someone to join our existing team of 3 in-house developers as a Junior with a basic understanding of FileMaker Pro as a development platform for a four to six month contract. This is a good opportunity for someone who has been building databases in FileMaker at a basic level and wants to continue to develop their skills using FileMaker further and build on the knowledge they have. Bestinvest looks after over £4 billion of assets for its clients. It was founded 25 years ago and is backed by 3i. It offers a range of investment services from its online execution only service, Select, to investment advisory and investment management, as well as financial planning and tax efficient investment services. Bestinvest has won numerous awards for its services including ‘Self-Select ISA Provider of the Year 2011’ and ‘UK Wealth Manager of the Year 2011’ as voted by readers of the Investors Chronicle and Financial Times. Headquartered in Mayfair, London, Bestinvest has 20 regional offices with 200 staff. Location: London, UK Deadline: ASAP. Position: Full Time for 3-6 months Employment: In-House Skills Required: Pre-requisite Knowledge • Basic understanding of developing solutions using FileMaker Pro is necessary, training support will be provided but some understanding of the software in general is required. • Understanding of database design and data structure. • Creative background is a plus. Pre-requisite Attributes • Must have a can-do attitude and enthusiasm to learn to develop using our development guidelines, as well as being able to take training materials and learn on your own initiative. • Ability to complete tasks while under pressure • You must be able to work in a team environment, taking direction from your supervisor. • Good communication skills both written and verbal. Duties & Responsibilities • Working with the development team with day to day bug fixing and project work • Supporting the business by answering help desk calls and investigating potential issues and reporting to the development team. • The job will also include providing help-desk support duties for our internal system users, analysing system issues and solving or escalating where necessary. Compensation: To be discussed Contact Details: If you are interested in applying for this position please send your resume to the HR Team at Bestinvest recruitment@bestinvest.co.uk Disclaimer: FM Forums does not endorse or warrantee these positions please contact the poster for further information regarding the position particulars.

Hi I am using the SendEmailWithAuthentication funtion to send batches of email from my database, however when I input the body of the email as HTML source code, direct from Dreamweaver, the emails are more likely to be marked as SPAM as apposed to just inputting text into the field and using the GetASCSS function to convert it to HTML. Is there anythink I am missing or a particular way the HTML needs to be presented to not flag up as SPAM? Many thanks for any help you can provide Regards -- Orlando

Quite right Comment, I actually posted the wrong function. It does not need the reformatting at the start, but yours is still simpler. Thanks -- Orlando

Hi Jalz Here is a very simple Custom Function I use for this. It simply checks there is an @ symbol before a period ".". [color:blue]xCF_EmailValidationBasic ( email ) Let ( [ Filtered = Lower ( Filter ( email ; "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-_.@POSSABLE_USAGE{}~^?=/*'&" ) ) ; LocationAT = Position ( Filtered ; "@" ; 0 ; 1 ) ; LocationPeriod = Position ( Filtered ; "." ; LocationAT ; 1 ) // Locate the period, but only if it is after the @ symbol. ] ; // Start Calculation If ( LocationAT ≥ 1 and LocationPeriod ≥ 2 ; 0 ; 1 ) // End of If statement ) // End of Let statement I hope this helps -- Orlando

Hi beaglepro. The simpliest way to do this is to use the date functions, and adding 3 to the Month parameter. [color:blue]Date2 = Date ( Month ( date1 ) + 3 ; Day ( date1 ) ; Year ( date1 ) ) This will also take into account of the end of the year and move it on if necessary. Also if you want the first day of the month change the Day parameter to "1" I hope this does the trick -- Orlando

Hi there Dan, You should be able to see the licence key you have used for each copy on the info screen of the About Filemaker window. In FileMaker, top left on the OS menu, next to the Apple Icon, click on "FIleMaker Pro > About FileMaker Pro..." and then click on "Info" and this should give you all the details you are looking form. I hope this helps. Regards -- Orlando

Hi Mark As Mr_Vodka said, you need to make the calculation unstored, you need to make sure you have selected the "Do not store calculation results" option (see pic) As soon as I did this it worked fine. Regards

Hi spongebob I have had this problem in the past and it turned out to be an issue with the font assigned to that field. Double check the font used on the field is installed on your machine, and probably best to use a standard font such as Ariel if not. I hope this helps Regards Orlando

Hi Dave I think you want to replace the first line, Go to Related Record with Go to Field, and specify a field in the required portal. That is if you are starting from the layout with the portal on. Otherwise you will need to specify more about the context of where you are starting and the table structure, and what the script needs to achieve. Regards Orlando

Hi duggggy, You would need to create the related records using a script and set the ID based on a calc, I would also have a separate UniqueID for the related records as well as the generated one. I have put together a quick demo file for you to have a look at which, if I have read it correctly, should answer your question. I have put comments in the script which I hope explain it enough. I hope this helps. Regards Orlando Record_Increments_TEST.zip

Hi MelJ, Happy New Year! The Recursive Calculations (white paper and demo) files from Excelisys helped me loads with getting my head around recursive custom functions, and custome functions in general. It can be found here: http://excelisys.com/web/downloads/index.php I hope this helps. Regards Orlando

Hi habitude Here is a calulcation I use foer one of my applications that does the same thing. This uses two fields a Date Of Birth and a Cuttoff Date, and it will work out the persons age on the Age Cuttoff Date. Let ( [ dob = Date of Birth ; CutoffDate = Age Cutoff Date ] ; // Start of calculation If ( not IsEmpty ( dob ) ; Year ( CutoffDate ) - Year ( dob ) - Case ( CutoffDate < Date ( Month ( dob ) ; Day ( dob ) ; Year ( CutoffDate ) ) ; 1 ; 0 ) ; "" ) // End of If function ) // End of Let function I hope this helps Regards Orlando