Product search

I have almost 50 products, these products are distributed in 9 columns (same picture attached).

I need to get a product report by date

Can I get it in glide table or drive table?

Any expert can advise me?

what do you mean by “report”?
filtered inline list of products from a specific date, in Glide App?
or get let’s say, an emailed PDF list, every day?

Yes exactly,
filtered inline list of products from a specific date, in Glide App?

Are you saying that you want to transpose those 9 columns from one specific row into separate rows whenever you select a date to view? Then display those rows in an inline list?

I’m thinking you’ll need some sort of variation of @Robert_Petitto’s method. Basically create arrays of products and quantities. Then create a working table with 9 rows. In that table, have a user specific column to store a user selected date. Create a Single Value column to expand that date across all rows. Then create a relation that links the date to your original table. Then bring those arrays into the table as single values columns or lookup columns. Then split the arrays into rows by using a row index to retrieve the respective array item based on the row index. Set this up as an action, so when you select a date from a list, first set the user specific column with this dat value. Then the rest of the table will auto populate and you can use it for your inline list.

I’ve often wondered how that could be done dynamically. I’ve never used this method because of that. My tables grow, and then do you need to keep adding rows to your working table?

You would have to plan ahead and make the working table as large as you would ever expect it to get. In this case, it sounds like 9 row is the max that would be need. In a situation where you need more, then you would have to add enough rows. I don’t know if you’ve seen my calendar concept app, but I have a working table that accepts a date and basically calculates each day in that month as a row. In that case, I know that I need at least 31 rows because the most days that exist in a month are 31.

It really depends on the situation. If you know the maximum number of rows you will ever need, then create that many rows. If you don’t need that many rows all the time, then only some of them will get filled dynamically and you can filter out the rest of the rows that end up being unused. If you have no idea what the max number of row could ever be, then maybe it’s not a suitable method. Point being, it can be dynamic up to the number of rows that you have added.

2 Likes

Exactly

1 Like

In fact, I did not understand what you said above, can I hire an expert to do this?

Yes, you can!

1 Like