Jump to content


  • Posts

  • Joined

  • Last visited

GLENNSTER's Achievements


Newbie (1/14)



  1. Bahar I think I love you. I could even give you a kiss (only on the cheek and still in a masculine way). Works perfectly now. Thank you for your help (and you too Mitch) Glenn
  2. Thanks again Had a look but they were already in the correct case "Date". I'll have another play about tomorrow if I can get back on. Thanks Glenn
  3. Thanks for trying Hollberg. Either it doesn't like the code or it doesn't like something I am doing. I entered the code below into the footer section - Stamp = new Date(); var v_TimeStamp; v_TimeStamp=('' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getFullYear(); document.forms[0].UpdateDate.value=v_TimeStamp.toDateString(); but no date is being recorded in my table. I am using a text field as my form element for my date. Ideally I would like this to be hidden but I am using text field at the minute to try and get the date format sorted. Thanks again for the effort. Glenn
  4. Hi I was hoping someone could help me with creating some javascript. I have no knowledge of it whatsoever but it appears to be the only solution to my problem without using a pop up calendar (which seems to take forever on my pc to come up). I want a timestamp to be put against all my submissions, but I only want DD/MM/YY recorded, and not DD/MM/YY HH:MM as is currently the set up in caspio. I wish to sort my results by day, but at the minute if I do a sort based on the current timestamp they will sort by day by hour by minute. I want my results to show the best price per day (eg Monday) as opposed to by minute the data was entered. I have tried to amend the sample javascript given in the tutorial but I am not having much success. Can anyone give me a helping hand? This was my last attempt (please don't laugh):- (my timestamp field is called "date", and it is an update datapage) //(1) Declaration and initialization Stamp = new Date(); var v_TimeStamp; //(2) Construct the value of the v_TimeStamp variable in the format mm/dd/yyyy v_TimeStamp=('' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getFullYear(); //(3) Field name - Date is referred with a prefix - EditRecord document.forms[0].UpdateDate.value=v_TimeStamp; Any help is greatly appreciated. Thanks Glenn
  5. Hi Hoping someone could maybe generate some more options for me. I have no money to spend on this project I am doing so getting a solution developed isn't an option. This is my conversation with the helpdesk and hopefully it details what I am after Thanks Glenn Visitor] Hoping someone could help me out [Visitor] I have a datapage at the following url [Visitor] http://b2.caspio.com/dp.asp?AppKey=e2b4 ... 5h7d0d1i0i [Visitor] the towns that the suppliers provide oil in are listed [Visitor] some suppliers only supply one town eg Armagh on its own [Visitor] or others supply multiple towns eg Bangor, Comber [Visitor] or Newtownards, Bangor [Visitor] how can i get the DP to present so that only single towns are listed [Caspio Support] I see. [Visitor] eg list armagh bangor Comber Newtownards [Caspio Support] You would need to create a separate table just for the purpose of populating those list box [Visitor] but if they supply multiple areas choosing Bangor will list suppliers who supply bangor in isolation but also as part of their other towns [Visitor] but i only want users to be able to select towns for which i currently have a price [Visitor] this current table is being populated by suppliers for which i have received a price update in the last week [Visitor] i have 100 suppliers listed but maybe only have prices for 10 of them [Visitor] i don't want users to be able to select towns for which i have no current supplier details [Visitor] therefore - only list towns for which i currently have an up to date price eg a price in the last week [Caspio Support] I see. As I understand the requirement, only list town IF there's data in the price field, correct? [Visitor] thats it [Visitor] i am currently basing this data on a view which is derived based on prices updated in the last week [Visitor] if i update a supplier that operates in belfast, then they will be added to this list also [Caspio Support] This requirement will require custom programming. Perhaps a \"if statement\" Javascript.
  • Create New...