Webform not updating after sheet changes

Hello

I have created a simple sheet with data for internal materials requests, including an approval loop via workflows.

I then created a webform to gather input; in order to test it, in the approver / exectutor user fields I used fake data (=always myself and my colleague) to test it. It works.

I have now updated the user lists (in the concerned columns), but the webform has not updated itself and still it presents the old names in the field. Why on earth?!?

Thank you

Find more posts tagged with

Forms

Manufacturing

IT & Operations

Comments

Andrée Starå

Hi Alessandro,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

alessandro.pian112971

Here you go the screenshots (SS-x). Sorry for menus in Italian language.

Loog at field Purchasing Executor: after initial test with temporary users, I have defined (SS4.png) the field in the sheet with the correct name of the buyer, but the form field is not updated consequently (SS5.png) and it still presents the two test users originally set.

Manager field: even worse. I have updated it (SS1.png) with the four managers to select, but had the same problem as above. So I deleted the column and re-created it, then made sure it was in the form edit window (SS2.png), but in this case the form does not show the field right away! (SS3.png).

So, beyond a certain point the form "refuses" to accept some modifications.

Andrée Starå

Thanks!

Can you share the sheet or a copy of it with me, and I'll have a look?

cciegirl2012

I am having the very same problem. Was this ever resolved?

My situation is very similar:

I created a form to input data into an existing sheet that I created from an import of an excel .xlsx file.
The form will update the data in the sheet. However, in the fields that utilize pull-down lists from previous entries, I do NOT see the values for the entry I just made.
I deleted all empty rows, and changed the sheet behavior to add updates to the TOP of the sheet.
Still not updated data in the pull down lists.

Do I need to refresh the form or something to pull the new data into the form list fields? How do I do that?

Thank you, I appreciate your help and consideration.

cciegirl2012

Genevieve P.

Hi @cciegirl2012

A form will create a new row in your sheet but it won't change the column properties of a dropdown column.

To do this, you'll want to either edit that field in the form, or edit the dropdown options directly in the sheet by double-clicking the column name.

See: Maintain consistency in data collection with dropdown columns

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Trending discussions

Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Workspace is still there but all folders are empty
Hey, I had a Project in January where I created multiple sheets, dashboards etc. Now I want to prepare the same project again but all folders are empty. Not a single sheet is left. How is that possible ? I upgraded to a paid account during that time and Iwanted to do that again but smartsheet do not delete everything if…
Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…