wimtracking2

@ta33ik and @BCannon I was able to get Google Places API to autocomplete my address and parse the address details into the necessary fields in a Submit Datapage. By adding this code into an HTML Block. The field Address_String is where the user begins to type the address and selects the autopopulated address. Be sure to insert your own API and actually deploy the datapage onto your website (and that your url is listed with the API). It won't work properly if you are just previewing the form on a caspio URL. Good luck! <!-- Load Google Places API --> <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=InsertYourAPI&libraries=places"></script> <!-- Set autocomplete input for 'InsertRecordAddress_String' --> <script> document.addEventListener("DataPageReady", function() { var gpaInput = document.getElementById('InsertRecordAddress_String'); var autocomplete = new google.maps.places.Autocomplete(gpaInput); // Listener for when a place is selected autocomplete.addListener('place_changed', function() { var place = autocomplete.getPlace(); // Check if a place was actually selected if (place && place.geometry) { var addressComponents = place.address_components; var address = ''; var city = ''; var state = ''; var zipCode = ''; var country = ''; var county = ''; var latitude = place.geometry.location.lat(); var longitude = place.geometry.location.lng(); // Extracting specific address components for (var i = 0; i < addressComponents.length; i++) { var component = addressComponents[i]; if (component.types.includes('route') || component.types.includes('street_number')) { address += component.long_name + ' '; } else if (component.types.includes('locality')) { city = component.long_name; } else if (component.types.includes('administrative_area_level_1')) { state = component.short_name; } else if (component.types.includes('postal_code')) { zipCode = component.long_name; } else if (component.types.includes('country')) { country = component.long_name; } else if (component.types.includes('administrative_area_level_2')) { county = component.long_name; } } // Setting values in Caspio fields document.getElementById('InsertRecordAddress').value = address.trim(); document.getElementById('InsertRecordCity').value = city; document.getElementById('InsertRecordState').value = state; document.getElementById('InsertRecordZip').value = zipCode; document.getElementById('InsertRecordCountry').value = country; document.getElementById('InsertRecordPhysical_County').value = county; document.getElementById('InsertRecordLat').value = latitude; document.getElementById('InsertRecordLong').value = longitude; // You might need to adapt this to fit your specific data structure and field IDs } }); }); </script>

@Volomeister Yes, they are both List string datatype fields.

I have an update datapage that has two multi-select drop downs. See screen shot, dropdown A is highlighted in yellow and dropdown B is highlighted in blue. I can open dropdown A, and click on dropdown B, which then closes dropdown A. I would like to be able to keep dropdown A and dropdown B open at the same time and only close them both at the same time. Is there a way to do this?

@Volomeister Thank you. I was able to set up this workflow as you outlined. I have the datapage and triggered action working. The only hurdle is I ended up using a listbox, rather than a dropdown in the datapage. I would prefer to use a dropdown field, however I was not able to get the JavaScript (below) to work on a dropdown field. Do you have any suggestions? <SCRIPT LANGUAGE="JavaScript"> document.addEventListener('DataPageReady', assignMultiple) function assignMultiple() { document.querySelector('#InsertRecordMultiple_Site_IDs').setAttribute('multiple', true); } </SCRIPT> Triggered Action: For anyone interested in the triggered action used, see screenshot attached and link to post I referenced. I added TRIM to the field extracted from the comma delimited values.

I have three tables: tbl_sites (table with names and locations of sites) tbl_programs (table with name of programs) tbl_site_to_program (table of record ID associations made between the tbl_sites (site_ID) and tbl_programs (program_ID)) I currently create a submission to tbl_site_to_program by using a dropdown list of tbl_sites (site_ID) and by pulling in the tbl_programs (program_ID) as a parameter. This allows me to create one association into tbl_site_to_program at a time. However, I would like to be able to make many associations (submissions to tbl_site_to_program) at once based on multiple selections made using the dropdown list of tbl_sites (site_ID). Is there a way to select multiple records from the dropdown list of tbl_sites (site_ID) and create new records in tbl_site_to_program OR is there a way to use a grid style datapage to accomplish this? See image Site to program association to see the current datapage used (one site can currently be selected from the "Select from Existing Site List" dropdown). The Caspio user interface has a similar functionality using a grid style sheet. See attached image Caspio UI Screenshot.png. User can select multiple datapages at once and complete an action such as move all selected datapages to a new folder.

