Hi Team,
This community has been helpful in understanding concepts and has helped solve a lot of my problems. I am now creating a macro where I'm trying to use a drop-down to choose date and integer fields. I have however done that, but I need to use those fields to input a value by the user which will then be used in my formula. For example, let's say the fields chosen as Salary (integer) and Date of birth (date)- I now need to ask the user what number they would like to multiple the salary by and use that number in the formula tool to multiply the salary with and display the answer. I hope I've conveyed my question. I'm struggling to crack the logic for this workflow.
Looking forward to your input :)
Kind regards,
A
Sounds like you could just use a text box for this? Though the following would also work with another drop down (Using manually set values if there are specific options of numbers they can multiply by) etc
Set up a formula with any value, I've just used 10 for example. Then, in the text box action just make sure the user input is set to replace only that dummy value (10), like so:
If this isn't what you're looking for then let me know!