Search the Community
Showing results for tags 'date'.
-
I have a table that has a few date fields in it. Each record has fields for 'Item Created Date', 'Estimated Ship Date', and 'Estimated Finish Date'. I need to have a single calendar that puts each of these dates (if there is a value in that field) and another fields value (for description) in the same calendar. For example. A record in this table with a Field:Description value of 'Oushak Rug' could have: Item Created Date: 05/01/15 Estimated Ship Date: 07/06/15 Estimated Finish Date: 09/03/15 I need the value 'Oushak Rug' to show up 3 times on the calendar, once for each date, a
-
I have several apps that include a datepicker on a datefield. These have been working fine, just click the button and choose a date. Now something has changed... I can open the datepicker but something seems to get in the way som i cannot choose a date. The workaround is to change the CSS som the datebox ends up way out to the left. It seems like if there is a textfield that extends beyond the datepickerbox the box does not work... Any Ideas?? My workaround sucks because a have many apps that i have to change.
-
Hello all, I am currently working on a search form (using a virtual field submission form) that has a dropdown menu to select from predefined reports. The way I would like this to function is that when the user selects an option (such as "Recent (Within the Last 10 Days)") an onchange function would change the search fields to the input needed to produce those results. I am fairly new to JavaScript, here is what I have been able to get: <SCRIPT LANGUAGE="JavaScript"> function ocPredefinedReports() { if (document.getElementById("cbParamVirtual8").value=='Recent (Within t
- 3 replies
-
- javascript
- onchange
-
(and 2 more)
Tagged with:
-
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)
-
Hi, I'm new to Caspio. I have a 9 date text fields with calendar picker. When user picks date for 1st field I need the subsequent 8 fields to populate with the 1st field's date + 1 business day. The result would be as follows: field 1 - 01/16/2015 SELECTED field 2 - 01/19/2015 AUTOPOPULATED field 3 - 01/20/2015 AUTOPOPULATED field 4 - 01/21/2015 AUTOPOPULATED field 5 - 01/22/2015 AUTOPOPULATED field 6 - 01/23/2015 AUTOPOPULATED field 7 - 01/26/2015 AUTOPOPULATED field 8 - 01/27/2015 AUTOPOPULATED field 9 - 01/28/2015 AUTOPOPULATED THEN SUBMIT* Any help, javascript and/o
- 3 replies
-
- date
- javascript
-
(and 1 more)
Tagged with:
-
I have a form that has a few scripts already running in it to control some fields where I need to format numbers as currency. I'm good to go on those and they are running fine - A great big thank you to those who are posting solutions here in the forums! - It's been a great help to me and I would not be able to do some of the great things I'm accomplishing without those wonderful individuals who post solutions and code here in the forums. But I now need to control 2 date fields. I have the calendar picker set up for each field, but was hoping for the "Start Date" field, I could someh
-
Hi everyone. I need to change the format of the pop-up selector in a datapage or even for the whole app. I have changed the localization of the date/time to the format I want 9/27/2014 when I click a date in a calendar pop-up. However, even though I have set the localization for this format, it adds a 0 in front of all the months that are one digit. No matter what I can not get the format to change on a calendar pop-up. Where do I change the calendar pop-up format to 9/27/2014 instead of 09/27/2014 (this is what it does) THANKS
-
Hi. I have a table holding two fields with dates I try to compare in java script. The first date is generated by caspio timestamp, and called "date_submitted", formatted like"05/15/2014 23:43:58" in the table. The second date,"Date_event_start", is a date submitted from a Caspio calendar, formatted like "05/30/2014" in the table. When i insert both dates in a HMTL block within Caspio they retur quite different. "date_submitted" returns: "05/15/2014 11:43:58 PM" and "Date_event_start" returns: "30.05.2014" Why does Caspio default output different date formats??? I
-
In my report page I want to show the expired records in red, the ones before today
-
Hello I have two fields in my submission form - date and day. The customer selects date (via calendar pop up text field). I need the day field to automatically be populated by the day of the week from the date input (so someone inputs 25/12/2013 and the day field automatically says 'Wednesday' or whatever). Currently, I'm tackling this in a very roundabout way, by passing a long date to a report data page and then using rules (if date contains 'Monday' then hide section 1 etc). This is laborious and requires the user to click again on a url link. There must be an easier way. Does
- 3 replies
-
- date
- day of the week
-
(and 2 more)
Tagged with:
-
Hello I'm a bit of a Caspio newbie and pretty unskilled (ok - very unskilled!) at Javascript. I have a couple of, hopefully small, issues that I assume I need some basic javascript to solve. I've tried adapting code that I've found elsewhere, but I don't really know what I'm doing:- 1.I have a field called 'maximum_people' and one called 'no_of_people'. I need to restrict the number of bookings received on a given date, so if I create a report datapage (filtering by date) I need to add up all the 'no_of_people' submissions, and then have the form stop if it >='maximum people'. I sup
- 7 replies
-
- date
- restrict submissions
-
(and 2 more)
Tagged with: