Search the Community

I am trying to make a form where I can enter the daily sales of a retail shop, together with the number of transactions and other related info. I want to enter this information on a weekly basis, so I want the form to have seven records for each day of the week, and for my form to plug in the sales info in my table for each day individually. So one form but with multiple records / entries in my table. Any ideas? Thanks in advance.

User should be able to select a column field and add all it records to a new or existing table

I hope you can help me out with this. I have a submission form (connected to a blank data source) which has 1 Virtual field. The data element of the Virtual field is 'Radio button'. I would like to save all the radio button values by passing each radio button value to another submission form (which is an auto-submit form). I added this script in an HTML block of the fist submission form. I created a button <input onclick="SubmitRec()" type="submit" value="Click me" /> <script> function SubmitRec() { var radios = document.getElementsByName("InsertRecordcbParamVirtual1"); for(i = 0; i < radios.length; i++) { val = radios.value; var url = "https://c2arw288.caspio.com/dp.asp?AppKey=da284000f17dcfea2642497980e7?assid=[@cbParamVirtual1]; window.open ('url'); } } window.close() </script> This script in the Footer <script> window.onload = function hide() { document.getElementById("Submit").style.visibility = 'hidden'; } </script> Then I have this script in the Footer of the second submission form <script > setTimeout('document.forms["caspioform"].submit()',1000); setTimeout (window.close, 1000) </script>

I would like to set up a database where my authenticated users can upload their records (can be anywhere from 2-10k) in one go (who would fill in my form 10 thousand times a quarter?). The import feature worked great for me here, and if they had the ability to do something similar on their end - including the mapping ability the import wizard has it would be a life saver. Is this possible? I can't seem to find that option. Thank you kindly for your support! This is my first day and I do enjoy the ease of use here.