The data entered a form needs to create a new column (date) everyday

Community Discussions
, , ,
1

I have a business where a delivery agent enters data such as how many units of product he delivered to each customer, and this process happens everyday. So, I need a page that shows that day's date and a list of all the customer names along with a user input field next to each customer name. The data the delivery agent enters to these input fields should populate a master data sheet for the month, where each day is a new column against the customer's names.

How do I achieve this feature using Honeycode? Can someone help?

3

Hi @CHAL-efa4, welcome to the community! :smiley: :honey_pot:

Happy to help :slight_smile: I created an example of this for you to help show how the data model would look.

First, here's a Customers table, which has the customer contact and a column to filter all associated deliveries from a Deliveries table. Here's the FILTER formula for the deliveries in my example:

=FILTER(Deliveries,"Deliveries[Customer]=[Name]")

Screen Shot 2021-09-20 at 2.30.20 PM
Screen Shot 2021-09-20 at 2.30.20 PM1240×930 70.1 KB

Here's the Deliveries table, which has the date, each customer, and a quantity:

Screen Shot 2021-09-20 at 2.28.58 PM
Screen Shot 2021-09-20 at 2.28.58 PM822×708 50.8 KB

In the app, on a Home screen I set up a button to start the current day's deliveries. On this button, I added an automation which adds a row to the Deliveries table with the current day's date, each customer's name, and 0 for the quantity (which can be edited in the next screen). This is done with a FILTER formula of the Customer table in the Run Options (to write a row for each customer).

Screen Shot 2021-09-20 at 2.21.51 PM
Screen Shot 2021-09-20 at 2.21.51 PM1760×998 72.5 KB

Screen Shot 2021-09-20 at 2.22.02 PM
Screen Shot 2021-09-20 at 2.22.02 PM838×400 22.9 KB

After that step, there's another which navigates to a screen of today's deliveries:

Screen Shot 2021-09-20 at 2.32.49 PM
Screen Shot 2021-09-20 at 2.32.49 PM1754×978 70.2 KB

If I click that button now in run-time, it creates a row for each customer with today's date:

Screen Shot 2021-09-20 at 2.55.15 PM
Screen Shot 2021-09-20 at 2.55.15 PM832×840 66.5 KB

The screen for Today's Deliveries contains a filtered list of rows in the Deliveries table matching TODAY():

=FILTER(Deliveries,"Deliveries[Date]=TODAY()")

Screen Shot 2021-09-20 at 2.22.46 PM
Screen Shot 2021-09-20 at 2.22.46 PM1478×900 70.3 KB

For your ask to edit the quantity, select the quantity field and check the "Editable" box to allow for these changes:

Screen Shot 2021-09-20 at 2.22.55 PM
Screen Shot 2021-09-20 at 2.22.55 PM1464×700 56.9 KB

If a user makes changes to this quantity, it will then update in the table as well:

Screen Shot 2021-09-20 at 2.56.43 PM
Screen Shot 2021-09-20 at 2.56.43 PM1868×1074 89.8 KB

Screen Shot 2021-09-20 at 2.57.29 PM
Screen Shot 2021-09-20 at 2.57.29 PM844×868 66.6 KB

For your last ask to see all the deliveries of a given month, you can create another screen with a list that filters only that month:

=FILTER(Deliveries,"MONTH(Deliveries[Date])=MONTH(TODAY())")

Screen Shot 2021-09-20 at 2.25.57 PM
Screen Shot 2021-09-20 at 2.25.57 PM1486×960 76.7 KB

This concept of applying a filter can be applied to any specified time frame. You can also use the built-in filter and sort controls to give the user further control to filter or sort by a particular column:

Screen Shot 2021-09-20 at 3.01.14 PM
Screen Shot 2021-09-20 at 3.01.14 PM1464×976 63.7 KB

Hope this example helps! Let us know if you have any other questions. :slight_smile: :honeybee: