Forum Discussion
DanteTognoli
6 years agoQrew Captain
Thanks for the assist, unfortunately having to save it to update just means it will have to be immediately reopened so the serial numbers can be verified. I'm pretty sure that will be nixed by my boss as overly cumbersome (we're trying to get rid of an instance of that right now on the same form as they have to be signed off which can only be accomplished by saving then re-opening the signature page).
I'm also having trouble getting the report link to give me information I want. When configured to match location information from the field on the sign in app, it returns location from the tools app. So if I choose "Location 1" it returns "Location 1" instead of the serial numbers of all tools at location 1 (I have selected the tools: serial number field as the target). regardless, I don't think this solution is viable due to having to save to update.
What I'm using right now is a text-multiple choice field that looks at the other app's report for it's list of locations. I would like to then have the next field (ideally a formula in the text multi field would be more efficient, but I don't think that is possible) see what location has been selected and either look back at the same report and return all serial numbers related to that location or it could look at a report created for a specific location to do the same thing.
I'm also having trouble getting the report link to give me information I want. When configured to match location information from the field on the sign in app, it returns location from the tools app. So if I choose "Location 1" it returns "Location 1" instead of the serial numbers of all tools at location 1 (I have selected the tools: serial number field as the target). regardless, I don't think this solution is viable due to having to save to update.
What I'm using right now is a text-multiple choice field that looks at the other app's report for it's list of locations. I would like to then have the next field (ideally a formula in the text multi field would be more efficient, but I don't think that is possible) see what location has been selected and either look back at the same report and return all serial numbers related to that location or it could look at a report created for a specific location to do the same thing.