We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Recommended Posts

FileMaker friends, could someone please teach me a new trick
I'm building an interface for composing "counsel" documents with each sentence it's own related record
Sometimes I need to move the portal rows around, like in my "Old McDonald" example
I think they call this kind a thing a "custom search order" 

Is it possible to "Drag and Drop"?  If not, no problem, how about a scripted button? 

What would you do?
 

Question Insert Portal Row.png

Share this post


Link to post
Share on other sites
BruceR    151

No, it is not custom search order. It is custom sort order. You could do web searches for drag and drop portal sort.

You will need to add sortOrder field (number field) to the child record table and you will need to sort the relation by this field.

To begin using it, have it auto-enter get(recordNumber). Edit it by hand to control sort. Then learn from the available example files how to automate this.

Example link:

http://www.delfsengineering.ca/blog/2015/3/18/better-drag-sorting

Edited by BruceR

Share this post


Link to post
Share on other sites
comment    1,357
1 hour ago, John D Sebastian said:

Is it possible to "Drag and Drop"?  If not, no problem, how about a scripted button? 

Drag and drop is sort of possible (see http://fmforums.com/forum/topic/67781-script-triggers-and-drag-drop-incompatible/), but far from being simple.

For a method using buttons, see http://fmforums.com/topic/60325-manually-reorder-portal-records/#comment-285451

 

Note that before deciding on any specific method, you need to consider whether reordering performed by one user should take effect for all users alike (which would also require that the records being reordered by one user will not be locked by another).

Share this post


Link to post
Share on other sites

Thank you "Consultant" and "BruceR" 

I appreciate the explanation, tip (knowledge level warning) about drag n drop (which I will gladly heed) and especially helping me find this link  http://fmforums.com/topic/60325-manually-reorder-portal-records/#comment-285451  

One more question... what are these stars on the top left of the posts pages?  Is that something I should fill in when a question is answered, to say I liked / appreciated the answer? 

 

Share this post


Link to post
Share on other sites
comment    1,357
3 minutes ago, John D Sebastian said:

what are these stars on the top left of the posts pages?

To tell the truth, I don't know nor particularly care. This forum's engine has many features that are more suited to a social site than the professional one it is. I would suggest you complete your profile to show your version and OS, though.

Share this post


Link to post
Share on other sites
Lee Smith    142
1 hour ago, John D Sebastian said:

what are these stars on the top left of the posts pages

As it state above them “Rate this topic"

They are for rating the Question?  I don’t recall anyone doing that though. LOL

Share this post


Link to post
Share on other sites

Okay, I'll get the hang of it soon enough.  Hey, I notice fmforum's ,messaging user interface is super nice, fast and feature-ful.  Looks like you guys are using IPB  https://invisionpower.com/  
As a web developer, I'm pleased to make this discovery... Did I get that correct?  

 

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 Bartek
      Hi There,
      First of all many thanks to creators for amaizng plugin.
      What is the syntax for inserting images to excel?
      ScribeDocWriteValue ( “addImage()”; image ; page ; x location ; y location ; height ; width ) 
      Do not work for xlsx with error about invalid cell name (first parameter is function adn for excel it seams it is not recognized) for pdf works fine as in demo expample
      I tried standard syntax for excel where first parameter is table cell and second is image in container but it do not insert the image.
      Any suggestions?
      Thanks in advance.
      Bart
    • By Philip Jenks
      Hi everyone
      I have a script trigger in a field inside a portal on 'Layout 1'.
      The script goes off to a related table (same file), does some calculations, then returns to Layout 1.
      When it returns, I want it to scroll down TO THE PORTAL ROW IT STARTED FROM, so that that portal row is visible and active, and the user can see that the calculations have been done. Some records have 25 lines in the portal, so it’s tiresome for the user if the script comes back and display portal row 1 instead of (say) portal row 16, because he/she then has to hunt for the correct portal row.
      My script in the original layout starts:
      Set Variable [$ActivePortalRow; Value: Get(ActivePortalRowNumber)]
      and then when it gets back to Layout 1, it says:
      Go to Portal Row [Select ; no dialog ; $ActivePortalRow]
      the choice of portal row being defined as a calculation and the calculation simply being: $ActivePortalRow.
      It’s not working! The script successfully returns to Layout 1, but doesn’t go to the original portal row and, in fact, doesn't seem to go to any portal row. I’ve tested by changing to ‘Go to portal row [Last]’’ and that doesn’t work either. It just does not seem to want to take any instruction on 'Go to portal row' at all.
      I’ve tried various things. e.g. inserting a step saying ‘Go to Object’ where the object is the portal name. I’ve also inserted a 'Go to field' step, using a field which is inside the portal (and only inside the portal). Again, no joy.
      Any know where I'm going wrong?
      Thanks
       
      Philip
    • By H
      Hi
       
      please can someone help me when i insert a pdf i get a message not enough disk space and only get a referance file
    • By SkylineR37_
      Hello
      Newbie here. I am trying to create a remotely hosted FileMaker 11 script that has the following attributes:
       
      1. Imports a folder full of image files.
      2. The folder is never the same, it can be a different folder, on a different drive, etc.
      3. Need to allow the user to select the folder they want.
      4. Do NOT want the user to be presented with any other dialogue boxes, especially Import Field Order, or "Auto enter?" and so on.
       
      I've tried and tried, but every combination of options on the Import script step, in one way or another, does not meet all four criteria listed above at the same time. I can get it to do one-or-the-other, but not all of the above at the same time.
       
      How would one go about this?
       
      Thanks!
    • By gczychi
      Hi,
       
      using a "count of id" summary field in the enclosing layout/table I can get the current total number of rows in the portal based on the portal relationship. But I have three or four filters defined in the portal so that the portal only shows a subset of this total.
       
      How can I possibly get the correct number of portal rows that are displayed at any time — outside of the portal on the enclosing layout? Preferably in a global field?
       
      I can insert a Record Number Symbol on each portal row that displays the current record number down to the last number. That works fine. But I can't get this value into the enclosing layout/table, whatever means I try.
       
      I could probably use a couple of ExecuteSQL queries (one for each case), but because my filters are quite complex these would be also very complex and cumbersome, especially because SQL treats the data a little bit differently than FileMaker (empty fields vs NULL fields, etc.).
       
      Any suggestions how to achieve this?
       
      Thanks a lot!
       
      Gary
       
×

Important Information

By using this site, you agree to our Guidelines.