Jump to content

How to generate different Portal line numbers for different parent record

This topic is 854 days old. Please don't post here. Open a new topic instead.

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 comment
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 comment
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.


Link to comment
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 comment
Share on other sites

This topic is 854 days old. Please don't post here. Open a new topic instead.

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

  • Create New...

Important Information

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