Jump to content
Oyseka

Input clash on multiple devices. design help please

Recommended Posts

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

Screen Shot 2017-02-26 at 19.58.26.png

Share this post


Link to post
Share on other sites

I don't think we have enough information.  The user is on what layout that is based on what TO?

 

Why do you have the fields circled when they don't play a role in the Quotations to QuoteItems relationship?  I'm assuming that the portal you are talking about is one that is on a layout based on the Quotations TO and that the portal uses the "QuoteItems" TO?

Share this post


Link to post
Share on other sites

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 ] 

Share this post


Link to post
Share on other sites
4 hours ago, Oyseka said:

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.

Part of the confusion may come from the 'lingo'.  Practically nothing happens in FM on tables.  Things happen on Layouts and layouts are based on Table Occurrences in the graph.  That is how context is derived and context is king.  So when describing your flow, use the layout names or TO names, not table names.

 

4 hours ago, Oyseka said:

 This is the script that is used to select the Product and after Product input takes the user to the Department selection field

At first glance there is nothing horribly wrong with the script although I fail to understand the intent of the last section when you get back to Quotations.

Where physically is the user when this script runs?  In an active portal row of quoteitems on a quotations layout?

Share this post


Link to post
Share on other sites

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.

Screen Shot 2017-02-27 at 16.38.14.png

Screen Shot 2017-02-27 at 16.44.06.png

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Similar Content

    • By owangolama
      Hello. Working on my first FMGo solution. I've locked the zoom and turned off the menus so that things aren't crazy bouncing around all the time.
      I have a large detailed graphic in the middle of the layout. I would like the user to be able to zoom and slide that graphic to see more detail and or simply move around the visible portion. Can I use gestures to do this? (Pinch, expand, and finger slide, or whatever that's called.) If so, how would I go about figuring this out (I couldn't find an example anywhere).
      Thanks in advance for any help!
    • By Greg Hains
      Good morning.
      I am getting a status message appear at the bottom of my iPad (that black pop up bar) with my Go solution:  "Old location received. New location requested".
      It's not a problem, doesn't seem to take long to go away, but I've never seen it before - and can't find any reference to it through Google searches.
      My Internet connection from the iPad is fast - it happens both on 4G and through a wireless connection. I can find no consistency as to the cause.

      My solution is using CURL functions, so wasn't sure if it was related to that at all - e.g. a message from the host.

      Can anybody shed some light on this please?
      Greg

       
    • By Greg Hains
      Good morning.
      Does anybody know how to launch IOS apps from Go please? I am looking to open the calculator.
      Greg 
    • By zonetuke
      My primary Filemaker 16 database connects to 4 other tables located in their respective Filemaker databases. I wish to prevent these connections from occurring when using the primary Filemaker database in Filemaker Go in iOS but allow the connections when using on a computer desktop, both Mac and Win. The reason I wish to disable these connections in iOS is that I always see prompts to locate the databases and it wastes my time to locate each one and connect it. Any way to accomplish this?
    • By Paul Hunt
      I run a small, one-person business and would like to find a hosting solution for a few small, low-use databases. Mostly I just enter some customer charges and lookup passwords, at most three times a day. The cheapest I have found is $29/month and that is more than it is worth to me. Is there any solution out there for around $10/month?
       
      Thanks,
      Paul
  • Who Viewed the Topic

×
×
  • Create New...

Important Information

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