Jump to content

Lola

Members
  • Content count

    61
  • Joined

  • Last visited

Community Reputation

2 Neutral

About Lola

  • Rank
    novice

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
    Beginner
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Win 7

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

2,753 profile views
  1. Thanks Dough & Steve...I really appreciate it...
  2. Hello All, How can I capture all the materials that are going to expire and for retest this month. My problem is with my present graph relationship (Retest) it will not capture all the materials that are due for retest this month. it only capture today's date and future dates and also it captures the next month dates same with my expiry relationship. I have attached the file that Im working on for your reference Thank you so much.. Retest_Expiry.fmp12
  3. Auto enter

    Hi Steve, Thank you for the reply. Do you have any link that I can take a look? Thank you
  4. Auto enter

    Hi Bcooney, Sorry for my Avatar. I will change it. I will upload try to upload the file again when they fix https://fmforums.com/announcement/10-ssl-certificate/ Thank you. Hi Bcooney, The file is uploaded. Thank you. Invoices.fmp12
  5. Auto enter

    Hello All, I am using the invoice starter solution, I add a Catalogue Field to the Invoice Data Table which is an (Text ; Indexed, Look up from related Table Products::Item) I've been playing over the weekend but I cant make into work. If I put the Catalogue Number my item its not filling automatically. Can you please help me. I have also attached the file that Im working for your reference. Thank you Invoices.fmp12
  6. Hello All, Below is my script for my webdirect layout ; I want to include a dialog saying "No record Found" if a user is searching and nothing is found. Freeze Window Set Error Capture [ On ] Allow User Abort [ Off ] Perform Quick Find [ Preferences::gSearchField ] If [ Get(LastError) ] Perform Find [ Restore ] Else Sort Records [ Restore ; No dialog ] Go to Record/Request/Page [ First ] End If Go to Field [ Preferences::gSearchField] Thank you. LoLa
  7. Show All Previous Post

    Hello Admin, How can I find all my previous (old Post) since I started posting in the forum? Thank you.
  8. Help with relationship

    I removed the constant in the relationship..still did not change my result still showing "?"
  9. Help with relationship

    I used the constant in the relationship to match the same record. Is there a way that I can make my Material Stock a Number field but still always show my current stock when I change my Quantity Dispense Field? Thank you.
  10. Help with relationship

    Hello All, I have a problem with my relationship. In my Dashboard I have an alert that will tell me how many materials are expiring & to be retested but my problem is it showing me a "?" The relationship graph is below Dashboard Fields Constant = 1 Constant Today = Get (CurrentDate) Global Number = Number field Value is 1 Material_Expiring Today Constant = 1 Material Expiry Date = Date Field Material Stock = Calculation (Material Quantity Received - Sum ( Material Transactions::Quantity Dispensed ) If I change my Material Stock into a Number Field It will show my desired output. Please see attached file that Im working. Any help is highly appreciated. Thank you Materials (2).fmp12
  11. Hi Steve, Yes No. Yes
  12. Hello All, I want to create an auto enter Lot Number for new incoming material base on YYMMXXX YY - Two digits of the Current Year MM - Months Number XXX - Number of Material Incoming For Example: If I received 5 Materials for the Month of September 2017 the Lot Number would be the following 1709001 1709002 1709003 1709004 1709005 If I received 3 Materials for the Month of October 2017 the Lot Number would be the following 1710001 1710002 1710003 Any Help is Highly Appreciated.. Thank you
  13. Hi Lee, I already deleted all the tables that is connected to my material table, but still giving me same result. The custom function that Im using is on my inbox.
  14. Hi Lee, Thanks for the reply, How can I solve the problem? Thank you
  15. Hello All, Please find attached two sample files that Im working. In Materials_DB1 when I create a new record my lot numbers are repeated, while in Materials_DB2 it works fine. is there something wrong with my other file? the monthly serial that Im using is from Daniel (Raybaudi ) Materials_DB1 Username is Admin PW: No Password Thank you so much in advance Materials_DB1.fmp12 Materials_DB_2.fmp12
×

Important Information

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