Jump to content
  • 0

[FYI] Dynamic choices for for a date dropdown


Wikiwi

Question

I have a workflow that will only let a user enter a date ranging from 7 days before the current date. Obviously a calendar pop up wont work since I can't disable other choices there. So I created a  task that will update the table daily and put the necessary choices that I have. This way its dynamic and I don't need to change it everyday.

Here is the Task:

image.png.abbabac607af60fca6181d4738c0a75e.png

The task above will run every day and will first delete all the existing records within the table and replace it with the new set of 7 days. An example would be. Today is May 10 here in my location and  that will give me May 3 - May 10 of range.

Table:

image.png.1b524bd9407e9b40f61b683a07b96f78.png

DataPage:

image.png.f7bb30a85c8ea4e398c2490ee4918e53.png

Note: You can also edit this workflow where when a date is selected that option will be removed from the Table. That will use a trigger that will delete a date when it sees it after a user submission.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...