Search the Community

I have the Javascript in our submission form to format the phone numbers to this format: (123) 456-7890, but sometime I need to add an extension to that. Is there a way to edit the Javascript so that I have the option to have it look like this: (123) 456-7890 x123. I don't want to have a separate column in the table to add an extension because they aren't always there and it will show up funny in the results tables. Any thoughts?

Hi everyone, Does anyone know how to render a calculated field as HTML? I tried outputting HTML tags inside calculated fields, but they display as plain text. Thanks in advance. -dspolyglot

When a user resets their password they get an email and a link in it. On using that link, a page comes up with just the password field and it's confirmation field. How can I add header / footer / branding / formatting to this page? Note that this is NOT the password reset page, but the page that fires after using the password reset page.

Hello, I have reviewed this page below, but I'm not sure if this is the right solution for me. I have a tabular report, and if there is a blank cell, I would like the background to highlight yellow. What is the best way to do that? See my screen shot below, where ideally, a header or footer code would make these fields jump out as bright yellow. Thank you!

I have a tabular datapage which essentially has the columns of Group, Name, Calc 1, Calc 2, Calc 3 and an Aggregation of Agg1 . The grouping is done by Group field and Agg 1 is shown at that level. Is there a way I can hide the entire grouping if Agg 1 does not meet a certain criteria? Likewise I would like to highlight specific rows in the expanded group based on values in one of the calc fields (varies depending on situation). In the example below, I would want to hide all of Group 1 (Group 1 row w/Agg1 as well as Name 1.1 and Name 1.2 rows) if Agg 1 is less than a designated threshold value. Is there a way to do this? Group 1 Agg 1 Name 1.1 Calc 1 Calc2 Calc 3 Name 1.2 Calc 1 Calc2 Calc 3 Group 2 Agg 1 Name 2.1 Calc 1 Calc2 Calc 3 Name 2.2 Calc 1 Calc2 Calc 3

How do I make my fields check and validate if the entered field is following a specified format? Like the email validation for example. I would like to have the same for fiscal ID's, etc. Any ideas?

Is it possible to configure a report view to display table rows of data that have background table shading either based on a set criteria of the cell data, or copying from an excel data source file? For example, green shaded cellsi in excel data source are green in Caspio output, or Caspio programming can set cell shading based on cell values? Ie. if value > 1 then green shading, otherwise no shading. Any guidance I appreciated, could not see this in the support files. Thanks, Anthony

Love the fact I can now edit an HTML page with a real window and not a tiny little box, BUT, why oh why must the editor transform my code? LEAVE. IT. ALONE. Anybody know of a setting I'm unaware of that sets the HTML editor into a "pure text mode" and leaves it alone, not editing it via the WYSIWYG tools? FRUSTRATED.

i have a primary key ID and several other fields: locatio, customername, crew, etc and a field called datecompleted. when the date completed field has a value I want to change all the other field to a color "red" any help would be appreciated. Isuck at coding.

X-axis values on my chart are repeating themselves. In the attached example, I have four courses, all of which are either 3 or 4 credit hour courses. I'd like to have values 1, 2, 3, 4 but instead I'm seeing each number multiple times. I should note that I am formatting the X-axis values to be number type, with a comma. I've experimented with taking away any formatting for the X-axis value but then I get decimal numbers (see attachment). Is there a way to just have a 1, 2, 3 and 4 in this example?

Hi, I've been separating the Search and Reports data pages and using the Virtual field set-up to pass parameters. I've done this a few times before and it works ok. This time, I require the filter on the search to use 'Date from' and 'Date to' parameters. However, I can't find a way of formatting the virtual field such that it passes the dates in UK format, as opposed to US. Without this, my search is showing up the wrong results, if any. Any thoughts?

Hi all, I'm quite new to Caspio and to digital stuff so please bare with me. I'm currently using the code below to format the 7th column of my table red, amber of green depending on the value in each cell. <SCRIPT LANGUAGE="JavaScript"> var elems = document.getElementsByTagName("td");for (var i=0, m=elems.length; i<m; i++) { if (elems[i].innerHTML=="Low") { elems[i].style.color="red";} if (elems[i].innerHTML=="Low") {elems[i].style.backgroundColor="lightpink"} if (elems[i].innerHTML=="Mid") { elems[i].style.color="orange";} if (elems[i].innerHTML=="Mid") {elems[i].style.backgroundColor="wheat"} if (elems[i].innerHTML=="High") { elems[i].style.color="green";} if (elems[i].innerHTML=="High") {elems[i].style.backgroundColor="LightGreen"}} </SCRIPT> However, whenever I sort the table results by clicking the column headings or try to move onto the next page of results (by using the arrow buttons at the bottom of the page) all of the formatting generated by the code above disappears. Currently this code is located in the footer. Does anyone know how to prevent this from happening?

Hello All!! I have a date field in which times are captured and stored some of the time. I am trying to figure out how to display the date in an HTML block in a dynamic way that displays time if present and not if empty. Please consider: Date1: 01/06/2015 Date2: 01/07/2015 17:45:00 Desired display: Date1: Jan 6th, 2015 Date2: Jan 7th, 2015 5:45PM Actual display Date1: Jan 6th, 2015 12:00AM Date2: Jan 7th, 2015 5:45PM When time is not captured it is not relevant and thus shouldn't be displayed. I have a workaround that involves a calculated field, but it's pretty clunky. Any ideas? Thanks

Alright, Completely amateur user here. No coding experience, no database management experience. But I want to create a game to play with my friends. Here is the thing; I want to setup a signup table. I did this, and I think it is OK to write to a USER database. Then I created another Table. With Column 1 being A through C. And A has an outcome of a or b. So does B and C. Same outcome. I want Caspio to spit out a datapage that goes to my table and Picks A (not a variable but a constant on the datapage) from my tables, and allows the user to pick a or b, AND assign a value to it. All this should be user specific. in other words, User #21 signs in, Sees a table Table Lists A, with options a or b (preferably dropdown), and a field for value Table Lists B, with options a or b (preferably dropdown), and a field for value Table Lists C, with options a or b (preferably dropdown), and a field for value So the user selects a for A and enters 25 Then selects a or b for B and enters 30 Then selects a or a for C and enters 12 This comes back to me as a table: User..... Variable... Selection.....Value #21 A a 25 #21 B b 30 #21 C a 12 I don't even know if this is doable in Caspio. What do you think?

I have a responsive template on my website, but one particular section on a phone overspills over the right edge. This happens on any page that has a form / text from a Caspio deployment. An example page is: https://beautyandfragrancejobs.com/sign-up-step-3/?Candidate_ID=29500 I'm talking about the 'What You Get Section' On my iPhone the 3rd picture in each column goes over the right hand side of the site. How do I fix this? Thank you in advance.