I am for the first time to create an app, my question is simple i need to export my data to a pdf or Excel offline how do i need to do that?
the app is for scanning cargo (with barcodes,and keep track of their deffects), after loading we need to print it/send it this would be best in a PDF or excel file. we are often in ports where there is no internet or where it is VERY expensive the ships internet is usually around the 500KB/S so that is no option. can someone help me with this?
Store the data in a local data source. When the user has better Internet, they can tap a button to upload the data to something like a Google Sheet.
Another option is to store the data as JSON. Check the file size but I suspect it would be very small. For example, this JSON containing 5 users is 2Kb. And here’s a 64Kb JSON file containing over 100 users. Save it to a stored variable or as a cell value in a local data source on the device. Then upload the JSON automatically from the ship (if small enough) or when a better Internet connection is available.
PDF export is tricky. I worked on that for a while and ended up using https://www.docsfold.com. It worked well but took some effort to set up and definitely needs an Internet connection to generate the PDF.
Could you help me with the first solution? store the data in a local data source, and then upload it to google sheet
When the user clicks a button, you would loop through the rows of the local data source and create a row in the Google Sheet with the data from the local data source. It will be a slow process depending on the size of the database.
See this example: How to send local db components to google sheets? - #4 by muneer
Post a screenshot of your blocks if you’re having trouble getting that to work.
Good day, i have included a link currently it is creating everything double in the list viewer
I wouldn’t create a row in the same data source that you’re looping through. You should use a different data source for the target, such as a Google Sheet. If you just want to test it, then use a different local data source.
Try this but create the row in the Barcodes data source instead:
I couldn’t use the Barcodes data source because it doesn’t have any column headers.
Will do Sir Thank you for your help
Okay sir i have tried your solution and will experiment a little later some more, i just got approved to use the ships faster internet so i can when the list is done scanning upload all into a spreadsheet. if you have time to help/adjust i greatly appreciate it
