Latest Contributions by JeffDavis7

Joe, Thank you for the links.  No, I had not seen those blog postings.  The examples illustrated certainly seem like they could work with my survey.  While not extremely complicated to employ, I guess I was hoping I could simply have the user type in the text necessary for their unique situation even though the question is a "select one [list_name]" question.  I'm probably trying to do two things in one question that cannot happen. Jeff ... View more

Thank you, James. That's exactly what I needed. Much appreciated! Jeff ... View more

Thanks.  You too. ... View more

Eric, Thank you.  The Every Day option is exactly what I need.  Thanks again for all your help.  You were an excellent resource.  Appreciate your time. Jeff ... View more

Hi Eric, The filter worked perfectly!  Thank you for that suggestion.  I really appreciate your help with my project. The only other stumbling block I am experiencing is the scheduling function.  Since the Google Sheet is not a Trigger, "Immediately" is not available as a selection.  I'd like to have it just run one time without intervals.  When I choose "Once" Integromat wants you to enter a date.  The dates can obviously change depending on the replacement date of the battery so one absolute date will not be valid. Jeff ... View more

Eric, I've updated my attachments.  Lots of changes since I started this adventure.  Using Google Drive I was able to create a Google Spreadsheet featuring two headers; one for meter number and another for replacement date.  The attachment entitled "Google Sheets-Add a Row" corresponds to my configuration of that scenario.  I've tested this scenario and it functions very well.  An alert is provided via email and the Google Sheet is populated with the corresponding meter number and replacement date from the survey.  That's great! Can you provide some guidance on the next stage?  Following your suggestion, I have created a second scenario illustrated in my attachment as "Google Sheets-Search Rows".  The final attachment to this posting entitled "Google Sheets-Search Rows Configure" illustrates a screen capture where I am a little stumped.  I have a column in Google Sheets entitled Battery Replace Date (MM/DD/YYYY) and Meter Number.  Ideally I would like someone to receive the reminder corresponding to the date and supply them with which meter requires its battery to be replaced. Thank you in advance for any assistance you can provide. Jeff ... View more

Hi Brandon, I really appreciate you taking the time to construct and forward all the pertinent links. Yes, I have another thread going but saw you had contributed some additional insight related to my inquiry and was curious about your suggestions on the topic. Thanks again and I will touch base when I have reached a conclusive resolution. Jeff ... View more

Eric, Thank you so much for sticking with me on this.  I've uploaded...yes...yet another screen shot (...Part3).  I am having difficulty...big surprise...with creating a spreadsheet...at least I think so since when I attempt to reference the spreadsheet in Google Sheets Add a Row...it doesn't see it.  I am assuming somewhere in the spreadsheet there is a problem but I can't see it.  Can you? Thanks. Jeff ... View more

Hello Brandon, I'm attempting to perform the same function as Rudy but having difficulty configuring Google Sheets.  My module workflow is the following:  Survey123 (Watch Survey) to a Router which branches off to Email (Send an Email) and Google Sheets (Add a Row).  My ultimate goal would be to have an email notification sent, for not only alerting my users to a new survey posting, but also based on reaching a date listed within my Survey123 form.  Folks have suggested using the Google Sheets "Add a Row" in conjunction with "Search Rows" to achieve the desirable result.  I haven't gotten to the "Search Rows" yet...I am still stuck on how to configure Google Sheets "Add a Row" to work.  Specifically, what to select for Spreadsheet and Sheet in the configuration window. Can you please assist?  Or, can you suggest something entirely different within Integromat that I could use as a module workflow to achieve the desired result? Thank you for your time. Jeff ... View more

Eric, I've expanded a bit beyond my earlier screen capture.  Please see "Battery Inventory New Part2" screen capture.  I am not quite sure what to apply for the "Spreadsheet" and "Sheet" sections for the Add a Row dialog box.  Can you possibly offer some suggestions?  Thanks Jeff ... View more

Eric, I've added another screen capture.  Is that the workflow you were indicating? Thanks. Jeff ... View more

Thanks, Eric. I will definitely try it out. As a "heads up"...I may touch base with you again if I have questions. Jeff ... View more

Eric,  I've attached a screen capture illustrating the current scenario I've created in Integromat that supplies an email notification based on a submitted/edited survey from Survey123. Would Google Sheets be integrated within this scenario or be a stand-alone scenario? Thanks. Jeff ... View more