Using HTML Form on Cloud Drive |
Using HTML Form on Cloud Drive |
Omagoodness |
Oct 14 2020, 07:02 AM
Post
#1
|
Group: Members Posts: 1 Joined: 14-October 20 Member No.: 27,594 |
Hello everyone.
I am new to this site and also very much a novice with HTML. I have a very small business and I want my employees to submit their worked hours into an Excel spreadsheet via an html form from their mobile devices. . I have developed the form: CODE <!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN" "http://www.wapforum.org/DTD/xhtml-mobile10.dtd"> <html xmlns="http://www.codaramen/xhtml"> <head> <meta name = "viewport" content="width=device=width,initial-scale=1"> <Created by XXXXXXXXXXX - October 2020></Created> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Time Sheet</title> </head> </style> <body> <center> <img src="Communication Documents/Branding/Logo.jpg" alt=""/> <table> <td><h2>Employee Time Submission</h2 <h4>Accuracy is important - Your pay depends on it!</h4> <form> <p>First Name: </label> <input type="text" name="FName" /> Last Name: </label> <input type="text" name="LName" /> <br> <br> Date Worked:</label> <input type="date" name="Wdate"/> <br> <br> Start Time: </label> <input type="time" name="stTime"/> End Time: </label> <input type="time" name="endTime"/> </p> <p> <input type="submit" name="cmdsubmit" id="cmdsubmit" value="Submit" /> <input type="reset" name="cmdreset" id="cmdreset" value="Cancel" /> </p> </form> </td> </table> </center> </body> </html> The form resides in DropBox. I also have an excel spreadsheet in DropBox. My question? How do I get the data from the form to the spreadsheet? Is this even possible? I found help with code to submit the form data to a location on my computer but not on the cloud server. CODE <script language="vbscript" type="text/vbscript"> Sub Export() Dim mytable Dim mytable1 Dim tab Dim n Dim j Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("C:\Users\Owner\Desktop\TimeSheet.xlsx") objExcel.Application.Visible =True objWorkbook.Windows(1).Visible =True set XlSheet =objWorkbook.Sheets(1) XlSheet.Activate Set tab=document.getElementsByTagName("table")(0) mytable = document.getElementsByTagName("table")(0).rows.length mytable1= document.getElementsByTagName("table")(0).rows(0).cells.length For n = 0 to (mytable-1) For j = 0 To (mytable1-1) XlSheet.Cells (n + 1, j + 1).Value = tab.Rows(n).Cells(j).innertext Next Next MsgBox "Data Exported Successfully",vbInformation objWorkbook. Save objWorkbook. Close Set objWorkbook = Nothing Set objExcel = Nothing End sub </Script> I know there are dozens of commercial forms for mobile devices out there but their pricing is prohibitive for my small business at this time. |
Christian J |
Oct 14 2020, 09:28 AM
Post
#2
|
. Group: WDG Moderators Posts: 9,656 Joined: 10-August 06 Member No.: 7 |
In general, an HTML form needs to be submitted to a server-side script (like PHP), which in turn can write to a file; however I don't know if Dropbox allows users to run their own server-side scripts.
That said there may be some readymade Dropbox functionality for this, like this page says: https://www.jotform.com/answers/1601978-How...le-into-Dropbox (seems you need a Jotform account in order to follow the link on the page, though). |
pandy |
Oct 14 2020, 01:16 PM
Post
#3
|
🌟Computer says no🌟 Group: WDG Moderators Posts: 20,730 Joined: 9-August 06 Member No.: 6 |
Do you have a real site, or do you only use DropBox?
|
Lo-Fi Version | Time is now: 24th April 2024 - 03:45 PM |