Jump to content

How to generate different Portal line numbers for different parent record


Recommended Posts

This should be easy, but my brain just won't cooperate!

I'm moving a bunch of stuff and want to inventory what is in each moving container.  I have a very simple parent-child relationship with the parent record having the container number and category of parts/equipment/supplies and the child records describe each piece of equipment in the container.  I have a portal with the child records showing for each container, but want to put anatto-entered item number for each piece that has the container number followed by a dash and then followed by a serialized number for each item in that particular container.  For example, I would have container 1 labeled "Glassware" and Container 2 labeled "Chemicals".  In Container 1's portal I'd like to see:

Item    Description          Qty

1-1      Beakers, 500ml    4

1-2      Beakers, 250 ml   2

and in Container 2's portal I'd like to see:

Item    Description          Qty

2-1      Potassium           4 g

2-2      Sodium                26 g

I'd like to auto-fill the item numbers, but can't figure out how to reset the serialization for each parent record.

Any help is greatly appreciated.

Thanks and keep yourselves safe!

 

Link to post
Share on other sites

What would be the purpose of such numbering? If it's only for displaying in a portal on a layout of the Containers table, it seems rather redundant. But if you wanted, you could simply merge the parent's container number field with the record number symbol.

Note that this would be dynamic numbering: iit would automatically adjust after adding or deleting a record or if the portal records were resorted. And it would not be applied to any other layout (e.g. a list view of the Items table, showing items of more than one container).

 

Link to post
Share on other sites

The purpose is twofold:

1.  People packing will be assigned to fill a particular container.  They'll grab an item and place it into a marked spot (i.e. 1-7 or 2-73) in the container.

2.  When unpacking by likely different people, this will allow people to quickly locate an item (I need a 500 ml beaker - it should be in box 1, spot 1).  Also, if they see a random item laying around, they can return it to the proper container.

Unfortunately, dynamic numbering won't work.  It just seemed like it would be easier to know that a certain piece came from a certain place instead of wondering where the heck item #89221goes.  It's not a big problem filling in the item numbers manually, but I wanted to automate it as much as possible.

Thanks.

Link to post
Share on other sites

I am afraid you've lost me at this point. If it's possible to assign an item to a spot automatically, then why can't be dynamic?

Of course, you can always number (or renumber) items by script (with the usual caveat regarding record locking).

 

  • Like 1
Link to post
Share on other sites

Thanks, comment:  I worked up a script that does the renumbering and it seems to work well.

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 Tony Diaz
      The tables.
      Items::ID
      Items::Item
      Items::Publisher
      Items::Date
       
      The Genre data is already arranged like this:
      Genre::ID (Unique Key)
      Genre::Name
      Genre::Category_ID
      Genre::Category

      The Platform data is 'simple'. ID and Name. But each item could be multiple platforms.  (Example #1 vs. Example #2)
      Platforms::ID
      Platforms::Name
      An item can have multiple Genre Categories related to it, and those usually have a single choice from within their Category, but might have multiples.

      It's supporting the possible multiples that I'm trying to work out. At this point there's 15 possible Genre Categories that each Item could have a selection from. Most have 4-6 of them.

      Example 1: Items::Table on the left, Genre::Table on the right, with some Genre Categories (Genre, Perspective, Pacing, Gameplay, Interface, Setting) and their sub-options.
      This one has just one sub-option per category.

      Example 2:  The Gameplay Genre Category has two sub-options related to it.



      Example Genre Table content:

       
      Just cracking the surface on One to One and One to Many relationships, I don't think this scenario is quite covered this way.

      Would each of those Genre Categories be portals showing only their related category ID?

      I presume that I would add fields to the Items::Table so I can pull related records:
      Items::Platform_IDfk
      Items::Genre_IDfk
      Items::Category_IDfk
      But those only support one relationship.
      Would I make value lists from those Genre Categories and Platforms and set them as tick box fields?
       
    • By stan111
      Gents,
      I use self portal on my Clients layout to serve two things:
      1. display all the records and
      2. quick navigate among them. 
      This portal is not displayed in Webdirect. 
      Is it possible to make it work?
    • By Randy Bennett
      Yes, I did say iPhone 5 -
      I have a small database i created that has a few portals on different layouts - Everything works fine on my Mac, fine on my iPhone X, even fine on my iPad mini
      However, I need it to also work on an old iPhone 5 and the portal data is just blank - nothing. In fact, I really ONLY need it to work on this old iPhone 5 (This particular database will go to a music festival to be used by several other people and I can't give them my iPhone) 
      I have another layout with different portals that are working on the iPhone 5 - but not this main screen. 
      I have made sure that all of my fields are small and inside the portal. - So, I am stuck as to why? BTW - It is Filemaker Go 16.0.4.456 (The latest version that I can install on an iPhone 5)

    • By Rich
      Greets, all:
      I'm using this calculation--in a parent table in a field temporarily named 'Temp'--to grab course numbers from the course_number field in a related/child table:
      UniqueValues ( List ( ASSIGNMENT_COURSE::Course_Number__lxt ) )
      (I'm using this calc because the child table contains multiple records with the same course number; it's not a key field.)
      My intent is to use six buttons--in the parent table--where each button would grab an assigned row's value using the calculation above. For example, say that the above calc has this result:
      AST-100
      EDU-100
      EDU-300
      PHY-100
      SOC-100
      TMA-001
      I want Button 1 to grab AST-100; Button 2 to grab EDU-100; Button 3 to grab EDU-300, etc.
      Mind you, I can't make a value list out of Temp because it can't be indexed.
      TIA for your help! 
       
    • By Asu
      I know. Don't use them. But There is a simple task and a repeating field would be a quick solution.
      Field 1: a number
      Field 2: a calculated repeating field, each repetition adds the repetition number to the value of Field 1.
      Can it be done?
      Thanks

×
×
  • Create New...

Important Information

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