Customer add/edit sheet rows

edited 12/09/19 in API & Developers
09/29/18 Edited 12/09/19

I need customers to be able to add rows of information to a smart sheet, and later be able to edit those rows. A scrolling table view interface would work better than a form so users can see multiple records at a time.

The sheet needs to be secure so that customers can only see/edit their information, and not be able to export a sheet or report or use any other method to expose the information of other customers.

The rows they add/edit need to support formulas which calculate as customers enter information, which I understand cannot be done with web forms.

The solution should be something i can add to my ecommerce web page for new or existing customers to use. I would like everything automated so that customers can create an account, enter and update information, return at a later time and update previous entries, etc without manual intervention steps.

What is the best way to achieve this? I am using Shopify and I know there is a Zapier interface to Shopify - will that achieve what I want to do, or is there another way to do this?

Thanks for your help.

Comments

  • Hi,

    Check out our Status View app: https://www.smartsheet.com/apps/status-view

    (There's a link on that site to contact our Sales team if you have further questions.)

    The app gives you the control that you're looking for. 

    If you're looking for something that allows for more custom branding options though, you might see how Zapier and Shopify can automate information over to Smartsheet.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    How did it go? Did you manage to get something set up?

    Have a fantastic weekend!

    Best,

    Andrée Starå - Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.