Question - Dependent Fields

bzamborski · 2018-06-29T12:09:52+00:00

We have a few questions: * When our users are entering data in a form, is there a way to default certain fields based on other entries? * When users enter data, we only want them to see their submissions and not those of other companies/users? Can groups control that?

bzamborski

We have a few questions:

When our users are entering data in a form, is there a way to default certain fields based on other entries?
When users enter data, we only want them to see their submissions and not those of other companies/users? Can groups control that?

Find more posts tagged with

Forms

Comments

Andrée Starå

Hi,

Sorry! I was in a rush and saw that I misread your question.

Unfortunately, there isn't a way to do it natively, but you can do it with an integration called Smartsheet Sync that connects to Google Forms.

Please see attached link/screenshot.

https://www.smartsheet.com/apps/google-forms-smartsheet-sync

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Paul Newcome

You could create a form so that, when entering data, users can only see what they are submitting. You could then create a report for each company and share the report instead of the "master sheet".

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…