Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About nox

  • Rank
  1. Great! I'll try with script triggers first and see if that works alright. Thanks again!
  2. Thanks! This looks to be exactly what I need. Now what would be the best way to perform this function on my text? I imagine I could run it with script triggers or maybe when I generate contract for printing?
  3. Hi, I've run into a brick wall while trying to develop my solution. I'm making a simple contracting managment system with couple of tables "contracts", "contract_articles" and "contracts_lines" similar to regular product/invoicing system. However there is one special feature I want when creating new contracts: I want to automatically insert client and price data (from external table) into contract articles where appropriate. For example I would select "Price and payment" article from contract_articles table and insert price into article text. First I thought I would be able to use so
  4. Ah that was so easy! Doh! Thank you both guys!
  5. I'm trying to use this calculation to find out if we are on the last record in found set or not. But somehow it doesn't work. I can't figure out why. The field is dynamically generated so it can be reused on other tables. Let( $field = Get ( LayoutTableName ) & "::ID"; If ( GetNthRecord ( $field; Get ( RecordNumber ) + 1) = "?"; 1;0) ) Thanks in advance for your help!
  6. Thanks for all your answers. I will go with one table solution and see how it goes. cheers!
  7. Thanks David, I was leaning more towards the one table solution also. What is the best way to do this? Performing find for relevant records on layout enter or some other way?
  8. I'm just beginning with FM myself also, but I think the solution to your problem is a simple use of conditional value lists. check this topic: http://www.fmforums.com/forum/showtopic.php?tid/181645/ or search for "conditional value list" in forum.
  9. Hi all, I am working on quite a complex invoicing solution. There are 3 departments that issue invoices - each need a little bit different invoice layout and some different fields and different related tables. For example one department deals only with products so it will pull products from the separate products table. Second department deals only with services. So it will not use any products, but will write their own description of service into invoice. There is third department similar to second but also needs a little bit different layout/fields. They all should follow
  10. Hi, thanks for the example. Though it's not exactly what I had in mind. What I want is a button "create invoice from quote" which would open a new window where one would choose which quote they want to make invoice from. I did a couple more tests and here is the script I came up with. But I'm not sure I'm doing everything correct. From invoice layout I launch this script: - set current project ID into variable - launch new window with quotes layout - perform find for quotes that match project ID - pause script - let user select the quote and set it's ID to variabl
  11. Hi everyone, new to FM and trying to develop invoicing/project tracking solution. I got stuck at this point now where I could use some hints about how to tackle this problem. Let me explain a simplified version of the system in short: user creates quote for the project and later when the project is finished wants to create invoice from this quote (by reusing all the data from the quote). What I would like to do is to have a button that would bring up all the quotes related to the project and allow them to choose the one he wants to build the invoice from, so basically using it as a
  • Create New...

Important Information

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