Prevent Future Date Selection

jmpru2019

Hello!

I'm building a model where users can input the dates when they complete certain training events, and then taking that information and creating visualizations/analytics off of it. In order to keep the data clean, is there a way to prevent the user from selecting a date in the future since I only want to deal with actuals in this instance?

Thanks!

Accepted answers

All comments

bhatjaved

@jmpru2019

Yes there are many ways to place security for users ,depends where you wana restrict them and on which dimensions ?

Go through user security lessons in community you would be able to judge what type of security you can have in place . In brief you may want to restrict users here with the help of DCA . create drivers and restrict users accordingly

rob_marshall

@jmpru2019

Yes and no. No, in the fact that if a user inputs an invalid date, we don't have a way to "clear" it out automatically or prompt them for a valid date. With that said, there are a couple of ways you can get around this.

The easiest way is to use conditional formatting to highlight the line item in red (or color of your choosing) if the date falls outside of the threshold. Also, create a boolean to be on (True) if the date is valid and now downstream calcs and reference the boolean as well as filters for views.

Another way is to have a list of days that can be used, but this can be cumbersome as well as a maintenance hassle.

Hope this helps,

Rob

ManjunathKN

Hi,

You cannot avoid the same line item to prevent from entering future date. You can use above solution from rob to identify future dates by conditional formatting.

But if you have additional information entered along with end date of training, you can stop that.

Add one more LI and format it as boolean and write formula to identify future dates and use it as DCA in other information(LI) where your trainers has to enter after end date.

Additionally you can use a text formatted LI and use if else to display hard coded text like "please enter valid date".

Thanks,

Manjunath

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…