Jump to content

Nikos Gewrgioy

Members
  • Content Count

    13
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Nikos Gewrgioy

  • Rank
    member
  1. Nikos Gewrgioy

    Different Invoice ID

    Thank you. I found the way.
  2. Nikos Gewrgioy

    Different Invoice ID

    Thank you very much. I will make two tables at this time. Could you help me with another one problem? I have one date field with auto enter date and one with auto enter time. I want to put the date field in another one field which called Date short without separators and the same for the time field to another one field which called Time short. For example like this: auto enter date field: "19/11/2013" to date short field: "20131119" Auto enter time: 13:15 to Time short: "1315" Could you help me with this?
  3. Nikos Gewrgioy

    Different Invoice ID

    Thank you very much. I need the Invoice ID only for me, only to I know how many Proformas and Original Invoices have made. In final PDF Invoice I would like to send only the proforma number or the Original number. I read the post from Vaughan but I cannot understand the way. I am sorry, I have no experience in Filemaker. Please, could you help me to do this on Invoice from starter solution or in file that I have uploaded? I will be grateful your help. Nikos
  4. Nikos Gewrgioy

    Different Invoice ID

    Thank you very much. I made it with different way and it works fine. Â I made Proforma Number field with auto enter data, then a calculation field "If proforma" with function If ( Type="Pro Forma"; SerialIncrement ( If Proforma; 1) ) and then a Sum field to count the If proforma field. Â I uploaded the file for check. I don't care for the Incoice ID, only for the Proforma No and Original No. https://www.dropbox.com/s/hh0ir90zxe67ff5/Invoices%203.fmp12 Â Please tell me, from your experience is it reliably?
  5. Nikos Gewrgioy

    Different Invoice ID

    Please, could anyone to help me?
  6. Nikos Gewrgioy

    Different Invoice ID

    Matthew thank you for your quick response. Sorry, my English is not good. I will try to explain you as well as I can. I uploaded the file to understand it. http://www.dropbox.com/s/xndm5fknaug7wmp/Invoices.fmp12 Go to Invoice details, you will see two fields, proforma No and Original No. When I select from the invoice type the Proforma option I would like to increase the Proforma No by 1 and when I select from the Incoice type the original option I would like to increase the Original No by 1. I hope to understand what I want to do. Could you help me to do this? Thank you in advance!! Nikos
  7. Nikos Gewrgioy

    Different Invoice ID

    Hello, I am trying to make an Invoice template with different Auto number for Proforma, and different for original like Ivoice ID when I press new record but, when I select proforma, I would like to increase a number field by 1 and when I select original then a different number field to increase by 1. I am working on Invoice template from starter solution. My filemaker is Version 12. I don't know how can I do that. Is it possible? Could you help me? Thank you in advance!! Nikos
  8. Nikos Gewrgioy

    Calculation and Sum for all Records

    Efen, how can I do that?
  9. Nikos Gewrgioy

    Calculation and Sum for all Records

    Hello Lee, I have attached the file in my first post.
  10. Hello, I would like to make a relationship for sold items and for stock items to know how many items I have in stock. I have two fields one for Quantity Potentiometer and one for Type of Potentiometer. I make a calculation field with with name Sold 250k Pot with function: If (Pot type = "CTS 250k Audio Pot"; Quantity Pot) and then I have another one calculation which removes the Bought 250k Pot and I know how many Pots are in stock (Bought 250k Pot - Sold 250k Pot) and work perfectly but if I go to a new record the Bought, Sold and Stock fields didn't show me the remaining stock items or the bought parts or the sold parts from the previous projects. Could you help me to solve this problem? I have uploaded the database to show you the problem. Thank you in advance Projects.fmp12.zip
  11. Nikos Gewrgioy

    Search Projects by Month

    Thank you very much Ron Gates. It works. Yeah You are the best.
  12. Nikos Gewrgioy

    Search Projects by Month

    I don't put the hphen, I have two different fields, one for arrival date and one for finishing date. I press the find mode button and then check the dates 1/1/2013 on the arrival date field and 1/31/2013 on the finishing date and then I press the Perform Find button.
  13. Nikos Gewrgioy

    Search Projects by Month

    Hello, I am new in filemaker. I have make a database to save some guitars informations and I would like to search how many guitars I have saved in January, February etc... At this time if I search between 1/1/2013 - 1/31/2013 then Filemaker told me: No records match this find criteria but I have saved 8 guitars at January 2013. How can I solve this problem? I have uploaded my database to dropbox if you want to see the problem https://www.dropbox.com/s/fo6f8qcbfq0b1e4/Projects.fmp12. Sorry for my English, it's no good. Thank you in advance
×

Important Information

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