Is it feasible to automatically transfer input from form data with added formatting and information?

Options
cbgb_jk
cbgb_jk ✭✭
edited 03/17/25 in API & Developers

Hi,

I am attempting to reduce the need for manual data entry.

Essentially, I would like a system where a sales colleague can check off a list of processes when they receive an order, lets say A, B, and C.

A new sheet is created for production showing they need to complete processes A B C.

The problem I am facing is that I do not simply want a sheet showing a client name and what their job requires, I need it listed as such:

PROCESS | HOURS | TOTAL


A——————————————-——————12

  • Electrics————————4
  • Wood work——————-2
  • Metal work——————-6

B——————————————-——————8

  • Electrics———————-4
  • Wood work——————2
  • Metal work——————2

C——————————————-——————30

  • Electrics————————8
  • Wood work——————-10
  • Metal work——————-12
—————————————-50——————-50

The extra data of the hours and job breakdown can be stored in another sheet, I would just need Smartsheet to grab the processes needed following the form.

I am aware this isn't possible simply with Smartsheet features, I would need a program and to use the API of sheets to do so, I also imagine I would need to create the new process sheets manually and connect them to the system.

My question at the end of the day is how feasible this is, would it be an expensive and mammoth task to program this? Is it possible within Smartsheet?

Thank you

Tags:
· Share on FacebookShare on Twitter

Answers

Categories

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com