-
Content Count
464 -
Joined
-
Last visited
-
Days Won
49
Everything posted by Mathilda
-
generate coordinates on update
Mathilda replied to Mylene's topic in User JavaScript and CSS Discussions
Hi, I modified script from this article. Code for the header: <div id="cbwrapper"> Code for the footer: </div><script type='text/javascript'> var lat_id = 'EditRecordlat'; var lng_id = 'EditRecordlng'; var address_id = 'EditRecordAddress'; var city_id = 'EditRecordCity'; var state_id = 'EditRecordState'; var zip_id = 'EditRecordZip'; var wrapper_id = 'cbwrapper'; var msg1 = 'Please input a valid address'; if(typeof jQuery != 'undefined'){ var cb_geocoder = cb_geocoder = new google.maps.Geocoder(); $('#'+wrapper_id+' input[id=Mod0EditRecord]').click(funct -
Button To Copy Records into a new Table
Mathilda replied to rickin21's topic in User JavaScript and CSS Discussions
Hi, since we cannot create a button or link in grouping, you need to place the link in each record If you don't want to display value of calculated field, you could hide the calculated field using css, like in this post -
Hi Try adding <?php session_start(); ?> at the beginning of the "class-datapage-loader.php" file. Also, please remove any trailing spaces at the beginning of that file. You may find more details here
-
You may insert my script in the footer of the submission form <script> function hide() { var v_value = document.getElementsByName("InsertRecordFieldName")[0].value; if (v_value.length<1){ document.getElementById("Submit").style.display="none"; } else{ document.getElementById("Submit").style.display = "inline-block"; } } window.onload = hide; document.getElementsByName("InsertRecordFieldName")[0].onblur=hide; </script> Use your field name instead of: FieldName
-
As far as I remember MS plugin is not available for MS Word, it gets data only for Excel and Access. You may have a look at 3rd party apps in zapier, perhaps mail chimp provides needed pattern
-
autonumber field will be populated for every records, therefore you would need to use integer field instead. If triggers available for your plan, you can do that using triggered actions, if no - you could use java script. In case of creating java script function I would add a virtual field (drop-down, displaying values, gotten from the table in descending order - this will give you the most recent value) and incrementing a value if value in rego field = unreg You may find an example here
-
Button To Copy Records into a new Table
Mathilda replied to rickin21's topic in User JavaScript and CSS Discussions
You could get total value using sql query in a calculated field, then you may create a link (find an example here) and pass calculated value parameter in query string Hope that helps -
I have a solution for your case. You may find code below: <script>https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script> <script> function resizeIframe(obj) { obj.style.height = obj.contentWindow.document.body.scrollHeight + 'px'; } </script> <iframe src="URL_of the datapage" frameBorder="0" scrolling="no" width=100% onload="resizeIframe(this)">Sorry, but your browser does not support frames.</iframe> Don't forget to insert your URL instead of: URL_of the datapage
-
I modified a solution from this post for submission form. You may try using my script in the footer: <script> function validateEmail(email) { var email = document.getElementById("InsertRecordEmail_field").value; var splitted = email.match("^(.+)@thisdomainonly\.com$"); if (splitted == null) return false; if (splitted[1] != null) { var regexp_user = /^\"?[\w-_\.]*\"?$/; if (splitted[1].match(regexp_user) == null) return false; return true; } return false; } document.getElementById("caspioform").onsubmit=validateEmail; </scri
-
script Phone number scrpt
Mathilda replied to Alwayslost's topic in User JavaScript and CSS Discussions
You may find an example in this post. Hope that helps -
You may execute function on form submit, like in this post
-
If "type of music" field is included in your datasource, you may use the following syntax: select count(user_id) from table_name where type_of_music=target.[@field:type_of_music] target.[@field:type_of_music] - this part refers to the field value on report Hope that helps
-
Hi, welcome to forum! I don't think that this can resolved in caspio account, you may have a look at this article. Hope that helps
- 6 replies
-
- squarespace
- deploy
-
(and 1 more)
Tagged with:
-
Hi, what is the purpose of updating that field? Can you describe a workflow? I suppose that you may need to have a separate datapage for this purpose
-
Hi I found a post which should be helpful. Hope that helps
-
Date+1 and Insert on Submission Form
Mathilda replied to lmooring's topic in User JavaScript and CSS Discussions
You can use formula field with dateadd function: DATEADD(dd, 1, [@field:end_date]) If you prefer JavaScript, have a look at this post, you just need to add 1 day instead of 1 month. -
deployment Deployment after page load
Mathilda replied to MikesBarto2002's question in API and Integration
I would hardcode deploy code in js file and load datapage in a specific node on a condition (when page is scrolled to a specific place) -
COnditionally display deploy codes
Mathilda replied to pgjacob's topic in User JavaScript and CSS Discussions
I would hide datapage is parameter is not equal to X. You may find an example below: <script type="text/javascript"> window.onload= function my_funct(){ var check='[@param]'; if (check != 'X'){ document.getElementById("caspioform").style.display = 'none'; } } </script> -
How to set dropdown field type to receive parameter
Mathilda replied to NeoInJS's question in Parameters
Only regular drop-down form element can receive a parameter on a submission form. What is the purpose of assigning a parameter to a cascading element? First, you may need to submit a parameter to your lookup table. Have a look at this post. -
Date Calculation in a submission form
Mathilda replied to NeoInJS's question in Calculations and aggregations
In this case, you may use java script only for displaying the value to a user. Depending on your requirements, you may execute function window.onload or 'onchange' of a specific field.- 4 replies
-
- date
- calculated fields
-
(and 1 more)
Tagged with:
-
In this case you may use java script. I created a simple example for you, you should paste script in the footer of the datapage: <script> window.onload = function myFunction() { var d = new Date(); var weekday = new Array(7); weekday[0] = "Sunday"; weekday[1] = "Monday"; weekday[2] = "Tuesday"; weekday[3] = "Wednesday"; weekday[4] = "Thursday"; weekday[5] = "Friday"; weekday[6] = "Saturday"; var n = weekday[d.getDay()]; document.getElementById("InsertRecordField_name").value = n; } </script> Enter name of your field instead of: Fi
-
As far as I remember app parameter doesn't have this flexibility. Depending on the type of the datapage you will be able to get current day of the week in calculated field: DATENAME ( dw , '[@cbTimestamp]')