API & Developers

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

Collecting Maintenance Requests via Smart Forms

Hello

We have a requirement to gather all maintenance requests through smart forms for multiple facilities. For this initiative, we need to collect detailed information about the facilities, the specific repairs being requested, and whether any items need to be ordered by the corporate office to facilitate the work.

As part of this process, Various Items/parts may need to be entered multiple times in a parent-child relationship. The parent row will contain general request details, such as the facility name and the nature of the request, while the child rows will list the parts or items required for the request and related data to it. The number of child rows can vary (e.g., 1, 2, 10, or more) and cannot be predetermined.

Could you please assist in designing a method to efficiently collect this information through smart forms while ensuring that parent and child rows are properly linked? Additionally, if an automated approval email is generated for the parent row, it should include all relevant child row details so that the approver can review the requested parts.

Your support on this would be greatly appreciated.

Answers

Trending in API & Developers