ContributionsMost RecentMost LikesSolutionsRe: Pipeline Upload gsheet to google doc I have the same setup with the exception my trigger is daily. I get a "Remote service reported an error: Bad Request" error. This is when I use the Mime Type as a gsheet. I have tried this booth with just the file name and also the FileName.gsheet. ------------------------------ Scott Talarico ------------------------------ Pipeline Upload gsheet to google doc I'm using Buckets to create a table and download a CSV. When I upload it to the google drive it's errors out if I make the Mime Type a Google Sheet. If I don't specify the Mime Type the file can't be read in the Google Drive. I can load the file from bucket step manually and convert it in the Google Drive manually to a gsheet so it doesn't seem the file itself. I have also tried adding the gheet extension and that doesn't help either. ------------------------------ Scott Talarico ------------------------------ Re: Connected table Pipelines or Zapier integration Thanks for the note. Specifically what I'm doing is creating a google doc template. The goal is to merge in the data to the template. I have done this already where I can map in single data fields (Example: Name, company, date, etc) but when there is a connected table the challenge has been getting a storing the data. The hope was not to have to create a loop to get and store the data and then map that to a field in the google doc template. I can look into the API_GenResultsTable since I used this when I used to use exact forms. If you have any other suggests that would be great. ------------------------------ Scott Talarico ------------------------------ Connected table Pipelines or Zapier integration I have a connected table that I want to access the data in either pipelines or Zapier. The table sources details on the products being purchased. Ideally I would like to know the easiest way to export the table through a pipeline automation or into Zapier were it could add all the table data into a google template. In the past I used Workato and created a loop that would hold all the data in a list and then I would source the entire list. Looking to see if there is an easier solution to the problem. ------------------------------ Scott Talarico ------------------------------ Re: Dynamic Rules per roleWhat I need at the moment are rules that would hide / save and/or require a field ------------------------------ Scott Talarico ------------------------------ Share Table PermissionsI have a share table that displays and allows edits of the child records on a parent table. I would like to lock the field where a role can add but not modify. I have tried a number of different restriction by role but it still allow the role access to modify on the shared table. ------------------------------ Scott Talarico ------------------------------ Dynamic Rules per roleI have 4 forms that are separated by role. I'm working on a project that may require many dynamic rules and I want to know if there is a way to apply them across all forms and all roles. Each form is very unique so I don't want to just copy the form where I create the rules. Essentially trying to create rules that apply to every form without having to create the rules on each form. ------------------------------ Scott Talarico ------------------------------ if formulaI'm creating table report and using a filter that allows the user to input the criteria when they access the report. Is there a way to use the input from the user in the report formula?Re: Allow role to add a new record but not modify existing records on a connected tableThanks for the helpRe: Allow role to add a new record but not modify existing records on a connected tableYes. I have the table on the Parent record