Show/Hide Certain view based to day of the week

[davidmcgovern]

Hi,

I am currently designing an app for our deli employees to use for ordering from our centralized kitchen. Deli employees enter how much of a particular product they have at their location, then that number gets subtracted from the set par and the result is how much the store will receive for the next day.

For example: John has 5 sandwiches at his store, the par is 9, so the app calculates that he should be sent 4 more sandwiches from the central kitchen.

On Thursdays, however, the Deli needs to make a larger order because the central kitchen is closed over the weekend, so they need to receive enough product on Friday to last until Monday. How do I get the app to calculate the order using a different par for Thursday's order automatically?

Thanks and hope yall are having a great day!

[Suvrutt_Gurjar]

In general, what you are looking for should be possible.

You could suitably use the WEEKDAY() function of Appsheet.

[davidmcgovern]

Thanks for the reply.

How would you use the WEEKDAY() function to make this happen?

[Steve]

How do you calculate your number now? Please post a screenshot of the entire expression.

[davidmcgovern]

Right now I have a whole separate view that the user has to select manually on the proper day of the week.