logistics

Hello, I have a submission form that requests users to select a value in a drop-down. I would like to use the selected value to look up an email address, based on this value, in a different table, and populate a virtual field with that email address. I would then like to use the value in that virtual field to send a submission notification. How can I achieve this? I cannot see how to load a parameter from another table based on the value of a field. Any help would be much appreciated. Thanks, Julien

Hello, I now understand how the syntax works. Thanks for your help, Julien

Hi Mathilda, I have managed to sort my issue out! I was using a radio choice field, hence why it wasn't working as my reference was not correct. It's now fully working. Thanks for your help with this! Julien

Hi Mathilda, I followed your instructions, but sadly I cannot get it to work. I can get this error message in the debugger: Unable to set property 'onchange' of undefined or null reference My virtual field is called Virtual1, my email field is called Email_address and the trigger field is called Approved_by_CFA. I inserted this scrip in the footer of the details page, but nothing happens if I update the 'Approved_by_CFA' field: <SCRIPT LANGUAGE="JavaScript"> function insert() { var x= document.getElementById("EditRecordEmail_address").value; document.getElementById("cbParamVirtual1").value = x; } document.getElementById("EditRecordApproved_by_CFA").onchange=insert; </SCRIPT> Thanks again for your help. Julien

Hi there, Yes, I put the script in the footer of the details page. I'm sorry to be a pain, but could you tell me what is wrong with the syntax? I had read the post you mentioned, and that formed the basis of the scrip I wrote, in conjunction with this post. I have very little knowledge of Javascript, so I'm not sure where I went wrong... Many thanks, Julien

Thanks Mathilda, I'll give this a try! Much appreciated

Hello, how would I go about getting the script to run only if a field has a specific value? I've tried this, but it doesn't work: <script> var checkvalue; checkvalue=document.getElementById("Approved_by_CFA").value; if (checkvalue == "Yes"){ function hide() { document.getElementById("Mod0EditRecord").style.visibility = 'hidden'; } } </script> I've also tried this <script> var checkvalue; checkvalue=document.getElementById("Approved_by_CFA").value; if (checkvalue == "Yes"){ document.getElementById("Mod0EditRecord").style.visibility = 'hidden'; } </script> Any help would be appreciated. Thanks, Julien

Hello, I have a datapage set to send an email to the user when their record is updated. However, the email is sent regardless of which field is updated, and regardless of how many times it is updated. Is there a way to either: Send the email only when a SPECIFIC field is updated on the profile? If so, how? (preferred option) Only allow the email to be sent once? If so how? Many thanks in advance for your help. Julien

Thank you so much! That did the trick

Hi, Outer box I have an online form which has a transparent background, and not border on the outer box. However, in Chrome and Internet Explorer, there seems to be a 'shadow' around the box, but not in Internet Explorer. http://surveys.tmgsupport.co.uk/FAgirlsfootballweek/form2? Is there a way to remove this? Space below outer box On the same form, I have added a line <hr> as I can't add it below the submit button within the Caspio form, as far as I can see. However, there is a big space between the bottom of the Caspio outer, and the line. But in my HTML code, the line is directly beneath the caspio form tag. Any idea how I can remove this? Thanks in advance, Julien

Thank you sooooo much Matilda! That solved it! Massive headache now resolved thanks to your help! Julien

Hi Matilda, Thank you for your help. I followed your instructions but could not quite work out what you meant! I am quite unskilled when it comes to html... The URL to the page is www.fagirlsfootballweek.com and you need to click on 'Complete the survey' button to get to the page in question, where the caspio form is located. The frame around the caspio form renders differently if you are in Firefox, IE 11, or Chrome. I really appreciate you getting back to me. Thanks, Julien

Just to add to my previous post, it seems it's Chrome and Firefox that add another white frame.IE renders the borders properly. Is there a way to avoid this? Thank you Julien

Hello, I have a data submission form embedded in a website. The form has a white border around it. I have set the outer border to none, but still there is this white border. I don't seem to be able to control any of it: thickness, margin between text and border etc... Does anyone know how to control it? Thanks, Julien

Hello MayMusic, Thank you so much for this. Excuse my ignorance, but where should I put this code? In a HTML block, or in the header/footer? Do I need to disable the HTML editor? Thanks again, Julien

Hello all, I am in the middle of creating a submission form. It will have two dates: a start date and end date, both selected from a calendar. The start date is compulsory. The end date is not compulsory. When the user inputs the start date, on clicking out of the field, I need the form to check if the date is both greater to or equal to 25 April 2016, AND less than or equal to 01 May 2016. If it is incorrect, I need a message to be displayed indicating the error, and stopping the user from moving on. If the user decides to input an end date, on clicking out of the field, I need the form to check if the date is both greater to or equal to the start date, AND less than or equal to 01 May 2016. If it is incorrect, I need a message to be displayed indicating the error, and stopping the user from moving on. How can I achieve this? Thanks in advance, Julien

Hi everyone, I have a search and report form which I have published to a website for a client. I have purchased the white label. On the search results page, I have a logout link and a download data link. 1) Is there a way for the logout link to show in the action bar at the top, where the 'Download Data' link is, instead of having to put it in the header? 2) When I hover over the logout link or the download data link, the URL shows as https://eu1.caspio.com/xxxxx. I would prefer for this not to mention caspio, as this is customer facing. Is there a way to do this? 3) When I download data, it prompts me to accept to download from eu1.caspio.com. Same as above: is there a way to not show this? Thank you, Julien

Hello, I am trying to create an order submission process. I have two tables: an order delivery details table, and and order details table. The reason for this is that there will be only one order number per order, but potentially several items in each order. Then the orders will need to be imported in our warehouse management system, meaning I will require one line per item per order. So the order details table only has the following fields: order ID; Item No; Quantity required The process I am trying to achieve is as follows (i have indicated between brackets what I have managed to achieve): 1) User indicate the delivery details on the first data form (DONE) 2) The order number is generated automatically (DONE) 3) Change the 'Submit' button to a 'Next' button 4) On clicking the button, take to new datapage to indicate order details (DONE) 5) Order number is transfered to new page and hidden (DONE) 6) User selects an item to order from a drop-down (DONE) 7) User indicates the quantity required (DONE) 8) User can decide to add a new item to the order, i.e. create a new item entry on the same form, and then indicate the quantity required 9) User needs to be able to repeat process 8) undefinitely, i.e. keep adding items to the order 10) User submits order (DONE) 11) An auto email is sent alerting of a new order (DONE) 12) user is taken back to the 'delivery details' data page to start a new order if necessary (DONE) I would appreciate some help to achieve this if possible. If a simpler solution exists, I am more than happy to hear suggestions! Many thanks Julien