Using field from sheet to pull data into a form

Hello.

Is there a way to use a field that is defined on a sheet to pull associated data into a form? For example, if I have a request ID for help desk tickets. I want to use a form to query or pull in the data from a specific Help Desk request ID, allowing a user to see what is in the record.

Then, I'd like them to be able to save that data into a file such as a PDF or possibly print that specific Help Desk request.

Find more posts tagged with

Forms

Printing

Accepted answers

Hans E. Eisenman

You'd likely have to do that using Smarthsheet's APIs and an app of some sort that you'd have to develop for running the API, unless I'm misunderstanding what you're trying to do.

All comments

Hans E. Eisenman

You'd likely have to do that using Smarthsheet's APIs and an app of some sort that you'd have to develop for running the API, unless I'm misunderstanding what you're trying to do.

Edward Nadareski

Hello Hans,

Thank you for your feedback and insight.

So, if I understand you correctly, there isn't any way to query data from a sheet using a form? Or, what I think you mentioned - from any method in Smartsheet?

Thanks again!

Swescan Info

I also would like that option.

When in a form, i would like it to show content of specific columns to be able to choose row for input of data.

Like this: 1) choose project number/client name etc in first form row.

2) Form picks and shows relative data from that chosen row with in the wanted form. Filled with data if there is, empty if no data is available.

3) operator fills in, adjusts data in wanted fileds in form.

/Johan

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.