Proxy and Row Level Permissions

Follow

Comments

16 comments

  • Avatar
    E- Pédagogie

    Hi,

    I've set up Awesome Table on my Google Site with the apps script proxy.

    Everything is working great (displaying row to specific user) but the user cannot modify his row.

    Sharing settings of the Spreadsheets is set to allow a person from the domain to modify the Spreadsheet and I've copy/past the url edit view from Awesome Table and insert it in the Google Site.

    Am I missing something?

     

    Source : "In conjunction with a Google Form, Awesome Table can display only the entries submitted by the user and allow them to modify those."

  • Avatar
    Awesome Table

    Hello E- Pédagogie,

    This article is about displaying different content for every user, so there is nothing you did wrong.

    When you give someone edit rights for your spreadsheet, they will be able to edit your spreadsheet but not your Awesome Table directly. You cannot edit the settings of your Awesome Table from somewhere else than awesome-table.com (so you can't display the"edit view" in your website).

    If you want users to edit the content of your spreadsheet, I would advise you to follow this tutorial on connecting Awesome Table with a Google Form.

    Nicolas

  • Avatar
    Kbella

    I don't know where else to post  my comment -

    I want people to be able to view the Awesome Table via a Google Site. 

    I don't want them to be able to view the spreadsheet that feeds the data to the Awesome Table view, becuase it contains additional information that I don't want them to see. 

    So having to share the source spreadsheet defeats the purpose. 

    Is the proxy the only way to avoid this? 

    Thanks, 

     

  • Avatar
    Awesome Table

    Hi Kbella,

    When you integrate an Awesome Table view in your website, people can only access to your spreadsheet if you give them permission (if you share the spreadsheet).
    So you don't need a proxy to avoid this.

    Thomas

  • Avatar
    Sam Haller

    Hi,

     I'm getting this error message when I test the web app after running the script and deploying.  

    Invalid argument: url (line 18, file "Code")

    I've gone to Script Editor on my Form Responses 1 sheet and copied the proxy script into a new project.  

     

    Thanks!

    Sam

  • Avatar
    Awesome Table

    Hi Sam Haller,

    Would it be possible for you to share your spreadsheet at "support@awesome-table.com"? If you have sensitive data, you can make a copy with similar data.
    It would be helpful for us to take a look at your code.

    Regards,
    Thomas

  • Avatar
    Nahdi Lazar

    Hi,

    I was looking for an article about setting permissions and this is the only one I found, sorry if it's not 100% relevant.

    You wrote "In a classic use case, Awesome Table fetches the data directly from Google Sheets and people are allowed or not to view data based on the spreadsheet sharing settings". My sheet is set on private and is shared with specific people only and I would like my Awesome Table to be shared with the same people, however it seems to be open to everyone with a link. Is there a way to set permissions or adopt the permissions from the source sheet?

    Thanks for an amazing product,

    Nahdi

  • Avatar
    Awesome Table (Edited )

    Hi Nahdi,

    I suggest you consult this article or this one. If you want to share your view just with specific people, you just need to select "Off - Specific People". Then you need to fill in the mail of the people you want they have access. 

    Kind regards,
    Thomas

  • Avatar
    Nahdi Lazar

    Thank you for the quick reply Thomas.

    As I mentioned I already set up the sharing preferences as you suggested, but for some reason could still see the data even when I was logged out, and also after refreshing. Strangely enough, the problem is gone now - perhaps it was a caching issue as I couldn't recreate it.

    Actually - now I have the opposite problem: when logged out or when logged to an unauthorized Google account, I do get the log in screen, but the "Log In" button does nothing when clicked on. Tested several times on both Chrome and IE.

    Another issue - apparently, Awesome Table first renders the table, and only then checks permissions. On slow connection such as the one I'm currently using, this means that the data is actually shown for a long while until it's being covered by the log in screen. This way unauthorized users can still get a glimpse of some of the data.

  • Avatar
    Awesome Table

    Hi Nahdi,

    Indeed it's strange. Would it be possible for you to share your Awesome Table view and your spreadhseet at "support@awesome-table.com"? If you have sensitive data, you can make a copy with similar data. Just make sure we have access to your data.

    The problem with the login button is now solved and it should work for you.

    Kind regards,
    Thomas

  • Avatar
    Nahdi Lazar

    Thank you Thomas. Log in issue is solved.
    Excellent support and incredible product! Thank you!

  • Avatar
    Awesome Table (Edited )

    Hi Nahdi,

    We are really glad you like our product!
    It's a great satisfaction for us. :)

    Kind regards,
    Thomas

  • Avatar
    Sfaulkner

    Dear Awesome Table,

    I am very impressed by your product.  However, I need to display my newest entries first from a query that I have set up.  Is there any way in which I can do this?

    Regards,

     

    Simon

  • Avatar
    Awesome Table

    Hi Sfaulkner,

    You can try to use the "query()" formula and get the results of this formula. But you need to use header = 0 (the third parameter of the formule) otherwise it will concatenate the two first lines and it won't work in Awesome Table.

    Kind regards,
    Thomas

  • Avatar
    Sfaulkner

    Dear Thomas,

     

    Thanks for your reply on this.   This is an awesome gadget. I realised that it was possible to get my query sorted before passing the data to awesome table.  Doing this, means that it is automatically sorted by date and time, so no matter which user is looking at the data, the most recent row appears first.  I'm sure as I continue to build a tutoring system around this gadget, I will have other questions..

    Thanks

  • Avatar
    Awesome Table

    Hi Sfaulkner,

    I'm glad you resolved your issue and you like our product!

    Please let us know if you have additional questions.

    Kind regards,
    Thomas