Tech Talk: Implementation

Hello Alex,  The image that is produced from a signature is pretty static from our end in terms of background transparency and size. From what I have seen there is no way with an Office Script to change the transparency of the background of an image either.  Using an Office Script, you might be able to specify in the cell vs on the cell but not sure that will help because as you mentioned, with the big background the actually signature will be really small when goes in a cell.  Thank you ------------------------------ Read more

Hi Ian  Is there a way to use a similar approach to format images that are inserted into an excel template from the forms, specifically signatures? I would like the signatures inserted in our template to be bolder and placed in the cells, rather than on the cell.  If they are not placed inside the cell, they do not align with the center and they overlay the cell borders.  I can do this manually and make the signature bolder by applying an 'artistic' effect to the image, however, would you Read more

Hey Alicia,  That is an awesome use case for this, would you mind sharing how you are handling that?  Are you sending the signature to a folder in OneDrive and then using the Office Script to pick it up from there and put it in your spreadsheet? I love hearing about the creative ways that our customers are solving problems like that!  Thank you  ------------------------------ Ian Chamberlain Solutions Architect TrueContext ------------------------------

Hello Ian, I'm already using this process in a workflow to insert signatures from a Customer Feedback form in an exel generated by a normal Form. It works great! Alicia ------------------------------ Alicia Rico CI Johnson Controls ------------------------------

In this post, we are going to demonstrate how we can perform some automated tasks to an Excel Template Document that is generated from TrueContext, specifically, we will be dynamically renaming the tabs in a Workbook based on the data that is in each of the sheets. These scripts can be very powerful, and this example is just scratching the surface on how to get started.   Our Excel Template documents allow you to map out, cell by cell, which answer you want to put into which cell. This is a great Read more

A hot topic in recent days is how we can take all this data that is being captured within TrueContext, format it in a way that your backend systems understand and send all the data once a submission has taken place on the form. One of the more universal formats that most systems will be able to understand is JSON so that is where the focus is going to be today.  One of the document types available in TrueContext is a Handlebars document. Handlebars (often mistaken for the handlebars on your bicycle) Read more

Hey all!!  First things first, for those who have read an Ian's Insights in the past. I AM BACK! For those who haven't read or heard of Ian's Insights, it is nice to meet you! Going forward, we are going to change these types of posts from being Ian's Insights to IS Insights (Implementation Specialists Insights) because these are truly a team effort.  After a little time away, I have rejoined the TrueContext team as a Solutions Architect focusing heavily on integrating TrueContext into your Read more

In this post I'll be explaining how to dispatch submission data from a Repeatable Section in one form to a Repeatable Section in another form. To do this, I'll show you a workflow where a user can define a set of instructions or a checklist and then send that list to another user to complete. This workflow suits a use case where: There is a group of users that are consistently needing to define steps for another set of users The number of steps is not too large to reasonably enter one-by-one Read more

Hello to all my fellow community members! This post will be a slightly different style than normal, because it will unfortunately be the final episode of Ian’s Insights. It has been such a pleasure putting out these posts, part of the reason that I liked doing these is because these topics were always based on a problem that I was currently solving for a customer. I never let Pat know what I was going to write about until the article was posted (sorry Pat) and I really hope that these posts come Read more

This topic comes from a less "automated" topic but will help you greatly in the long run if you aren’t already doing so. Creating a clear and concise form submission name can help you keep track of things internally. You can use the Form Submission Name for things like filenames and email subject lines so at the end, you will have a submission, a file and an email all with the same contents. Our documentation portal provides some great examples on how to structure this name and some reasons why Read more