list of question need advise to do. thx

[bbsin]

Hi

I have a gallery,

1) I want to hide view when drop down has number but not hardcode it. as the numbers are not fixed. 

If(dpDownQty.Selected.Value, true, false)

2) when user submit patch to close dropdown and patch button and show view

3) when the available total full ,  not to show all the view, patch buttons and dropdown box; and i have a Status box - text field - to display auto as CLOSED

4) based on the date and time of the event to auto open open the check button and box for user to click submit to collect the date and time when they click,   and sure if the can also auto close after the date and time given a set date and if user did not click to check, it will show as not checked as status 

can it be done?  Thanks.

[JR-BejeweledOne]

It can be done.

You can set the visible property of the various controls using an if statement to check the various conditions when they should be visible or not visible.    I would start by setting a variable on the OnVisible property of your screen.   UpdateContext({ Submitted: false }).   Set that variable to true after the patch statement in your Patch button.

Then your visible property on the View button should look something like this:   For your available total full, you could do a CountRows of all the empty slots and use that in the visible formula

If(
   Submitted, true
   Formula for available total full, false
) 

Do something similar for the other controls.   For the Dropdown and Patch controls:

If(
   !Submitted, true
    CountRows(DataSource, Filter(DataSource, IsBlank(Somefield))) >0, true,
    false
)

For the checkbox to be visible, you will need to do some date/time math most likely to show your box.  Here is information on the functions you would need.  https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff

[bbsin]

@JR-BejeweledOne 

Hi Thank you for your reply

I am lost. where to get the somefield and formula??   Thanks

[JR-BejeweledOne]

3) when the available total full , not to show all the view, patch buttons and dropdown box; and i have a Status box - text field - to display auto as CLOSED

Where are you getting the available total from?

[bbsin]

@JR-BejeweledOne 

Yes #3.  

The total is input from a SP list that the admin will input call total column

Can also ask how to return - unblock by user number as 1 and update to the admin list and records?  Thanks

[JR-BejeweledOne]

My earlier answer was not correct.   I see you are using varToBook.TotalSlots.   When all the slots are full, this should be 0, correct?

For your view button:

If(
    Submitted, true,
    varToBook.TotalSlots = 0, false
)

For Patch and dpDownQty

If(
    !Submitted, true,
    varToBook.TotalSlots = 0, false

)

For your status text box

varToBook.TotalSlots = 0    If you get an error indicating that you are comparing text to a number, then

varToBook.TotalSlots = "0"

I am not sure what you are asking in your last question.   What do you mean unblock by user and where should this be updated to?

[bbsin]

@JR-BejeweledOne 

Hi JR,

Thanks yes. u  are right.. I might have do it wrongly.. there's error.  

When all the slots are full, and with the old formula

the first patch is working but not the rest ???

it will show

I might have done someth wrong..

[JR-BejeweledOne]

I see an error under Submitted.    Did you create the variable yet?  

In the OnVisible of your screen, UpdateContext({ Submitted: false }).    In the OnSelect of your Patch button, after the patch statement,

UpdateContext({ Submitted: true })

[bbsin]

hi @JR-BejeweledOne 

Yes, thanks.

I have questions, 

1) patch button - when I click only work on the first button and not the rest.  is my syntax not right

2) and also if I want to have a button (Unbook) to return - how to allow user to cancel to unbook the slot they taken and update back to the admin list - total back +1 and slot taken - 1  and remove from the overall records?  and the gallery sentence of the reminder should update too?  Thanks.

Do I need to post a new post?

Thanks

[JR-BejeweledOne]

You can go back to the one that works for your total slots.   Have you tested the 'Submitted' variable by putting into a label to see what is happening with it?