Jump to content


  • Posts

  • Joined

  • Last visited

About aldipalo

  • Birthday 02/15/1944

Recent Profile Visitors

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

aldipalo's Achievements


Mentor (12/14)

  • First Post
  • Collaborator
  • Posting Machine Rare
  • Conversation Starter
  • Week One Done

Recent Badges



  1. DJ Thanks for your thoughts and advice. They are very sound. If I've learned anything in my years it's that I can always learn something new. Just a little history on me. I've been in my own business for 40 years. I developed and ran a successful Job Board in the 90's, had a web development and hosting business for about 4 years and also ran an email marketing business during that time. However, I've never actually sold a piece of software and given the horror stories I've heard I just want to make sure I've thought of every contingency before I speak to an Attorney. I learned a long time ago that Attorneys are not business people. They are there to set down in legalize what you, the seller, and they, the buyer are agreeing to. I also learned that if you want to make the deal happen hire an Attorney who is a Deal Maker not a Deal Breaker. Some of the Condo's where the software will be installed are single users and others will be max 2 - 3 users. I tried to steer the buyer away from a Run Time version because I felt it would be a problem when they start asking for changes, which, i feel will be inevitable. Since I'm a single user I've never talked to anyone at FM. What type of help is available from them? John: He alluded to this, but, there's over 25,000 Condo's and HOA's in Florida alone so do I want to give up ownership? Good thought! Only issue is he wants his name on the package he "Gives" to his customers. (Guess I need to have that in writing.) Probably, what they'd ultimately like to do. Can you expound on this some more? How do I define what the core system is, etc.? Anyone else with some more sage advice?
  2. I recently developed a Condominium Management application and was paid well for my time. The client also allowed me to maintain the application as my own and I am free to market it. So, I got into a chat with the President of another condo association and they referred me to their Property Management Org. I had a great meeting with them today and they want to install the app in all 100 condo and homeowner associations, with 15,000 units, that they manage. Sounds great, but, here's the catch ... they want me to package it as theirs and give them the ability to have someone else work on the app if I am no longer available. Look at my age. They also asked that I install it in one of their largest customer sites for a 30 day demo. So, they asked me to put together a contract that includes pricing. They agreed to sign a non disclosure agreement as well as a Software license agreement and a Confidentiality agreement. They also want me to give them a price to customize the software to their needs if necessary. I told them it would be an hourly charge. Here's my concerns: * What do I charge them. The original client paid me almost $ 10K. They have 240 units. * Do, I put together some type of individual pricing or a Flat rate for the entire company? * It will require my installing the software at each site and 3 days - 1 week of on-site training. Do, I include in the overall price or charge by the hour/day? * What do I need to worry about and what am I not thinking about? (See my signature.) * Do I put a 30 or 40 day bomb in the demo package, just in case, and what's the best way to do that? I look forward to all constructive criticism and advice. TIA Al
  3. In the Send Mail script step you will see a box "Collect addresses across found set." So if you do a search to isolate those people you wish to send to you can then send one email to all contacts in the found set. One caution though. I believe your recipients will see all the addresses. I would check this out before sending. hth
  4. aldipalo

    Portal Help

    Welcome to the forum. Without knowing what "Your Database" it makes it difficult to tell you what you need to specifically do. Why don't you tell us what you are trying to accomplish and we may be able to give you more help. A clone of your basic file would also be helpful. Also, take apart the file you uploaded and take a look at what the relationship is between the 2 tables. That will give you an idea of how the developer accomplished the join. HTH
  5. How about a calculated field c_DateofInvRef: Case( IsEmpty(DateField;""; DateField & " " & InvoiceField ) Go to storage and set to Unstored, recalculate. hth
  6. Welcome to the Forum. It's possible to call different scripts based on certain criteria. With creative uses of variables and If Statements and script parameters your possibilities are pretty endless. Exactly what are you trying to accomplish? Please give us a more information.
  7. First, I would suggest you do a little reading before getting to deep in to your database design. Poor structure has a way of coming back and kicking you. Go here: http://www.foundationdbs.com/downloads.html and read 'White Paper for beginners and database design.' They are 2 well written articles that will help you tremendously. It is generally considered bad design to use anything other than serial ID's as your key fields in relationships. Whenever you use a name field, of any kind, you stand the risk of someone changing the name on one side of the relationship and as soon as that is done the relationship is broken on ALL related records on the other side. In general naming conventions you will often see pk_ (Primary Key) and fk_ (Foreign Key) used. e.g. pk_NotesID -> fk_NotesID I think once you read the above references you will have a better feel for setting up your relationships which will help you solve your problems. I would also suggest that you look at Kevin Frank's Anchor-Bouy model for relationships. http://www.kevinfrank.com/demo-files-user-group.html Don't despair we all started here and we'll be happy to help you get through it all. hth
  8. aldipalo

    Two Screens

    You should be able to open your window to the width of both screens and then set the file1 to the width of screen1 and file 2 to the width of screen2. When I had the luxury of 2 screens 'In the good old days' i would do that with other programs that didn't allow 2 occasions of the same program at the same time. Since I don't currently have that set up now I can not test it for you, but, in principal it should work.
  9. Look at "Conditional Formatting." Right click on the field and click on 'Conditional Formatting', then set your formula and set the background and text colors if the formula is true or false. e.g. In Field A create a conditional format formula Field b = Set Text to be Red or Background to be Red or whatever. hth
  10. Has anyone used this script step to set up Activity Reminders. Can you have multiple scripts waiting in the wings? Currently, I use scriptfire for this, but was hoping to find a native way to do it in FM. I look forward to hearing your ideas/suggestions.
  11. Here's a file showing you how to do all 3 methods. hth **************************** I saw the 7 problem after I created this for you. You can use DoScript EventScript Scriptfire to do the script trigger. It's a little more complicated. Prior to FM10 I used scsriptfire. Tabs and naming objects as well as script variables (I believe) all became available after FM7. There were many workarounds for tabbing and you should be able to find some threads here on the forum. How many copies of FM 7 are you talking about. Perhaps, if management really wants these features, you should consider upgrading. You will also find a number of examples on Ray Cologans site: http://www.nightwing.com.au/FileMaker/demos.html#fmp7 Filemaker Magazine: http://www.filemakermagazine.com/videos/15-minute-tabs-the-quickest-way-to-make-a-tabbed-interface.html hth Dissappearing_Field.zip
  12. Welcome to the forum. We're all very happy to help. You may want to consider some tabs on your layout rather than create an entirely new layout. Basically, you are correct your script would look something like: If(ValuelistField = "Widow") Go to Layout(Widows Layout) EndIf If you saw a need to use this script to go to other layouts from this field you could use a 'Variable' Set Variable($Trigger;ValueListField) If($Trigger = "Widow") Go To Layout(Widows Layout) EndIf If($Trigger = "Bachelor") Go To Layout(Bachelors Layout) EndIf // you can repeat this as many times as needed In version 10 you would right click on the valuelistfield and click on "Set Script Triggers" then choose how you would like the script to be activated. Probably on modification, but, that's a personal choice. Please don't hesitate to come back and ask more questions. That's how most of us got started. hth
  13. aldipalo

    Own template ?

    Have you looked at Matt Petrowsky's Scriptology? http://www.filemakermagazine.com/index.php It gives you everything you need for a reasonable price and you can download a free copy to see what is there.
  14. Btw, if you want to check each record to see if a specific field is equal to another rather than hard code the new field data you should add the variable in to the loop. Go To Layout(ListLayout) Sort Records() Go to Record/Request(First) Set Variable($ChangeToData;LookintoField) Loop If(FieldtoChange<>$ChangeToData) Set Field(FieldToChange;$ChangeToData) Go to Record/Request(Next; Exit after last) else Go to Record/Request(Next; Exit after last) EndIf Set Variable($ChangeToData;LookintoField) EndLoop
  • Create New...

Important Information

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