alexm72

The real answer is Caspio should just create a distinct field button of some sort like they do in dropdowns when you can check Distinct Options and Im sure it would take them 20 minutes to do and everyone could use this!

Hi folks I wanted to share a cool code with everyone when you press the Submit Button on a Form. Well when you press the Submit Button with a file in it to load and there is a unique field in it (such as a Username for a registration form), there's a bit of a delay until you ge to the confirmation screen. This confuses the Submitter and may press the button again - which results in an error because now the form is submitted twice but the same username was alreast submitted on the first form Anyway you want a Loading screen to pop up. Caspio should have this simple feature for a "low coding" platform! In your header drop this code (#Submit is the submit button - on an update form its something different, #processing is the name of my div that will show the processing window after submission): <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script> <script> $(document).ready(function(){ $("#Submit").click(function(){ $("#processing").css({"display":"table"}); }); }); </script> In the Footer drop this: <div id="processing" style="display:none;background-color:rgba(222,200,70,0.9);height:100vh;width:100vw;position:fixed;top:0;"><br/><br/><span style="display:table;height:75wh;margin:auto;top:0;bottom:0;left:0;right:0;">Processing, Please Wait....<br/><br/><img style="display:table;margin:auto;" src="http://skquares.com/processing.gif"></img><br/<br/></span></div> ------- thats it! Notice the display is set to none because you dont want to show the window until the Submit button is pressed via the Jquery script. Notice the height and width are set to the size of the screen with a position of fixed, top:0 - so that the whole screen is covered but you can shrink it by putting less width and height; background is my own color choice but you can change that - note leave the opacity not at 100% but I have it at 90%(0.9) so that the user can still see the form a little. Also, http://skquares.com/processing.gif is where i store MY image so you have to change it to where you image is hosted (but you could use mine i guess). Ok I hope this helps!

I think what your doing can be done!...Just use an single update record form and have users sign in and when they do they wont see the form which will auto submit and redirects to a report page; I forgot to tell you to give the autosubmit a 1 or 2 second delay or it "goes to fast" for it to work.. Yes i could not believe that there is no way in Caspio to see users logged in and a lot of things do need to be worked on that are instantly there on some other platforms (logiforms). I tried some others but came back here because of the unlimited data transfer, members, and the image shrink feature, and now they have SMS and triggers (didnt have 2 years ago). But yes Caspio has to be worked around like: Why cant a Unique field auto check the server when a user is filling out the field to see if the Name is available instead of going thru the whole form process only to get an error; the Delete confirmation Box is annoying (id like to have the user just hit a delete button and thats it without that stupid pop up box thats not even mobile ready; lot of cut and pasting in this platform (it should be features there already).

HI I had the same issue when I created my app. Here's what I did and I hope it helps: 1. Create a Timestamp field in your table that is checked Stamp on update; call it Logged_in_time (or whatever) 2. Have all users log in to a Single Record update form instead of a report page. A logged out user will see the login form first 2. Place a hidden field that updates something in the auth users record (perhaps Latitude /Longitude, or a yes/no field that is titled Logged_in) 3. When the users logs into the form, hide the form instead with a display:none, and place code at the bottome of the form to autosubmit; theres help in the formun on that. When it autosubmits, it updates the record, and it you can direct it to your report page. 4. Your Timestamp is now updated and it "appears" that the user is logged in. Sort your data by Timestamp date z to a so the newest "logged in" members will appear first. 5. I didnt care if the user logged out because I sorted my data showing newest people first, but You could create a yes/no update form that when the "sign out" it actually updates this field to no, and sort your data by Logged_in yes/no field instead. What do you think?

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.

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

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 .../mywebsite.com?Full_Name=[@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

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

See my post similar to this where you can create your own button or make the opacity 0

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="http://patsi.net/addphoto.png"></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

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.

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

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?

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!

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??

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)