Hi,
I am new to this platform. I want to create a simple application for retrieving the training schedule in the excel file that should be stored in the db manually. the user should select the month and when he clicks on the submit button the excel file should be read and its data should be displayed as grid/table format. Please help me how to start with this
In which database are you going to store the Excel files?
I don't believe the mobile browser can parse Excel files, unless you find some JavaScript library to do that (this has nothing to do with Tiggzi builder).
Can you store the data as plain text instead of Excel?
Yes i can store the data as plain text also..
I have one more question how to retrieve the records by where condition like i want records of September month only.. To be more clear ,
The user needs to select the month and year from select meny and based on these values the service should fetch the records from the database please let me know how to set the where request parameter.
I have tried using query request parameter but nothing is getting displayed. My project has collobration on. Please help in resolving it. Project name is MonthlySchedules.
Can you show what query you tried?
return "SELECT course,startdate,enddate from schedules where 'dc'="+localStorage.getItem('dc')+" and 'month'="+localStorage.getItem('month')+"and 'year'="+localStorage.getItem('year')"
Below are the screenshots.
The query should be in this format: http://help.gotiggr.com/documentation...
I was refering to this post https://getsatisfaction.com/tiggzi/to...
If you are using SQLite, I don't know why it's not working (nothing to do with Tiggzi). Did you setup the connection to the database?