Jump to content

Accountability

Caspio Ninja
  • Posts

    78
  • Joined

  • Last visited

Everything posted by Accountability

  1. Also Tried (Unsuccessfully) Virtual1 is a Time Stamp field Used both: document.getElementById("InsertRecordcbParamVirtual1").onchange = concatenate; and document.getElementById("InsertRecordcbParamVirtual1").onkeyup = concatenate; <script> function concatenate() { var six = document.getElementById("InsertRecordcbParamVirtual1").value; var four = document.getElementById("InsertRecordEmployee_First_Name").value; var five = document.getElementById("InsertRecordEmployee_Last_Name").value; var one = document.getElementsByName("InsertRecordEmployee_HR_Section")[0].value; var two = document.getElementsByName("InsertRecordEmployee_Document_Origin")[0].value; var three = document.getElementsByName("InsertRecordEmployee_Document_Title")[0].value; var link = five + ", " + four +" - " +one + " - " + two + " - " + three +" - "+ six; document.getElementById("InsertRecordEmployee_Document_Link").value = link; } document.getElementById("InsertRecordcbParamVirtual1").onchange = concatenate; document.getElementsByName("InsertRecordEmployee_HR_Section")[0].onchange = concatenate; document.getElementsByName("InsertRecordEmployee_Document_Origin")[0].onchange = concatenate; document.getElementsByName("InsertRecordEmployee_Document_Title")[0].onchange = concatenate; document.getElementById("InsertRecordEmployee_First_Name").onkeyup = concatenate; document.getElementById("InsertRecordEmployee_Last_Name").onkeyup = concatenate; </script>
  2. I needed to make the concatenated string unique so I added a date Time stamp. Is it accessed differently ? Tried to figure it out on my own but no success. <script> function concatenate() { var six = document.getElementById("InsertRecordDate_Time_Stamp").value var four = document.getElementById("InsertRecordEmployee_First_Name").value; var five = document.getElementById("InsertRecordEmployee_Last_Name").value; var one = document.getElementsByName("InsertRecordEmployee_HR_Section")[0].value; var two = document.getElementsByName("InsertRecordEmployee_Document_Origin")[0].value; var three = document.getElementsByName("InsertRecordEmployee_Document_Title")[0].value; var link = five + ", " + four +" - " +one + " - " + two + " - " + three +" - "+ six; document.getElementById("InsertRecordEmployee_Document_Link").value = link; } document.getElementsByName("InsertRecordEmployee_HR_Section")[0].onchange = concatenate; document.getElementsByName("InsertRecordEmployee_Document_Origin")[0].onchange = concatenate; document.getElementsByName("InsertRecordEmployee_Document_Title")[0].onchange = concatenate; document.getElementById("InsertRecordEmployee_First_Name").onkeyup = concatenate; document.getElementById("InsertRecordEmployee_Last_Name").onkeyup = concatenate; document.getElementById("InsertRecordDate_Time_Stamp").onkeyup = concatenate; </script> Thanks again.
  3. You are the best. Worked just perfectly. I am sincerely grateful that someone of you obvious caliber took your valuable time to help.
  4. http://account-ability.net/test/ left the two field unhidden to make sure they were there
  5. They are going to be hidden received perameters. Tried onkeyup didn't work. You think it is because they are recieved from exteral perameters ?
  6. Trying to add two Text 255 fields to the above (which worked perfectly before I added the text fields. Added the following and it breaks the script. See anything out of order ? <script language="JavaScript"> function concatenate() { var four = document.getElementsById("InsertRecordEmployee_First_Name").value; var five = document.getElementsById("InsertRecordEmployee_Last_Name").value; var one = document.getElementsByName("InsertRecordEmployee_HR_Section")[0].value; var two = document.getElementsByName("InsertRecordEmployee_Document_Origin")[0].value; var three = document.getElementsByName("InsertRecordEmployee_Document_Title")[0].value; var link = one + " " + two + " " + three + " " + four+ " " + five document.getElementById("InsertRecordEmployee_Document_Link").value = link; } document.getElementsById("InsertRecordEmployee_First_Name").onchange = concatenate; document.getElementsById("InsertRecordEmployee_Last_Name").onchange = concatenate; document.getElementsByName("InsertRecordEmployee_HR_Section")[0].onchange = concatenate; document.getElementsByName("InsertRecordEmployee_Document_Origin")[0].onchange = concatenate; document.getElementsByName("InsertRecordEmployee_Document_Title")[0].onchange = concatenate; </script> Please advise ? Thank You...
  7. WORKED PERFECTLY... Can not THANK YOU enough. You are a genius. Very sincerely thank you for sharing you time and expertise.
  8. First of all, thank you very much for responding. Very much appreciated. Tried your suggestion: <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var one = document.getElementsByName("InsertRecordEmployee_Document_Title")[0].value; var two = document.getElementsByName("InsertRecordEmployee_Document_ID")[0].value; var link = one + " " + two; document.getElementById("InsertRecordEmployee_Document_Link").value = link; } /* Please note that Trigering_Field_ID must be changed for your actual field ID */ document.getElementById("Employee_Document_ID").onchange = concatenate(); </SCRIPT> Unfortunately did not wok. Because there is a report datpage above this form datapage (on the same html page)I tried: document.getElementById("Employee_Document_ID")[1].onchange = concatenate(); also did not work. I chose the cascading drop-down field Employee_Document_ID for the trigger field because it is the last to be populated once the last drop-down item is selected. Any suggestions ? Thanks again for helping.
  9. Having trouble trying to concatenate using onchange. the variables are derived from cascading dropdowns. Would like to see the concatenation results change as the dropdown selections are changed (this is all before submit on a form). <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var one = document.getElementsByName("InsertRecordEmployee_Document_Title").value; var two = document.getElementsByName("InsertRecordEmployee_Document_ID").value; var link = (one+" "+ two); document.getElementsByName("InsertRecordEmployee_Document_Link")value = link; } document.getElementById("caspioform").onchange=concatenate; </SCRIPT> Also Tried: <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var one = document.getElementsByName("InsertRecordEmployee_Document_Title")[0].value; var two = document.getElementsByName("InsertRecordEmployee_Document_ID")[0].value; var link = (one+" "+ two); document.getElementsById("InsertRecordEmployee_Document_Link")value = link; } document.getElementById("caspioform").onchange=concatenate; </SCRIPT> Unfortunately no luck. There is a report right above this form so I used the following which also didn't work: <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var one = document.forms[2].getElementsByName("InsertRecordEmployee_Document_Title")[0].value; var two = document.forms[2].getElementsByName("InsertRecordEmployee_Document_ID")[0].value; var link = (one+" "+ two); document.forms[2].getElementsById("InsertRecordEmployee_Document_Link")value = link; } document.getElementById("caspioform").onchange=concatenate; </SCRIPT> Would really appreciate if anyone can guide me in the right direction. Thanks
  10. I agree I would think this would be a primary default feature. The only solution, unless you have a corporate account, is to have have a third party create formatted print output utilizing Caspio Web API. using either SOAP or REST methods.
  11. Have you looked at Cascading dropdowns ? http://howto.caspio.com/datapages/datapage-components/cascading-elements/ Hope this helps
  12. I am trying to ad a boarder to the cells of a Gallery Report Results Page. I experimented in the source page of the Style but couldn't figure out which parameter it was. If anyone knows, please let me know. Thanks
  13. Hello DCT247, If I understood your post, the following might help. Did you ever try using parameter strings ? I know you can basically achieve the same with the internal field parameter passing but utilizing parameter passing via a string placed after the URL allows more flexibility in redirecting to different urls if the script is placed in an HTML datapage. http://howto.caspio.com/parameters/parameters-as-query-string-values/ I just had a similar situation and this worked for me. Create a datapage form with auto submit in the footer. Have only the specific fields you want updated receive the matching field parameters passed. Hope this helps.
  14. Does anyone have an SQL or JavaScript for a calculated field to accomplish the following: Want to be able to have record level running total like you would have in bank statement. For example... Starting Balance $200.00 __________________________________________ Date-------------Debit/Credit---------Amount------Balance __________________________________________ 10/27/2014----Check # 101--------$20.00-----$180.00 10/30/2014----Check # 102--------$15.00-----$165.00 11/03/2014----Deposit-------------($100.00)---$265.00 11/04/2014----Check #103---------$65.00-----$200.00 ETC.... Would like to have a running balance in a report so the customer can know what their balance was on a given day. I wrote a full accounting application for county government back in 1998 and it is still in use today. I would love to completely recreate the program with Caspio as the back-end. I only have two obstacles preventing me from moving forward with this large task. Obstacle one is the running balance which I am inquiring about in this post and obstacle two is the ability to have custom print output. In my current (OLD APP) I can print checks and do bank reconciliation. Any suggestions would be very much appreciated.... Thanks
  15. Tried this but still "Formula Error" case when [@pos_taxable] = 'Yes' then sum([@price_actual_sold]) else end Any Suggestions ? Thanks
  16. Trying to calculate taxable sales only. Also want to determine tax via pos_tax_rate field. Would appreciate help. Please see attachment . Thanks in advance ...
  17. Does anyone know if it is possible perhaps to use SQL in an aggregate or calculated field that would create a variable which could be passed to the next page ? If yes, could you give a simple script example ? (or any other method to accomplish the same). Thanks for your Help...
  18. The reason I posted the previous question is because I tried it and it didn't seem to work. Upon closer observation I found a typing error (on my part). Once it was corrected it worked just fine. I do have one question. Does the && in the "if" statement the same function as an .and. booleen operator ? The reason I ask is I tested the condition but it didn't work exactly as I would expect. If Y/N check mark is Y .and. percentage field is greater than or equal to 10, then calculate and insert value into field. else (I would have expected) if either Y/N = N .or. percentage field is .not. >= 10 then insert 0 into field. What is actually taking place is it is properly functioning only when the percentage field is or is .not. >= 10 then insert the calculation or 0 into field. In other words it seems to ignore the Y/N check mark field. Any advise ? Thanks
  19. If I were to utilize the exact script on the corresponding report datapage, would it just be a matter of changing the word insert to edit ? (There are two other datapages on the same web page.)
  20. MayMusic, You are incredible ! It works perfectly now. I have really learned a lot by your example. I can't THANK YOU ENOUGH ! Very Sincerely, Accountability
×
×
  • Create New...