Is it possible effectively land a formula in a cell of our submission sheet through our form?

  • Profile Image
    Asked on August 08, 2015 at 10:32 AM

    We take advantage of the Google Sheet integration. We are currently re-evaluating the layout, design and functionality of how we are using Jotform in connection with Google Sheets. The submission sheet also feeds our mobile app which is an essential working tool for our mobile business. Yesterday...we were flying blind. Everything looked good. The integration said "green light here guys", the mobile app "no worries here boss".However, when that first order came in yesterday we knew things were anything but ok. The integration chose a new sheet to be the host and the mobile app housed only a ghost of a now stagnate sheet that once was where our orders would ultimately land. Everybody needs that first position in the work book which makes it very difficult as well. For the most part, we've got things back under control and all systems check today. Appsheet, is a google sheet add on that we use for our mobile working, guiding and viewing needs, our mobile app. Appsheet does not like to share the workbook space with other sheets and I know you guys know of the problems with importrange in conjunction with forms in general from reading about this problem here in the forum. With Appsheet, the more sheets you have in the workbook the more it slows performance as it is all processed on their backend if it is in the workbook therefore henders our ability to tranfer much needed information during our normal daily operations when we sync for those updates. 

    Long story a little shorter. We were advised to minimize the 17 sheets we had in the workbook to a minimum in order to achieve optimal performance. I got it down to 4 sheets. The next day when we opened (yesterday) I wished I hadn't touched it. So many things connected, work arounds and arrays and more work arounds because of the arrays  and so forth. It has come up that we could cut down close to half of those work arounds if we could somehow manage to have a hidden field on our form conditionally drop a simple "IF" statement when certain criteria is met. Just to be clear I am trying to calculate after the form has been submitted and hits the sheet.I have tried just a simple equation in the field a form to see how that works out and I almost got real excited but not quite. I know this is not a Jotform issue by any means or measure but I also know that if this can be done you all would know and could advise me. Any feedback would be great. Thank you in advance

  • Profile Image
    Answered on August 08, 2015 at 03:57 PM

    I'm sorry, but I don't think that is possible in our current integration. You are basically after of the formula instead of the result, right?

    Why not do it in the form instead? You can do a calculation in the form: 

    And you can mathematically add values:

    Kindly check and let us know.