Search the Community
Showing results for tags 'formatting'.
-
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
-
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?
- 1 reply
-
- java script
- formatting
-
(and 1 more)
Tagged with:
-
Can Caspio Create Cell Shading Or Background Styles From Excel?
ETFIA posted a question in Styles and Localizations
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.
- 3 replies
-
- html datapage
- wysiwyg editor
-
(and 1 more)
Tagged with:
-
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.
-
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
- 1 reply
-
- javascript
- html
-
(and 3 more)
Tagged with:
-
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?
-
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?
- 7 replies
-
- phone
- javascript
-
(and 1 more)
Tagged with:
-
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?
- 4 replies
-
- virtual field
- parameters
-
(and 2 more)
Tagged with:
-
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.backgr
- 2 replies
-
- javascript
- formatting
-
(and 1 more)
Tagged with:
-
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.
-
Datetime Display - Date Only Or Date And Time
ezIQchad posted a question in Calculations and aggregations
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 prett- 3 replies
-
- format
- formatting
- (and 4 more)
-
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
- 1 reply
-
- Table Setup
- Datapage Setup
-
(and 1 more)
Tagged with:
-
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.
- 1 reply
-
- wordpress
- responsive
-
(and 5 more)
Tagged with: