-
Report fetched through API is restricted to 450 rows only
Hello, Please note that I am using Smartsheet api to fetch a report that has around 500+ rows. Syntax - https://api.smartsheet.com/2.0/reports/<report id> This is only fetching 450 rows and I have no idea where the remaining rows went. Based on few posts through Google search, I tried pagination ways like - #1…
-
Sending form attachments to their own smartsheet or google drive folder
Hi everyone, We're currently trying to create a system that accepts form entries with attachments and stores those attachments in their own folder as soon as they are submitted. Preferrably, we would like this folder to update in real time and remove any attachments that are replaced when the same user uploads a different…
-
Experience with DDUpdate?
I have been playing around with DDUpdate over the past few weeks. It has been working well until today, where all my mappings are now inactive. Fortunately, none of the mappings are in production sheets. For all you DDUpdate subscribers out there, how has your experience been? How is the support? Reliability? I logged a…
-
Autofilling Forms
Currently we can use querystring parameters to autofill form values (e.g. https://app.smartsheet.com/b/form/18f38f1ef40223457f7afe19cc0beba5d15?Field1=Value1%Field2=Value2) , which is an extremely useful feature. However, for authenticated forms, the querystring values are dropped during the authentication process if the…
-
Create Triggers Module Issue
I have a series of sheets that I need to create triggers for that I am trying to scale via automatic trigger createion. We have a custom module in Bridge for both Create Triggers and Create Templatized triggers. I've tried using both, and while it says completed in the run log, they do not show up on the identified…
-
Snowflake EXPLAIN query support with Snowflake JDBC Driver
Is there a way to run an EXPLAIN snowflake query through the JDBC driver with the Snowflake extension? I am running net.snowflake snowflake-jdbc 3.12.8 and it throws an error saying net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: syntax error line 1 at position 15 unexpected 'EXPLAIN'.. I see there…
-
Make the Undo Button Active
Please make the undo button active. Or at the very least, make it possible to restore your sheet to a previous version.
-
Any way to get cell history other than one cell at a time?
Working to clean up after Control Center's built-in archiving functionality made a mess of one of our archive sheets (but that's a story for another time). Basically, the archiving function duplicated some rows as it moved them to the archive sheet, anywhere from 1 to 5 times each. I need to go through and clean up the…
-
Auto Sort sheet using API - Python
I have a code that should work to auto-sort my sheet, but I keep getting the message below. Others have used this script with no problem. Any advice would be greatly appreciated. Error sorting sheet. Status code: 405 "errorCode" : 1122, "message" : "Requested URL does not support this method: PUT", Here is the script I…
-
Move a row to a new sheet based on an entry on a separate sheet
Hello, My company has a sheet titled active employee roster which has every employee in the company. We are trying to create a new Offboarding sheet that will then find the employee on the Active Employee roster sheet and then move them to a 3rd sheet labeled Offboarding Archive. I am struggling to create a solution for…