I have a search form with a tabular report displayed below the search on a webpage, Page 1. When user clicks update, they are taken to a new webpage, Page 2, that opens in a new tab. On Page 2, they can edit the details of the record and take other actions like make an association to this record. The user would then close the tab with Page 2 and return to the tab with Page 1 where their search results are presented in the tabular report. The data they entered on Page 2, however, is not displayed in the tabular report on Page 1 and if they refresh the webpage, their search filters are removed and they have to search again. I am looking for solutions such as: - Add a button that refreshes just the tabular report section of the datapage - Add a button that refreshes an individual record in the tabular report - Keep the search parameters upon refresh of the webpage

This worked, thank you @Volomeister.

@MayMusic How can this be altered to remove the tool tip code from the inline edit text/button within the table? See screenshots, I have added a font awesome icon to the Record Action and the code shows up in the tool tip. Ideally, I'd like to just remove the tool tip from this inline edit text/button. Thanks

Page 1 (screenshots included) allows the user to search records and the records are returned in a table below the search. The user can then click to update a record from the list and they go to Page 2. Page 2 is not a details page, it is it's own datapage. I want to have a link that sends the user back to Page 1 with the existing search parameters they previously entered. The user can also get to Page 1 through another link in the menu, but I do not want the search parameters to pass if the user uses the menu link, only if they use a back button specifically added to return the user back to the search results. What is the best way to accomplish this?

Hi @Jodie This was very helpful. I was able to improve the workflow using your suggestions of the virtual fields and triggered actions. Thank you for the help!

Hi @Jodie I have updated my question and the screenshot attached. There is one webpage in the screenshot and there are three datapages deployed. Datapage 1 = Form (Programs Table), Datapage 2 = Form (Assigning a Program to a Site) Datapage 3 = Report (Report of the Programs Assigned to a Site). I'd like to check the data behind Datapage 1 (Does Site or Patient Home not equal Patient Home) and if yes, check the data behind Datapage 3 (is there a Program to Site association) and if no, prompt the user to make an association.

Hello - I am looking for a way to improve the user experience on my app. I have two tables, Table 1 = Programs, Table 2 = Sites. A user is able to create a new record to the Programs table using a submission datapage. From there they are directed to the Programs webpage. On the Programs webpage the user can edit the Program record using a form datapage and they can assign a Site (from the Sites Table) to that Program. This is done with a submission datapage that takes the Program ID and Site ID and stores them in a third table. If the Site they would like to assign to the Program does not exist, they can add a new Site to the Site Table and then assign the Site to the Program. See screenshot 1 of current set up when there is no Site to Program association (top) and (bottom) when there is a Site to Program association. 1. I want to prompt the user to create the program to site association if in the Program record Site or Patient Home does not equal Patient Home AND if there is currently NO active site associated to the Program. The prompt would happen if the user tries to exit the webpage without an active Site association (or is there a better prompt option?). 2. Are there any suggestions on the flow/user experience regarding the assignment of a current Site versus Adding a New Site and then making that association. Is there a way to add a new Site and also assign it at the same time?

@Volomeister This is working perfectly, thank you! @Tubby Did you see this?

@BCannon Were you able to get this to work in your datapage? I'm working on implementing the solution from Google Places Autocomplete in Webflow Forms - Webflow, see you replaced the INPUT_ELEMENT_ID with document.getElementById("InsertRecordWork_Order_Address") but I am not having success. Wondering if you have any tips that helped you get to a functioning address autocomplete. Thanks!

I have a Multi-Select dropdown that has lots of options and is a String- Text field. I'd like to have a functionality wherein I can type a word, and it will search from the dropdown options or take the user to that option in the drop down list so they don't have to manually scroll through all the options to find it. This is a feature that is available in a standard text dropdown field. See screenshot. If the user opens the dropdown and types "ger" they are taken down in the list to "Geriatrics". Is this available? Thank you,