A date type variable needs to have a functionality where the default value can be set to today's date
@Kunal @dnewc @EhubMcCoy @JasonAltenburg @BryantCafferty take a look at this tutorial video:
That's a great workaround @ellibot thanks for sharing!
Very cool, @ellibot! Trouble for me is I don't have access to Workflows in my instance. Hopefully @Matt Tannyhill will have good news for us soon on a native solution within the core product soon! 🙏
Hi @ellibot - Thanks so much for the info and informative video. We don't have workflows though - and I'm not a programmer by schooling. Do you think this could be done with Python or jupyter? Any thoughts? Appreciate your time!!
When using a date variable, a new default value 'Today's Date' should be an option. It should take the date of the current timezone of your instance.
This seemingly simple update would be powerful for my team. Right now, any dashboard using a variable is then not able to be turned into a scheduled report because the date variable would always need to be updated before the report goes out.
Bonus: Allow for a calculation like subdate(currentdate(),interval 1 day) to set the default to yesterday.
This feature would be very helpful
Specifically, having the ability to set the default value of a variable to a dynamic value such as current_date(), instead of having to choose one static date.
Bump. Are we still waiting on this? How many other requests have over a hundred up votes? I concur with @Jones01, not just default to current date, but to a beast mode formula would be ideal.
@ellibot , Can you share the code which updates the date variable either here or in the Domo community instance?
I was able to follow your video till the part where we are able to see the variable "expression" value.
I cannot replicate on how you actually went and updated that value in your code.
I believe it'll be helpful for everyone if you share your code till Domo makes the update on allowing us to set dynamic default date.
Thanks in advance,
Bharath.
@b_rad here is the code engine block I wrote to update the default date of the variable. This can be called in the workflow. You will pass the variableid as a parameter.
Thanks a lot @ellibot . That really helps.
Appreciate your help in this.
@ellibot, By any chance, have you also figured out how to add new values to text variables using code engine?
Thanks.
Alerts Product Enhancement Ideas
Analyzer Product Enhancement Ideas
API Product Enhancement Ideas
Apps Product Enhancement Ideas
Appstore product enhancement ideas
App Studio Product Enhancement Ideas
Beast Mode Product Enhancement Ideas
Buzz & Navigation Ideas
Charting product enhancement requests
Cloud Amplifier Product Enhancement Ideas
Code Engine Product Enhancement Ideas
Ideas or feedback for the Domo Community or the Community Forums.
Connectors Product Enhancement Ideas
Dashboard Product Enhancement Ideas
Datasets Produce Enhancement Ideas
Domo AI Product Enhancement Ideas
Domo Bricks Product Enhancement Ideas
Domo Developer Product Enhancement Ideas
Domo Everywhere Product Enhancement Ideas
Federated Product Enhancement Ideas
Product enhancement ideas for Domo as a whole
Governance & Security Product Enhancement Ideas
Jupyter Workspaces Product Enhancement Ideas
Localization product enhancement ideas
Magic ETL Product Enhancement Ideas
Mobile Product Enhancement Ideas
Reporting Product Enhancement Ideas
Product enhancement ideas for Sandbox
Software integrations product enhancement ideas
SQL Dataflows Product Enhancement Ideas
Variables Product Enhancement Ideas
Workbench Product Enhancement Ideas
Workflows Product Enhancement Ideas
Other Product Enhancement Ideas
