Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About milky

  • Rank
  • Birthday 03/17/1956
  1. milky

    Multiple portals

    Thanks Matthew, I was hoping to display the portal on the task layout with records from the task table. Is this possible?
  2. milky

    Multiple portals

    Hi everyone, I have a table called tasks and I would like to show 4 portals on the screen side by side which show the found set of tasks for the 1st quarter, 2nd quarter, 3rd quarter and 4th quarter. Each task has the following fields - taskID, Task, Contractor, Quarter. How do I achieve this and what do I use as the join? Thank you in advance
  3. Hi everyone, I would like to be able to have multiple form letters that can be sent to all owners in my database. I can achieve this by having one form and putting merge fields on it. If I want anymore form letters I copy the first layout and rename it and then use a button to go to this layout. How can I create more than one form letter? Is it done via a portal? Also once this is accomplished can I do a find and then only send the form letter to the found set? Any help would be appreciated (including as much detail as possible for this newbie) Thanks in advance.
  4. Hi all, I created a text field that uses a calculated value and I would like a way to update all 1000 records in my database instead of going to the original field and typing the data in so the calculation works. Any ideas?
  5. Hi everyone, is it possible to create a script that uses the date in a field and opens Outlook and creates an appointment for that particular date. Any help would be appreciated.
  6. Hi everyone, I have 2 fields called OwnerDate and TenantDate and I would like to use these 2 fields to create a popup reminder when it is 60 days prior to each of these dates. There are approximately 300 Owners and Tenants that would need to be checked. I would envisage that the script would run either at start up or by selecting a button. If anyone could help with examples, I would really appreciate the assistance. Thanks in advance for any advice or assistance.
  7. Thanks Laretta, Works a treat. Any way I can post my program. It is 5mb as a zip and the limit here is 1mb. Would like you to have a look. On another matter, is FMP7 compatible with vista 64 bit?
  8. Thanks Laretta, What should the correct syntax be? Milton.
  9. Thanks BCooney, The problem I have is as shown in the attached graphic Milton
  10. Hi all, I have been trying to utilise the following (see below) to auto format phone numbers for Australia. Also a dumb question.... where do I attach the calculation... to the feild I want formatted and if so do I change it from a text field to a calculation field or do I use validate by calculation? Thanks in advance Milton. [color:blue]//Restrict input to digits-only Let ( ( num = Filter ( number ; "0123456789" ) ; Phone = /* Vary occurrence of spaces, depending if the phone number features 10 digits... */ Case ( Left ( num; 1 ) = "0" or Left ( num; 4 ) = "1800" or Left ( num; 4 ) = "1300"; Left ( num ; 4 ) & " " & Middle ( num ; 5 ; 3 ) & " " & Middle ( num ; 8 ; 3 ) ; //or 6 digits... Length ( num ) = 6; Left ( num ; 2 ) & " " & Middle ( num ; 3 ; 2 ) & " " & Middle ( num ; 5 ; 2 ) ; // or the default format for 8-digit numbers Left ( num ; 4 ) & " " & Middle ( num ; 5 ; 4 ) & // if it exceeds 8 digits, assume it is an extension If ( Length ( num ) > 8; " x" & Middle ( num ; 9 ; 99 ) ; "" ) ) ] ; // Allow ## ## ## formatting for 6-digit numbers e.g. "13 13 13" If ( Length ( Num ) < 8 and Left ( num ; 2) ≠ 13; // if number is too short [less than 8 digits] display a message in red as error TextColor ( "Too few digits" ; RGB ( 255 ; 0 ; 0 ) ); // Reset the default colour if the phone number is valid TextColor ( phone ; RGB ( 0 ; 0 ; 0 ) ) ) )
  11. Bruce, My file is 5mb as a zip file and the limit here is 1 mb. Any other way to pos it? Milton
  12. Which version of 10 do you need to create stand alone or kiosk mode? I want to upgrade but can't find any mention of which one? Milton
  13. LaRetta, I finally got it to work!! What I was doing wrong was setting up 2 self join tables with one of each of your relationships instead of setting the relationships in the Edit Relationship window. Now........ Is it possible to have in the gStart field the first day of the month DATE altomatically entered as well as TODAYS DATE automatically entered in the gEnd field? This would automatically only show this months invoices by default. This would be of great benefit to me. On another matter, in another db program there used to be a selection to do an action when the user left the field or pressed enter. Is there any thing like that in FMP? Thanks for all your help. Milton.
  • Create New...

Important Information

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