Database, Infrastructure, Coding
What database is Smartsheet running on? (SQL serves, MongoDB, Proprietary, etc.)
What cloud infrastructure is Smartsheet using?
What programming languages can I use? (HMTL, JavaScript, CSS, JQuery, SQL expressions, etc) Are there built-in functions as well?
Hope someone can help!
Thanks!
Answers
-
Hi @Vineyard
Smartsheet has multi-site data redundancy, hosted within AWS facilities. You can learn more about this and contact the Security team at Smartsheet if you have additional questions from the Trust Center, here.
In regards to languages, you can use C#, Java, Node.js, Python, and Ruby with the Smartsheet API. Here's the Smartsheet API 2.0 Documentation, and the Developers Portal.
You can also use the Live Data Connector to connect a SQL Server with Smartsheet. The Smartsheet Live Data Connector is built on ODBC standards and can be installed as a driver in other ODBC environments.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Can we do any programming within a Smartsheet template (like a macro in Excel file).
Kind regards,
IPC
-
Hi @IPC
I hope you're well and safe!
No, but you could use Workflows, the Smartsheet API, or 3rd-party solutions to maybe do something similar.
Is that an option?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks @Andrée Starå for your reply. I will look into it. I am looking at embedding validation and automation.
e.g.
- Weight column adds up to total of 100%. If an entry would cause it to exceed 100% then the entry on the children will trigger an alert "Weight exceeds 100%"
- There are quarterly columns of status (i.e. started, midway, major, complete) but by default is "not started". And when a status in one quarter is updated, the next/succeeding Status columns until the end of that activity automatically updates. (e.g. If i update Q1 to "Started" the next quarters will follow as "started". In Q2 when I update to "Midway" the rest of the quarters will be updated.
Do Smartsheet API come with a cost?
Looking forward to your advise.
kind regards, IPC
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives