Hi,
I have an order entry system which allows orders to be exported to xero with an action button. I have multiple actions wherre the last one sets a column in the order table to โrunโ. I then have an expression that only allows the โexport to xeroโ button to show when that has been set to โrunโ.
The purpose of this is to stop users hitting โexport to Xeroโ before the order has been fully saved to the order and order details table.
The button shows up immediatley though even if [Run 2] hasnt been set to โRunโ yet
AND([Order Status]=โOpenโ,([Run 2]=โRunโ)
Thank you Phil
@Phil_Waite Not sure if this a typo in your post or in your expression, but youโve got an extra โ(โ in there:
Instead of
AND([Order Status]=โOpenโ,([Run 2]=โRunโ)
try
AND([Order Status]=โOpenโ, [Run 2]=โRunโ)
Hi,
Looks like a typo,
Full expression is this to limit which users can see the button at all anyway. The current user type and USEREMAIL() works fine but not the โRunโ bit.
AND([Order Status]=โOpenโ, [Run 2]=โRunโ,
OR([Current User Type]=โALLโ,USEREMAIL()=โinfo@listersbrewery.comโ))
Thanks
Phil
@Phil_Waite Have you checked the behavior of your condition via the expression tester? That might help narrow down the problem. You can see how each sub-part of your expression is being evaluated. https://help.appsheet.com/en/articles/961202-expression-assistant-and-expression-builder
Try this instead:
AND(("Open" = [Order Status]), ("Run" = [Run 2]))
Hi,
Iโm still getting the button show up. I enter the order and immediately go to a slice showing current orders. The order just entered shows but with the button even though โrunโ has not been written to the spreadsheet.
I need to stop users trying to export to Xero before the order has been saved properly.
Full expression below
AND((โOpenโ = [Order Status]), (โRunโ = [Run 2]),
OR([Current User Type]=โALLโ,USEREMAIL()=โinfo@listersbrewery.comโ))
Please engage support@appsheet.com for further help with this. Someone will need to look at your app configuration.
Thanks Steve
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |