-
Attach an existing Dynamic View to a sheet programmatically
I know there is no API for Dynamic Views yet, but I'm looking into building some automation for a client and wonder if there is a way to programmatically assign an existing Dynamic View to a new sheet. It doesn't look like when you copy a sheet and create a new one via API, the Dynamic View associated with that original…
-
I Cant seem to get my gif work on a smartsheet dashboard
I like the design of the smart sheet PMO dashboard setup(link below) and attempted to design a replica for my solution but have not been able to figure out the gif part. After converting my video to a GIF and ensuring that the size is below 30 MB I attach it to the dashboard but it doesn't animate. how can I go about this…
-
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…