Hey Everyone,
This is my first post so bear with me,
I have an app that keeps track of hay inventory, customers, and orders on a farm. Orders are distributed by truckloads, referred to as โloadsโ. A customer can have multiple orders, and each order can have multiple loads. Right now Iโm working on the new order (parent) and new load (child) relationship. Iโm using nested tables to achieve this.
I want the structure of the order form to be as follows:
Section about Customer (name, address, phone number, etc)
Section for Loads (table of loads associated with this order and the button to add a new load)
Section for Order Summary (total amount of hay ordered from all loads, total due, payment info, etc)
The problem Iโm running into is that all of the nested load information (table and button to add new loads) is automatically being placed at the very bottom of the form, below the summary information and the Load Section is blank in the center of the form. Any suggestions on how I would move the nested table to the center of the form in the correct section? Iโve tried everything I can think of.
Thanks!
Solved! Go to Solution.
Create a new Slice pointed at the table in question. You can use the Slice to reorder the columns any way you want. Point your view(s) to the new Slice.
Create a new Slice pointed at the table in question. You can use the Slice to reorder the columns any way you want. Point your view(s) to the new Slice.
Thanks Dave, this answered the same question that I was about to ask. A question comes to mind though, what within the original view would cause this new view (slice) to fire?
The slice will โfireโ any time a row in the underlying table is added, updated, or deleted, or if any value used by the row filter expression changes. In effect, you can assume itโs always as current as the underlying table.
Ok, thanks Steve! God bless you man.
Hey Steve, once I create the slices that will be โnestedโ in the View of choice what do I do next? Do my slices need to some how be designated as a โreference sliceโ?
My goal here is to view the nested slices in the dispatch view. These slices are labeled: Broker information, Shipper Information, etcโฆ However, when I click on โNested Table Columnโ there are no options availableโฆ
Thank you in advance for your help.
Youโll need a virtual column in the table youโre putting the view on that contains a list of key column values of the rows in your slice you want displayed. If you want all rows of the slice, you can use the app formula:
slice[keycolumn]
replacing slice
with the sliceโs name, and keycolumn
with the name of the sliceโs key column.
Steve,
This seems like next level stuff. Youโre like an App Super Technician. Thank you!!! !
Hope you are well by the way
Ok, created the virtual column. Or, does there need to be one virtual column for each slice?
Also, when I enter Brokerage Information[keycolumn] do I need to input each column in sequence within the brackets?
That would be cumbersome, because each slice has like 9-15 columns eachโฆ
The Brokerage Information slice has exactly one key column: itโs the same as the key column of the table the slice is built on. You only need to use that one column.
Alternatively, use this as the app formula of the virtual column instead:
FILTER("Brokerage Information", TRUE)
The first method you gave worked! Thank you SO MUCH!
Thanks!!
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |