Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

654 profile views

scribblemilk's Achievements


Newbie (1/14)



  1. Does anyone know how by using media queries i can change a form element from a listbox to a drop down? I want to do so as part of my responsive design, so when the max-width hits 600px my field "ExOrder" changes. Presumably i'd need a bit of javascript combined with a media-query?
  2. My SQL is simply that a one liner: SELECT DATENAME(dw,'[@Date]') 'Date' is a passed parameter and I simply want to reformat into into a day of the week, I have a localisation of English (UK) to allow for EU format date entry much like your example. Your example seems to work for the dates you suggest but not others (no records) is returned. I've tried the below but I still get a ERROR in FORMULA message, am I missing something? SELECT DATENAME(dw, CAST('[@Date]' AS DATETIME))
  3. I've tried the above but i still get an error in formula, i'm trying to take a date (Uk +EU Format) and turn it into a day of the week, if the date is above 12 (16/09/2016) I get an error in formula, below twelve works, so this seems to be an issue with EU to US date format conversion. Normally this would be resolved via changing the setting something like: SET DATEFORMAT DMY or SET LANGUAGE BRITISH But these don't work either any other ideas?
  4. Has anyone come across a way of copying child records from one table to another? I have need to on mass copy a number of stock records across to an order table and then be able to delete the orders individually as and when required. I can't however add the stock records to the order table individually (on average the number of records that need copying could be from 5 or 6 to 30ish), they would be copied over based on their parent record ID. This should be a standard feature but I have the horrible feeling it may require professional services and API calls.
  5. Hi Guys, Does anyone know how to change the standard Responsive design code (below) for gallery pages so that on trigger the number of columns is reduced not to one column (image) but two? I currently have a gallery page set up with three columns (images) i've wrapped a div round them and set it to width: 100%; so that the images adjust naturally as the screen size reduces, however once the @media clause kicks in the gallery reverts to one image at 100% and that is too big, i'd prefer the columns to reduce to 2 from 3 as set in the datapage. <!-- Responsive Code Begin --> <style> @media (max-width: 768px) { #gallery-single * { -webkit-box-sizing: border-box; -moz-box-sizing: border-box; box-sizing: border-box; } #gallery-single table[id^="PageActionsCtnr"] { border-spacing: 0px !important; border-collapse: separate !important; } #gallery-single table[id^="PageActionsCtnr"] td { display: block; width: auto!important; float: left; text-align: left; padding: 1px !important; } #gallery-single table[id^="PageActionsCtnr"] td div { text-align: left !important; } #gallery-single table[data-cb-name^="cbTable"] { border-spacing: 0px !important; border-collapse: collapse !important; margin-bottom: 7px; } #gallery-single table[data-cb-name^="cbTable"] td { display: block; width: 100% !important; float: left; text-align: left; margin-top: 10px; } #gallery-single table[data-cb-name^="cbTable"] td div { text-align: left !important; } #gallery-single table[data-cb-name^="cbTable"] td > div > div[name^="RACtnr"], #gallery-single table[data-cb-name^="cbTable"] td > div > div[name^="RACtnr"]:hover { vertical-align: middle !important; white-space: normal !important; background: transparent !important; overflow: hidden !important; display: inline-block !important; padding: 0px !important; margin: -6px 12px 8px 12px !important; line-height: 0px; position: static !important; width: auto !important; opacity: 1.0 !important; } } </style> <div id="gallery-single"> <!-- Responsive Code End --> Any help will be appreciated.
  6. Hi Jan, Is it possible to use javascript to filter on the last record entered (potentially via a timestamp), using the same principle of using a search page you have above? I have users submitting multiple records and I need to be able to automatically select the last record submitted to edit, is this possible? Regards Jason
  7. What i've just realised after going down the deleting a record via the details page route is of course Caspio pops up its own "are you sure you want to delete this record" Message, which is a bit overkill after turning the details datapage into a similar message, is there a way of altering a autosubmit script like the below that will 'auto delete' the details datapage? <script type="text/javascript"> setTimeout('document.forms[3].submit()',1000); </script>
  8. So the only work around I can see on this is to remove the inline delete, and enable details pages and use that to delete the record, it means that in the report instead of seeing a delete link you see a details link, however this can be replaced with a url icon of your choosing (external). I've used the details page as a "are you sure you want to delete this record?" message, however this isn't ideal as a message link that should really be a popup in my opinion as opposed to an inline message. If anyone else has a solution or a different workaround please share.
  9. I have a tabular report with with the inline delete function active, however I need to find a way to pass parameters to another datapage when a record is deleted, is there a way of doing this, passing parameters via a URl is simple enough I just can't think of how to do this once a record is deleted.
  10. Hi MayMusic, Is there a way of combining your solution above with the below topic to increment the Date value by one month where the Week calendar shows a cross over month? This is really stumping me any help greatly appreciated
  11. Hi Thanks so much for responding, your script appears to work in part, it works for the monthy adding links to only the days in that month and transfering the correct date for that month via the URL parameter method. However for the week calendar it only works for those links where the date in question is the first month, if you click a link for the second month in question the parameter sent sends the correct day of the month but not the correct month, going back to my example before if you are looking at a week covering 27th June to the 3rd July, and you click on 2nd of July the parameter sent is 2/6/2016 instead of 2/7/2016. For a weekly calender this is a problem as you do need to be able to process dates from two months in cross over weeks (see attached), in the monthly calendar it doesn't matter as you really only need to process dates in the month in question. I can't think of a way to identify cross over weeks and then just add a month to the parameter being sent for those dates <6 days into the month. Weekly Calendar Link Error.docx
  12. I need this too, i spoke to the support team they gave me an additional piece of code, that date sends through ok apart from if within the week you are looking at you are crossing over months, if that is the case the new month sends across the correct date but previous month, i.e. you are looking at a week covering 27th June to the 3rd July, you click on 2nd of July but the parameter sent is 2/6/2016 instead of 2/7/2016. The piece of code they added is ad follows: var monthArr = month.split(" ");if( monthArr.length > 2 ){month = monthArr[1] + " " + monthArr[2];} This is added in prior to the line below: month = month.replace(/January /gi,"1/Day/"); If anyone can get this to work for cross over weeks i'd be ever so greatful.
  13. I'm on the old Business plan at $249 for 1GB usage and 100 datapages, I like a lot of you are still in development and I regulary hit my usage limit, this is an extreme worry to me especially after I have spent thousands of dollars with caspio developing the site. Once the site is live it will take time to build a sufficient online community willing to pay for services, until they do the Performance plan with unlimited metering is simply too expensive at $799 and the Professional plan simply to small with 50 datapages, the 1GB usage upgrades cost $50 each which based on my calculations isn't cost effective as even paying users wouldn't cover that cost, likewise adding datapages to the Professional plan equally isn't cost effective. I would say the gap between the Professional and Performance pricing plans is simply too big for start ups, they could easily fail before they begin. With hosted cloud servers charging cents per 1GB of usage to be charged $50 per GB looks like opportunism to me and also short sighted as it will stunt growth. I have looked at ways of reducing usage, and there are reductions that I can make but they are all small reductions across the board and not enough in the long run, this is extremely disappointing and I have written to my Customer Success Manager to discuss, but the more of us that post about our concerns the better I would say.
  14. Hi i'm a newbie to scripting of any sorts and i have a problem i'm trying to replace a text field on a submission form based on the contents of another field (dropdown), with the contents of either of two other text fields. In essence if the contents of one field "Name_Type" equal "Muscle Group" then I want the field "Workout_Name" to equal the contents of the Muscle_Group_id field, likewise if the contents of field "Name_Type" equal "Workout_Type" then I want the field "Workout_Name" to equal the contents of the Workout_Type_id field. If neither is the case then I want the contents of the field "Workout_Name" to stay as it is. If had an attempt at scripting this which I placed in the footer of the submission datapage but without success, can anyone help? <SCRIPT LANGUAGE="JavaScript"> function replace () var name_type = document.getElementById("InsertRecordName_Type").value; var muscleG = document.getElementById("InsertRecordMuscle_Group_id").value; var workType = document.getElementById("InsertRecordWorkout_Type_id").value; var work_name = document.getElementById("InsertRecordWorkout_Name").value; if (name_type = "Muscle Group") { var Work_nameSubmit = muscleG; } else if (name_type = "Workout Type") { var Work_nameSubmit = workType; } else { var Work_nameSubmit = work_name; } document.getElementById("caspioform").onsubmit=replace; </SCRIPT>
  15. Hi Jan, I have a similar problem but one that the script you suggest would work for Mel wouldn't be suitable for me, in essence I have a Tabular Report with a number of columns that may or may not hold blank values (all the way down) way they are blank (all the way down) i'd like to hide the columns, I'm very new to Javascript so am unable to re-intrepret the script you posted, so am hoping for some help. I've added an aggregation row that counts non blank fields, that way any column that has a zero in the aggregation row is a column I want to hide, ideally I'd then want to hide the Aggregation row as it serves no purpose other than to identify the coulmns to hide. Any help i can get on this would be greatly appreciated. Jase
  • Create New...