Help me to write program for data entry

randomstrings

Supreme Member
Joined
Feb 3, 2021
Messages
1,323
Reaction score
853
I work at server maintenance in my day job, and somehow my manager is convinced that i can write a program which have many data entry fields we enter data and results are saved in excel format output. Can someone gives me some headup if that can be done in html, as this is only language i knows. LoL
 
Yeah, you can do it using simple Bootstrap and SheetJS plugin.
 
I work at server maintenance in my day job, and somehow my manager is convinced that i can write a program which have many data entry fields we enter data and results are saved in excel format output. Can someone gives me some headup if that can be done in html, as this is only language i knows. LoL
HTML is a language? :eek:


Jokes aside, HTML alone will not be sufficient for the task. You'll need to use JavaScript and server-side languages like PHP or Python.
If you do not know how to do that, you can hire a freelancer or maybe ask ChatGPT. :)
 
HTML is a language? :eek:


Jokes aside, HTML alone will not be sufficient for the task. You'll need to use JavaScript and server-side languages like PHP or Python.
If you do not know how to do that, you can hire a freelancer or maybe ask ChatGPT. :)
I am very much convinced its not a big task and if i dig enough online including here i am gonna find a pre written code or program.
 
I am very much convinced its not a big task and if i dig enough online including here i am gonna find a pre written code or program.
It will take a maximum of 2-3 hours to do. I think you can find prewritten code on GitHub.
 
image_2023_05_18T14_47_01_623Z.png


Its easy if you use chatgpt, this is what it pumped out for me after a couple of prompts for a windows app I'm working on. Just described what I needed.

In your case you want to start with an HTML form, with the right inputs you'll be able to master something in the front end, and then its up to you to select as others have a said too, a backend language, PHP would be the easiest if it's just like a one-off, as that's the fastest to deal with and get going. Then you just need to design the interface between the front end, and the database of information you want to interact with. A bit of javascript might be needed for processing your front end and back end.
 
I though server maintenance employees knew bash scripting?
 
I work at server maintenance in my day job, and somehow my manager is convinced that i can write a program which have many data entry fields we enter data and results are saved in excel format output. Can someone gives me some headup if that can be done in html, as this is only language i knows. LoL
I will do this for you as a challenge. Lets talk and tell me the required data fields.
 
I will do this for you as a challenge. Lets talk and tell me the required data fields.
Thanks man, I don't want to trouble someone from their own time for a free work, i have collected few codes scattered on guthub and stkof, will give those a try this weekend.
 
Thanks man, I don't want to trouble someone from their own time for a free work, i have collected few codes scattered on guthub and stkof, will give those a try this weekend.
ok then if you run into any problem, I am absolutely ready to help you for free. I get satisfaction from coding challenges.
 
Update:
I have been able to create a application using python aa suggested by someone here, but due to number of text boxes(70) the application is bigger than the laptop screen and i am searching for a way to add scroll option to main window, i have used simple gui, if someone can throw a sample code it would be great.
 
Show some sample code or screenshots, otherwise it's tough to help.
Do you mean a vertical scrollbar?
 
It seems from your original post that you were working on a web application, given the reference to HTML. However, your query about Python .exe files has taken me by surprise as I don't personally have any experience with them. Nonetheless, I've taken the liberty to consult with ChatGPT on this matter to assist you better:

Since you mentioned you're using a "simple GUI", I'm going to assume you're using Tkinter which is built-in with Python and known for its simplicity.

Here's a basic example of how you might add a scrollbar to a Tkinter window:

Code:
import tkinter as tk

root = tk.Tk()

# create a canvas to enable scrolling
canvas = tk.Canvas(root)
canvas.pack(side='left', fill='both', expand=True)

# create a scrollbar
scrollbar = tk.Scrollbar(root, command=canvas.yview)
scrollbar.pack(side='right', fill='y')

# associate scrollbar with canvas
canvas.configure(yscrollcommand = scrollbar.set)

# create a frame inside the canvas to hold your content
frame = tk.Frame(canvas)
canvas.create_window((0,0), window=frame, anchor='nw')

# for this example, just create 50 labels to show the scrolling
for i in range(50):
    tk.Label(frame, text=f'Label {i+1}').pack()

# update the scrollregion after starting 'mainloop'
# when all widgets are in canvas
frame.update()
canvas.config(scrollregion=canvas.bbox('all'))

root.mainloop()

In this script:

  1. We create a Canvas widget, which is a container that can be scrolled.
  2. We create a Scrollbar widget.
  3. We link the Scrollbar with the Canvas so that when the scrollbar is moved, the canvas scrolls.
  4. We create a Frame inside the canvas to hold the content that needs to be scrolled.
  5. For demonstration purposes, we add 50 labels to the frame to make it overflow the canvas.
  6. We update the scrollregion of the canvas to cover all the widgets inside the frame.
This script will create a window with a vertical scrollbar. Once you've added the scrollbar and confirmed it works correctly in your Python script, you can convert your Python script into a .exe file using a tool like PyInstaller or cx_Freeze.
 
Find and use a frontend framework like react,vue,nextjs. or just go the simple route and use html and css. you can find alot of prebuilt form code on the internet.
 
Back
Top