Form Search and Auto-populate values

Veronica J
edited 12/09/19 in API & Developers


I have the following project I would like to achieve in Smartsheet if possible. I have a master data sheet with information hard coded. The sheet has a key reference number associated with each assigned task. When a user wants to add a task into the master sheet, they have to open the form and enter a key reference number. However, if that user has a key reference number already in the master sheet, I would like it to auto populate those fields into the form so that the user understands not to update fields already in the master sheet. Is this possible with the Smartsheet interface license users are given? Or will this have to be a dev project?