Hello, I have this form in excel to assess damage to signal lights and I would like to have this in Survey123 so the damage can be recorded in the field. Does anyone know if there is a way to set Survey123 up to allow me to fill in the quantity and have the cost update automatically? Thanks much! (I haven't posted before so please let me know if I need to share more information.)
Solved! Go to Solution.
Hi Lindsay,
This can be accomplished in Survey123. If you have relatively fixed prices, you can encode the calculation directly in the form (see the Excel attachment). A slightly more flexible option is to have the item order section as a repeated section; you can then store the individual items prices as a CSV file associated with the survey and look the prices up; after the user chooses the item, the unit price is looked up and the cost can be calculated (see the zipped form attachment).
Hi Lindsay,
This can be accomplished in Survey123. If you have relatively fixed prices, you can encode the calculation directly in the form (see the Excel attachment). A slightly more flexible option is to have the item order section as a repeated section; you can then store the individual items prices as a CSV file associated with the survey and look the prices up; after the user chooses the item, the unit price is looked up and the cost can be calculated (see the zipped form attachment).
Thank you so much for the quick response! Very helpful!
Hi Lindsay
If your list of items is also "static" then you can have a repeat that goes through all your items from top to bottom... so the repeat will step through all the parts and let the user capture the quantities if applicable. That way they wont accidentally skip an item but will be forced to go through the whole list.
I wrote a blog about this "trick" and you can view it here: