|
POST
|
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
03-12-2020
09:25 AM
|
0
|
2
|
5564
|
|
POST
|
Hello, I have a "select one [list_name]" question in my Survey123 Connect form. In addition, I have the appearance for this question set to "minimal" which provides a nice drop-down menu from which my field crews can select one from a list of combinations. Is it also possible to modify this same question to provide a user with the ability to "type in" a value that is not included on the list? Thank you in advance. Jeff
... View more
03-12-2020
08:43 AM
|
0
|
4
|
5661
|
|
POST
|
Thank you, James. That's exactly what I needed. Much appreciated! Jeff
... View more
02-28-2020
11:00 AM
|
0
|
0
|
1775
|
|
POST
|
Hello, I've created a form using Survey123 Connect that features a date entry (as type) with a default of today()...for example it would populate the form with Thursday, February 27, 2020. Today's date. As an fyi...I added a new row just below this one (text as type) to reformat this date...for example the new date format is illustrated as 02/27/2020. In using Google Sheets in tandem with Integromat it is necessary that the date be represented as such or you get a very strange entry. Anyway... Further down in my sheet I have another date entry. I would like to take today's date and automatically populate this entry with a date 1 year out from today. The auto-populate entry for that date would then read 02/27/2021. Can this be done? Thanks. Jeff
... View more
02-27-2020
09:21 AM
|
0
|
3
|
1865
|
|
POST
|
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
02-25-2020
10:16 AM
|
1
|
2
|
3302
|
|
POST
|
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
02-25-2020
09:57 AM
|
0
|
4
|
3302
|
|
POST
|
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
02-25-2020
05:02 AM
|
0
|
6
|
3302
|
|
POST
|
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
02-14-2020
11:37 AM
|
0
|
0
|
4752
|
|
POST
|
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
02-14-2020
10:24 AM
|
0
|
0
|
3302
|
|
POST
|
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
02-14-2020
08:28 AM
|
0
|
2
|
4752
|
|
POST
|
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
02-14-2020
07:43 AM
|
0
|
9
|
3302
|
|
POST
|
Eric, I've added another screen capture. Is that the workflow you were indicating? Thanks. Jeff
... View more
02-14-2020
04:47 AM
|
0
|
0
|
3302
|
|
POST
|
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
02-14-2020
04:39 AM
|
0
|
0
|
3463
|
|
POST
|
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
02-14-2020
04:25 AM
|
0
|
13
|
3463
|
| Title | Kudos | Posted |
|---|---|---|
| 2 | 10-22-2020 09:17 AM | |
| 1 | 06-04-2020 03:46 AM | |
| 1 | 02-25-2020 10:16 AM | |
| 1 | 12-31-2019 03:49 AM | |
| 1 | 01-17-2019 07:30 AM |
| Online Status |
Offline
|
| Date Last Visited |
10-02-2023
08:46 AM
|