Jump to content
Oyseka

Multiple DropDown list alternatives help

Recommended Posts

The lack of support for Drop Down lists in FM Go is creating havoc for me. I want to be able to create a Quote on site at a customer with two particular fields, one is not a problem thanks to Phil Caulkins excellent demo on Auto-Filtering portals, (ProductName), as it is part of the QuoteLines Table the other one however is not, (Dept), and is currently sitting with a few hundred options. Typing in the name, with the probability of getting it wrong, is very time consuming on a phone. part of it is right but the Dept Field is defeating me.

The file is a dogs dinner but it is only meant to test the functions it is not a work file. Go to the Quotations layout

Any assistance would be very much appreciated

iOSDropTest.fmp12

Share this post


Link to post
Share on other sites

Why not use a pop over with a portal that shows all the choices that a user can filter on by typing a possible name? I started using that everywhere where a plain drop down would be too long or I want them to be able to search on first and or last name.


Sent from my iPhone using Tapatalk

Share this post


Link to post
Share on other sites
6 hours ago, Agnes Riley said:

Why not use a pop over with a portal

Hi Agnes,

Thanks for your response. If you look at the demo file that is what I had done but I was stuck at inputting the Dept as that is in an unrelated table. I have now solved the issue though using exactly what you suggested, I just had to add a new layout and relationship

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • 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
    • By mvoogt
      I'm looking for a way for FM Go to send messages to a mac.
      I have a database file on an ipad (local, not networked). I'd like to 'control' a mac on the network in some way by sending commands to the mac. My thought was to use applescript but I understand that FM Go does not support applescript.
      Any suggestions? OSC, or MIDI? Has anyone tried anything?
    • By cat traveller
      Hi everyone,
      on a file accessed via filemaker Go 17, I am using a scripted navigation to move records up and down in a portal that is inside a popover.
      This has worked in filemaker 12 like a charm and also works on a filemaker client. The records smoothly move up and down the list. 
      However in Filemaker Go, the portal follows every move of the script as if it is not aware of the freeze portal.
      EG the down button is to move the record one record further down inside the filtered and sorted portal (like so)
      This is the script.

      - freeze window and go to portal
      - go to first line of portal and loop through the portal until I hit the record to move
      - go to next line and give the position field the value of my record to be moved
      - go to line above and give the position field the value of my record +1
      - commit record and refresh portal via an x join 
      - go to last line of the portal 
      - go to the line of position of my record to be moved. 
       
      Would anyone be aware of this issue or know a workaround to stop the portal from flickering?
       
      Thanks so much
       
    • By Greg Hains
      Good afternoon,
      I am trying to understand a problem I am experiencing with an FmGo solution.  The solution is hosted on FM Cloud (AWS) and runs well on my Mac workstation, but experiences a few issues when running on the iPad.
      I'm also experiencing the same problem when I host it from a local Windows Server 2012 box.
      Using RESTful APIs (with BaseElements plugin) on my Mac workstation and I am downloading product data from a host, manipulating the data, then uploading it back to the host.
      I am assuming that I need to have the BE plugin running on the AWS host before FmGo can use the functions within. As no FM solution runs on the host itself (to Install Plugin), how do I install this plugin to the FMS there? (Assuming that this problem is related to plugins on FmGo). 
      Also, without ScriptDebugging on the iPad, I have a ton of Show Custom Dialogs all over the shop trying to see where it goes wrong on the iPad. Some of the REST calls fail with authentication errors on the iPad but work fine on the desktop. Same script. Got me beat!  I'm thinking it may be one and the same problem.
      Any help is appreciated.
      Thanks,
      Greg
       
    • By adyf
      I've just upgraded to Filemaker Pro 17 and Filemaker Go 17. Unfortunately I now get 'The Host's Capacity Was Exceeded' error message (attached) when trying to open a file on my iPad that is hosted on my MacBook. I'm the only user of this file, so it seems strange and I've never had the error with previous Filemaker versions. Has anyone any ideas please?
      Edited to add that the file opens with Filemaker Go 17 when it is open on the MacBook with Filemaker Pro 16, therefore could this be a bug in Filemaker Pro 17?

×

Important Information

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