Show Add button with condition

[Firdaus]

Dear Appsheet Team,

i need help again 🙂

i have two table (tracker and outbound) in this case I want an add button in the outbound table is show, so that users can request materials based on the plan in the tracker table if there is a plan today and if there is no plan they cannot request materials

thanks

add action outboundoutbound tabletracker tableusersettings

[WillowMobileSys]

First, I want to be sure you are aware that you are posting in a Community Forum.  When you get responses, they are from other App Creators like yourself - not from the AppSheet Team.  The AppSheet Team only occasionally posts in the Q&A section when there is a need.


It's not clear if what you are showing as the button expression are pre-existing conditions or your attempts to add your requested condition.  I will assume the later.

It seems you want to add a condition to simply check if there IS a Plan for today - I assume ANY Plan.  I will also assume there are never any rows inserted for the future.  If true, then a more performant condition can be added as shown below.

TODAY() = MAX(Tracker[Visit Date])

I would add this as the FIRST line in your AND() function.  If it fails then the rest of the condition will not be checked. 

If it is possible that future dated rows can be inserted, then you will want to use the expression below, again as the first line of the AND():

IN(TODAY(),  UNIQUE(Tracker[Visit Date]))

 I hope this helps!

[Firdaus · Accepted solution]

@WillowMobileSys ,

Thank you for the advice given and my intention is to ask for help with what I am experiencing to all my colleagues who are connected in appshhet and for the case above I have been able to solve it with this formula