Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Oyseka

  • Rank

Profile Information

  • Gender
  • Location
    South Africa
  • Interests
  1. Oyseka

    How are these Orphans created

    Hi LaRetta, You are quite correct, there is no reason to allow creation from the QuoteItems table, I will rectify that. I suppose that because the problem is so odd to me I was sort of hoping for a "If you get struck by lightening and the dog farts at the same time while Venus is in decent" this sort of thing can happen. Thank you once again for your assistance though.
  2. Oyseka

    How are these Orphans created

    Good day LaRetta, sorry for the delayed response but the electricity went yet again and has only just been restored. The reason for "copy" is that we use Mirrorsync to enable both on and offline record editing and creation and that is used as part of the set up. Every ID field has a copy which is actually the original on creation ID and the ID field that is visible is an auto enter calculation field from the original. The "Copy" fields are not visible or accessible on any user layout That was my thought as well because I can find no method of deleting the Quote without also deleting the QuoteItems. If however someone had actually managed to change the the QuoteId to break the relationship then the CutomerId and name would remain on the quote but that is not the case as the Customer is now not found in the Quotes table so the Quotes have actually been delete As stated the visible QuoteId is a calculated field from the "Copy" even if a user could create a quote from the QuoteItems table. The user never actually goes to the QuoteItems table and the QuoteItems are only available to them through the portal on the Quote Yes sorry, this one is indeed weird. For reasons known only to themselves the mines require a quarterly quote but a monthly service and invoice so we had to come up with a plan to carry a different QuoteId across three months invoices as well as our normal unique QuoteId. This is the first time that a Quote has gone walkabout in this manner after 14 months of testing and use Thank you for your assistance and insights into where to look for the problem
  3. Oyseka

    How are these Orphans created

    Hi (once again) LaRetta, Thank you for your response. The user can only delete a Quote from the iOS Quote layout using a scripted button, the script of which is very simple so I don't see how your suggestions could operate on the file and I believe that the relationship is set up correctly.
  4. Hi All, I have a database where the relationship between the Quotes table and the QuoteItems table is set up such that if a record is deleted in the Quotes table, the related records in the QuoteItems table are also deleted. I have now been shown an instance on one Customer where there are four Quotes missing from the Quotes table but all the QuoteItems are still in the QuoteItems table. How can this be done, I am unable to recreate a circumstance where I can delete a quote and leave the quoteitems in place. Any help appreciated
  5. Oyseka


    Here is a mock-up Location Test . The file shows the orchard location for a team to start whatever operation they are tasked with. As stated it works fine in 10.12.X and below but not in High Sierra Loc_Test.fmp12
  6. Oyseka


    Hi, No, Safari displays the site fine
  7. Oyseka


    Hi All, I am viewing a records location through What3Words and the web viewer performs as expected on OS X 10.10.x and 10.11.x but when I put the file on OS X High Sierra the web viewer gives the error, "SSL Error, Unable to create a secure connection to the server". All connections are from the same location. Can anyone assist please
  8. 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.
  9. Oyseka

    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
  10. 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.
  11. 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.
  12. 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 ]
  13. 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
  14. Wow, how cool is that. Sorry comment I was fixated on Integer. Thank you for your help once again
  15. 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

Important Information

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