Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Oyseka

  • Rank

Profile Information

  • Gender
  • Location
    South Africa
  • Interests
  1. Hi all, I have a requirement to reduce the size of a database by removing records from the work system and importing them into an offline archive system but don't know how to automate the scripting between the files. Database 1 is a work system where, among other things, service records are created during a service and any problems found during the service are annotated and photographed on mobile devices. At the end of the service a summary report of all actions carried out and any problems that require the customers attention is produced, signed by the customer and emailed to them. With about 450-600 photographs taken each month the file size will ballon very quickly so I have created a new database which is a duplicate of the photos file which contains all the required information to link to both a customer, particular service and operator and I want to find records in the work database which are over a certain number of days old, open the external file and import those records then return to the work file and delete the found set.
  2. Why are records not visible in portal

    Hi Steve, the key field is the QuoteId and as you can see on the 4th screenshot, that field is populated correctly. Just to explain the screenshots; Image 1 shows the Quote Layout denoting the QuoteId and the Products as viewed in the portal. note that items 4 and 5 have a Qty greater than 1, Image 2 shows the QuoteItems layout which contains the details of those Products with the corresponding Qty. Image 3 shows the Quote Layout after the duplication has been run and Image 4 shows the QuoteItems layout after the duplication has run. Image 5 shows the Quotation after any of the Portal rows have been selected and exited with no further input. At first I assumed it was a refresh or commit problem but I have committed all records on creation and refreshed the Quote window when the record is accessed This is the script used to duplicate the Products: Set Error Capture [ On ] Loop Set Variable [ $QuoteId; Value:Quotations::__QuoteId ] Go to Layout [ “dLayQuoteItems” (QuoteItems) ] Enter Find Mode [ Specified Find Requests: Find Records; Criteria: QuoteItems::QTY: “>1” AND QuoteItems::_QuoteId: “$QuoteId” AND QuoteItems::ServiceFlag: “=1” ] [ Restore ] Perform Find [ ] If [ Get (LastError) = 401 ] Go to Layout [ original layout ] Exit Script [ ] End If Go to Record/Request/Page [ First ] Set Variable [ $QTY; Value:QuoteItems::QTY ] Set Field [ QuoteItems::QTY_Count; $QTY ] Set Variable [ $QTY_Count; Value:QuoteItems::QTY_Count ] Insert Calculated Result [ QuoteItems::QTY; 1 ] [ Select ] Commit Records/Requests [ Skip data entry validation; No dialog; Force Commit ] Loop Duplicate Record/Request Insert Calculated Result [ QuoteItems::QTY; 1 ] [ Select ] Insert Calculated Result [ QuoteItems::QTY_Count; $QTY_Count-1 ] [ Select ] Set Variable [ $QTY_Count; Value:QuoteItems::QTY_Count ] Commit Records/Requests [ Skip data entry validation; No dialog ] Exit Loop If [ QuoteItems::QTY_Count = 1 ] End Loop End Loop
  3. Hi All, When I add records to a quote they may be added in multiples until the Quote is accepted. When a quote is accepted I now have to change any multiple service Products to single products to allow for the creation of the barcodes,(serial numbers), used during the service so that any parts used on the product are recorded against that particular product. I created a script which checks for any service Products that are showing multiples and duplicates them the required number of times. The duplication works fine in the QuoteItems layout but unless after duplication, I select either the department or product, then the items do not show in the QuoteItems portal on the Quotes layout despite the Qty being reduced from whatever it was set at to 1 and the Quote Total is incorrect.
  4. When the script commences the user is in the Quotations layout and they only physically enter the QuoteItems portal on the Quotations layout when both the Product and Department have been selected to select the Qty. The script above is activated by a button, Add Service, which triggers a popover with a selection field (gProdFilter) filtering a portal from the layout Prod_QuoteAll. When the Product has been selected, (the action of the script above), the user is then taken to another layout in the Quotations table (iLayQuoteDeptSelect) to select the department again from a portal from the layout DeptListAll.
  5. Sorry Wim, I neglected to include the iOS flow. The filtering of both the Product and Department takes place in fields on the Quotations table for iOS, which is where I think the problem stems from. When a filtered selection is made it is then moved to the QuoteItems table. This is the script that is used to select the Product and after Product input takes the user to the Department selection field Set Variable [ $QuoteId; Value:Quotations::__QuoteId ] Set Variable [ $ProdName; Value:Prod_QuoteAll::ProdName ] Go to Layout [ “dLayQuoteItems” (QuoteItems) ] New Record/Request Set Field [ QuoteItems::_QuoteId; $QuoteId ] Set Field [ QuoteItems::ProdName; $ProdName ] Commit Records/Requests [ No dialog ] Set Variable [ $$QuoteItemId; Value:QuoteItems::__QuoteItemId ] Go to Layout [ “iLayQuote” (Quotations) ] Set Field [ Quotations::gProdFilter; "" ] Go to Layout [ “iLayQuoteDeptSelect” (Quotations) ] Go to Object [ Object Name: "FilterDepartments" ] Go to Field [ Quotations::gDeptFilter ] [ Select/perform ]
  6. Hi All, I am developing a system to produce, among other things, Quotations and Job Cards in a mixed FMP and iOS environment. One to the problems was the lack of support for autocomplete of drop down lists in iOS which I have tried to get round, with the help of this community, by using a filter from a cartesian join relationship. I now find that when more than one person is creating a quote on a mobile device from the hosted file that you may end up with other peoples input in your QuoteItems table for the quote you were creating. Can any one tell me how to change the relationship ,(design), to stop this. On a desktop system the flow is: From the Customer - create Quote - Quotation Table In the Quotation Table use the portal into QuoteItems to select the Department, Product and Quantity
  7. Wow, how cool is that. Sorry comment I was fixated on Integer. Thank you for your help once again
  8. Thank you comment but I am dorf and do not understand your solution. Perhaps I can give more information. I have a counter field for customer services which , normally , when it reaches 12 i.e. the twelfth month, produces a updated annual quote then resets to one. There is always one customer however that has a different requirement and this one wants a quarterly quote only. So as I have the mechanism in place, on this particular customer I want to set the script that if we have finished the second service and produced the next monthly quote, as the service counter is now set to 3 have a calculation that says if the result of Field (The counter) divided by 3 is an integer tell the PCO that a new quarterly Quote is required and take them to the Correct layout. This would then produce the 4 quotes per year for this customer
  9. Hi all, I want to create an action as part of a script that operates if the result of a calculation produces an integer such that: If[ Field A / Field B = Integer ] Show Custom Dialog [xxxxxx] Exit Script Can anyone assist please
  10. Clear Checkbox

    Thank you for the information BruceR and having checked, as comment said, the return does not present a problem that I can see.
  11. Clear Checkbox

    Thank you comment, perfect
  12. Clear Checkbox

    Hi all, How do you set up a checkbox so that only one value is set such that selecting another value will clear the current value.
  13. Attaching .pdf to Mail

    Thank you for your input. We had decided to go via SMTP as a fair number of the mail messages will be sent from Filemaker Go. SMTP however is creating it's own issues as there are apparently problems with Office365, which is our SMTP server and also that some servers don't accept TLS 1.0, which FM uses.
  14. SMTP send error 1506

    Hi All, Having been shown the bug in 10.11.6 and FMP by bcooney I am setting up the Send Mail script to send via SMTP. This works OK in the Invoice table but I can not get it to work in the Quotes table. There does not appear to be anything in the mail setup script that is capable of creating the error and I have tried three different smtp server addresses with the same result. I have used all three smtp server addresses on the Invoice table as well and they all work. Can anyone assist please.
  15. Attaching .pdf to Mail

    It doesn't appear to have a problem finding the file it just will not attach it without the dialog OS X 10.11.6 El capitan Thank you bcooney, that appears to be the problem. We were intending to move to using a plugin and smtp but were just trying to get our ducks in a row, now I know that the simple solution we were testing on may not be so simple

Important Information

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