• Content count

  • Joined

  • Last visited

  • Days Won

  1. Only display records older than specified time

    Wow ! this is what I was looking for! I want to filter records except showing the last 7 days. It works perfectly. Set a formula field and add 7 days to the date submitted and then filter using Before Now and records that are 7 days new wont show up because their date is actually stamped ahead.
  2. Customize a submission form

    HI I think I have an answer for this! Create 1 submission form and disable and hide fields based on the top field(in your case Client Broker Management). If you wanted this inputed on 3 different tables based on what was chosen but collected on 1 form you would need 2 extra hidden forms that could auto submit and receive data from the 1st form!.. Just make the Broker and Management Fields Virtual Fields and Pass them to Form 2 which could be Broker. On form 2 the Broker fields are real fields which the Management fields are Virtual which those would pass to the last form. The last form once submitted could be a URL that says Submission Accepted. IF you want the last form to confirm everything submitted on the 1st form, you would have to pass all fields into Virtual fields as well so that they would render on the last page. Hope this helps
  3. HI I am not a java script person but I thought Id add my 2cents If you want to combine 2 fields in to one, you can do it without Java script (sort of). In my app a user has to select a gym they go to via a drop down of preselected data in field1. If they select other in field 1 it is disabled, and they enter a gym in field 1. These 2 fields will be passed to my page 2 sign up form in a hidden field that will receive both (but one will be blank because it is disabled) To use your situation: First take the 2 fields and pass them to a single record update page on page 2 for example; when you submit the form where it says destination after submission, select go to a new page (page2) - Page 2 will have the single record update that will receive the 2 parameters into 1 field pass .../[@field:First_Name] [@field:Last_Name] to page 2 (space between the 2 fields) On Page 2, Make Full Name hidden and set to receive External Field; in this case [@field:Full_Name] Now the second page will receive the first and last name as 1 item! You would still have to submit page 2 and you could hide this (using Java) and then set page 2 to go to the page that page 1 was supposed to go to. Hope this helps
  4. disable "UPDATE" button on Report Details page

    I had the same stupid issue. Just set the button in CSS to display:none!important However, I guess someone could inspect the element and undo that.. You could also make the button a go back button so that when the record is "updated" data page returns somewhere You could also make your details page a regular List view page which would not have the button. Hope this helps
  5. No File Chosen

    See my post similar to this where you can create your own button or make the opacity 0
  6. Agree, I hate the standard browser button. I like my own graphics I'm kinda a novice but try this, it worked for me: In your file field, enable the label to be shown on top. (This is where your going to put an image of uploading a photo which will cover the browse button.) <img id="browsepng" style="position:absolute;width:100px; height:100px;margin-top:5px;" src=""></img> Make your file field height large so that the image will fit (replace the image in the src with your image). This will cover the browse button in most browsers with your image, but not all. Also, I ID it because it does appear slightly in a different place in each browser so it has to be CSS. When a user hits the image, the file field will still try to upload a file and thats good. Now, set the opacity of the file field to zero (if you do display:none it may not show the label). My tag is #InsertRecordpic1 but yours could be #InsertRecordYOURFIELDNAME. Now when a user submits a pic, they will just see your image. But wait, the actually selected wont show because you opacitied it at zero. Now insert this code from this forum member which shows you the image just uploaded right below the field. Hope this helps
  7. Wow May Music...this worked ! I have been looking for this code FOREVER so that people can see their photo, even asking my friend who claims to know computers but told me he needed to know the language of the Caspio interface or whatever ..and I said no I'm sure its a basic Java Do you know what code I can use to compress the photo in the file field so that it uploads faster. I know Caspio has image resizer but if it resizes the image to 100px wide, the original can still be a huge file.
  8. I tried it and it didnt work. I changed the value to [@authfield:Username]. I also tried it with "Bad Name". They should really make this more easy. Logiforms has a hide Submit feature
  9. How do i write the code if the field is a name that I don't want submitted? Where do I put the script..(im not good at JS). I tried something like this if (parseFloat(document.getElementById("InsertRecordMyTestField").value)="BadName") disabled = true; do I use quotes for the text i want to restrict or apostrophes?
  10. Geo Coordinates From Phone

    Thanks GoCubbies for the heads up about this code not working on an insecure server anymore. I was testing out a new app using one of my update record forms which contains this code and I thought I "broke" the page because it wasnt capturing the Lat & Long anymore on Chrome. I direct users now the https Caspio page directly instead of my URL and it works! The only drawback is that the browser now prompts you to accept sharing your location from Caspio rather than your own URL!
  11. How do i filter records that are stamped for the last hour, minute? There's filtering for today, month, etc but no filter for records entered in the last hour unless I'm missing something??
  12. Any Ideas on (2 things): Is there a way to mask the email field for data page viewers to contact other members? For example, I'm on a social networking site made with Caspio and I don't want my e-mail address shown to the public- rather a "fake" address shown on a report page where a user that clicked contact me at "fake" email address that sends an email to Caspio and then forwards to the recipient. Any ideas on how this could be executed? I guess one could make a data page that accepts comments that links those comments to a target User ID. And that Target User ID could enter a password to see his comments (like a mailbox page)