I am trying to build a tool to calculate per diems. I have a list of about 50 locations, and each location has five different values associated with it (full day, first/last day, and then separate rates for each meal). I would like to make it possible to select the location, then enter the number of full days, first/last days, or breakfasts, lunches, and dinners, and multiply the rate for that location/meal and quantities entered to generate a total.
The part that seems difficult is getting the location to generate a specific set of values. If I could get these values populated into text boxes, I can figure out the multiplication part. I’m guessing it will take a combination of logic and custom scripting – any suggestions would be greatly appreciated!
I think the Login/Password Action could be really helpful in ‘generating’ the specific values for each location:
The login action allows you to upload a spreadsheet of information that can be populated into survey questions (such as textboxes) based on the entered password (which must be unique and could be the location name or code).
Hope this helps!