Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Oyseka

  • Rank

Profile Information

  • Gender
  • Location
    South Africa
  • Interests
  1. 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
  2. Oyseka


    Hi, No, Safari displays the site fine
  3. 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
  4. 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.
  5. 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
  6. 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.
  7. 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.
  8. 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 ]
  9. 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
  10. Wow, how cool is that. Sorry comment I was fixated on Integer. Thank you for your help once again
  11. 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
  12. 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
  13. Oyseka

    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.
  14. Oyseka

    Clear Checkbox

    Thank you comment, perfect
  15. Oyseka

    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.

Important Information

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