Can DOMO user with participant role submit the values into pro-code editor app if user is not owner?

ValentinaSav

Hello team,

I have developed a pro-code editor app and shared it with a Domo user who has a participant role. The objective is to grant the user permission to submit new values into the table. The user can input values into the table, but when they click the 'Submit' button, the status remains stuck on 'Submitting' and the dataset does not update. I have attempted to change the user role to 'Editor' and even made the user a co-owner of the dataset, but it is still not functioning. Could you please provide any advice?

Thank you!

JosephMeyers

Short answer - yes.

Long answer -

I am going to make some assumptions based on the default or more common ways different customer make custom apps in answering this and hopefully it lines up to what you are doing. When you say "submit new values into the table" I am going to assume you are storing that values in an AppDB collection. You can share permissions to the collection and documents to Users, Groups, and the custom app itself. Any of these will work but normally we rely on the custom app's permissions for something like this. By default, when you create a new custom app it grants Read, Read Content, Write Content, Update Content, and Delete Content to the custom app. This means that if you share the custom app card with your Participant user, they should be able to submit new values into your table. If you have custom permissions set you would need at least Write Content to submit values. Ownership for custom apps and their collections is not the same as permissions so you shouldn't need to worry about the Owner.

As far as syncing to a dataset, that is a separate thing. First, the collection needs a defined schema and needs to have sync enabled. Documents in the collection also need to adhere to the defined schema or the dataset will error when syncing. Lastly, the Owner of the collection needs to have the correct permissions on the collection (I believe at least Read and Read Content) and also have full permissions on the dataset you are syncing to.

ValentinaSav

Hi Joseph,

Thank you for your response.
Your assumption is correct - the values submitted by the user are being collected in the
AppDB collection. When I shared the app, I also shared the AppDB collection with the users, granting them 'Can edit' permission.
Regarding the 'Write content' permission - should I customize the 'Participant' role by adding the 'Write content' permission?
If so, where can I find it in the list of grants?

Thank you!

JosephMeyers

It is not a grant on a role and you shouldn't need to edit the role. It is the permission on the collection. When you user tries to submit is there any error in the network tab? You can see this by enabling the devtools on the browser.