Hello. I am designing my first analytic app and I have managed to work through the majority of what I want to do. However I am stuck on 2 aspects and would appreciate any help.
1) Part of my current workflow is a text input for a period end date. This period end date is then used in a formula to calculate the previous 4 period end dates, which in turn rename column headers later in the workflow. I want to replace the text input with a date interface, however selecting Update cell or Update Value don't seem to work. How can I simply use the Date interface to create the date value in a new field? Do I have to use the interface to update an existing text input field?
2) Another interface option will be the client name. I would like this to be included in the output file name but I cannot see any way to do that unless its as a field within the output itself, which I dont want. Is there any way around this?
Many thanks
