You’re offline. This is a read only version of the page.
The idea is to create a simple Power App, where the Sales team would be able to enter the Monthly forecast and then update the progress on a weekly basis.
What I need help is to get this last 4 blocks disables based on the calendar date, which means the Sales team should not be able to enter/ edit the Week 1 box after 7th of the concerned month, Week 2 box after the 14th of the concerned month and so on.
For the Week 1 box, the last updated number on or before 7th of the month should get stored without any further permission of edit and so on for the other boxes as on 14, 21st and 28th respectively.
Having a hard time to get this done. Any help on this would be highly appreciated.
You can use this formula to disable the textbox controls in the textbox's DisplayMode property
Share
Report
All responses (
Answers (
If(Value(Text(Today(),"dd")) > 7,Edit,Disabled)Replace 7 with the appropriate date number for each box.
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
463
