jbloome

Looked around many Caspio forum posts and just wanted to post the latest for calculating Age from a Birth Date Text Field. Set up a text field in your table called: Birth_Date. In the datapage text field for Birth_Date select Calendar Pop-Up. In your details page add underneath the Birth_Date field, a calculated field with the code: FLOOR(DATEDIFF(DAY, [@field:Date_of_Birth1], SysDateTime()) / 365.25). This updates other Caspio previous posts that didn't properly calculate the age.

Hello, I thought I would share a solution for matching the HTML block background color where I inserted a button on the Report Details page to match the rest of my datapage color. Insert your html block where you want it and on the same page add this code in the header (and change the color code to your preference). <style> .cbHTMLBlockContainer { background: #52B552!important; } </style>

Hello, I thought I would share a solution for matching the HTML block background color where I inserted a button on the Report Details page to match the rest of my datapage color. Insert your html block where you want it and on the same page add this code in the header (and change the color code to your preference). <style> .cbHTMLBlockContainer { background: #52B552!important; } </style>

I had a problem with Map Mashup and correcting deploying the map icons in different colors based on criteria. I am using URL deployment so the instructions would differ based on your deployment method. Caspio support helped me resolve the issue by 1) disabling Ajax loading (you first have to unclick responsible on the Data Page Data Source Page ) and 2) use a Search Result on two separate pages (not on the same search page) and 3) putting the initial code snippet in the Header for the Results Page (not the Search Page). Now the map icons display correcting.

I think I found an elegant solution. I found a free Google Sheets Extension Called Geocode by Awesome where I can download my addresses to Excel, geocode them with the extension and then reupload them back into my caspio database with the geocoding.

Hello, I've successfully used the Caspio script: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/tech-tip-generating-geolocation-coordinates-from-web-form-submissions/ andhttps://howto.caspio.com/tech-tips-and-articles/tech-parameters/results-and-details-on-two-separate-web-pages/ to geolocate an existing record with an address by using a tabular report with a html block to pass a variable (Home_ID) to a reports detail page. The scripts work great but what I am trying to figure out is how to automate the process to update all of my records with the geolocation (I have more than 7000 entries) without having to manually pass each record through the tabular report to the reports details page (so it can activate the geolocation script). Any ideas for a script to do this?

One correction: on #5: Put in the Search and Results Table the Datapage where you will install the Map Mashup code not from the table where the data will be coming (e.g. my Maps Datapage pulls data from my homes_table so I would select the Maps Datapage as the Search and Results Table).

Howdy All, My Google Maps finally work and after two days I have an answer to my question which you might find useful. 1) I don't use a webpage so my deployment method is URL in Caspio's servers. 2) Search for Google Cloud API console and sign up for a billed API account (I had a free account and didn't realize I had to have an API attached to a billed account). I think with the billed account the free Map View limit is 28,000 inquiries/month before incurring expenses. 3) Start a new project through the Google Console and get your API code for your billed account. 4) On your Google Cloud API account search the API library and Enable the API for Maps Javascript API and Geocoding. 5) On the map mashup select the search and results table from where you are pulling data not the datapage where you might have the map mashup (e.g. my maps search datapage pulls data from my homes_table, in this case I would choose the homes_search and results datapage pulling from the homes_tbl not the maps search and results datapage). 6) Make sure you add your own customized field (e.g. in addition to city, state, zip my Address field is called Address1 and I had to add this field to generate the proper code snippets which included Address1 not Address which is the default). 7) For the map mashup the first code snippet "before the webpage deployment" goes into a header for the Configure Results Page Field. 8) The 2nd code snippet goes in a HTML block(make sure that it is at the bottom with no other fields below it) on the Configure Results Page. 9) The 3rd code snippet goes in a HTML block (make sure that it is at the bottom with no other fields below it) on the Configure Details Page. 10) On your Datapage Data Source page uncheck Responsive, go to Your Results Page and uncheck all the editing options, go back to the Datapage Data Source and check disable AJAX loading. That should work!

Hello, I've followed all the instructions for the Map Mashup Deployment but am stuck how how embed the Map Mashup code in the datapage above any webpage deployment code. I am using caspio servers to host my site and am not embedding it on any website. When I go to the deployment code I see no way to paste the required Map Mashup code. Please advise.

Thank you!

Thank you! Also, any idea how to implement the same script when editing a record on the Details page?

I found a great script on Caspio for autoformatting a phone field. https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/format-phone-number-in-datapages/?_ga=2.155873723.1217058336.1637018735-176705749.1637018735 and I was wondering if someone could help me with the language for adding more than one field for the var field (e.g. = "InsertRecordBest_Telephone and InsertRecordCell_Telephone) on the same datapage without me having to repeat the script 4 or 5 times which exceeds the HTML character limit for datapage submission forms.