there are certainly better ways to choose a value for the portal row. At a certain point those pop ups become wrong for choosing a value. You have to rely on something else.
here is one way. It uses a list view like you suggest. In my phone it is he's to write the minute details. Here is the overall idea:
iin each portal row a button is placed. When pressed it captures the row # of the portal in a global field. You then go to the list layout ( in a new window ) you created of the choices and find those that meet the same criteria as your conditional value list ( the choices that are ok to pick from for this item)
in this list each row has a button that captures the serial number of that row. Capture it in a variable inside the script.You then close that window and go to the portal row you were on (captured in that global field).
then simply set the field of the row you're on with the serial number you captured in the variable.
by the way these actions are done in scripts. Are you familiar with writing those?
i have a demo file I whipped up but couldn't finish before I had to jet. I'll post it when I get home.
For yourcscripts you'll use the function Get(ActivePortalRowNumber) and GoToPortalRow
ill be glad to help out more when I get home
BetterChoose.fmp12.zip 71.7 K
Thank you very much for your detailed response!
Yes, I'm familiar with scripts but never did something too complicated. I didn't know you could get the specific portal row number, that will be very helpful.
I will take a look at the file you sent me and tell you how it went,
you want the function Get(ActivePortalRowNumber).
(Sorry, I repeated Jeremy's note.)
I was able to adapt your code to my needs perfectly, the only thing that bothers me is the original window resizing when the new window opens. Any way to keep it as it is while I choose on the other window? Thanks!
Be sure the Adjust Window script step comes after the new window script step. In my demo, the original file doesn't seem to resize.
Try that. Let me know if it is still wonky.
For fun, I included another way in the Companies_Popover layout. This uses, as you might guess, a popover instead of a separate window. I like this way better, and it really only has a few different script steps.
This will eliminate the problem of the weird-resizing window and any other flashing you see.
BetterChoose.fmp12.zip 74.1 K
From what I've been able to investigate, the resizing happens because I'm on Windows and working with the original window maximized and, apparently, there is no solution for this that doesn't involve an external plugin. It happens in your demo too.
I like the popover option better, it feels more intuitive and less disorienting, I think I'm gonna go with that.
Thank you very much for your help! Have a great day!