Not sure I understand what you mean.
8 comes from the datepicker, it is the 8th today.
Where are you putting 123?
I am trying to send all the data to spreadsheet, but it is not going. Only two values are going.
I have even changed the script
Can you help me here
Looking at the spreadsheet it seems to be working ?
I publish new version in script, so that only it is working I think so.
Thanks for your help, if I have any more query I will ping again.
I am trying to save data in offline but in my data there are “,” so that it reads as next line. How can I solve it?
I am getting the output as
This is wrong, I need all the text in one cell.
Is there anyway to do it?
That 's interesting, do you mean save to an offline Google spreadsheet on the device ?
Show your blocks for how you are doing this?
This is the blocks I have done to save the selected rows in offline spreadsheet.
Can you please tell me where I went wrong?
I can hardly read your blocks image - it is blurry. Right click on the blocks editor or individual blocks and Download as image /png.
Looks like you are saving to file using the file component though. Can you also show your created file?
I have attached the blocks.
The below snap is the online sheet
Below image is the offline sheet that I have got
Please show to content of a typical Daily Calls.csv.
You don’t show how you access the offline spreadsheet ? (web1.Url etc.)
(this assumes that all users will have their google drive on their device setup to work offline ?)
Not quite sure why you are repeating append to file with the button click and after web1.gottext ?
The work flow is
When I click download button is clicked -> It deletes the old file -> Create new file with first row (this first row consists of the header only so that only I gave append at button click field) -> Gets all the data from online sheet -> According to the user selection the data will be filtered and it is stored in Daily Calls.csv.
This is the Daily Calls.csv file
Well if you are not going to show your blocks for the web url or the content of the csv file (not what it looks like in the spreadsheet) then at present we cannot move forward…
I can’t get you
I didn’t give any block for web url, I directly gave it in designer screen.
Is this you asked?
I will try again.
Go into the designer, and copy the url used to access the offline google sheet, then paste that back here.
From the media section, download the Daily Calls.csv file to your computer. Open this with your text editor, then copy the contents and paste it here.
I am not using offline google sheet, I will just download google sheet in my device and show it. After downloading the sheet I am not going to doing anything with that.
The content of Daily Calls.csv
System ID,Lab No,SO.NO.,Call Received,Call Attended,Activity Type,Action Taken,Call Completed,Status,Remarks,Parts Used
SYS_LC-00361,32,NA,3-2-2020,3-2-2020,Breakdown,Carry over: Checked the data and sonicated the stator, rotor seal, needle seat and refixed the same to instrument.,2-Mar-20,Completed,NA,NA
SYS_LC-00381,33,6003686931,3-2-2020,3-2-2020,PM,Replaced parts/03-Mar-20 Performed the intensity test,failed.So cleaned the source lens and flowcell and then performed intensity test,passed./4-Mar-20 PM completed as per checklist.,4-Mar-20,Completed,NA,PM spare Kit
SYS_LC-00434,31,NA,3-2-2020,3-2-2020,User Do’s,No Flow: Checked the instrument and found okay then checked the software setting, found the setting was changed. So corrected the setting and found flow okay.,2-Mar-20,Completed,NA,NA
SYS_LC-00456,33,NA,3-2-2020,3-2-2020,User Do’s,Leak in ALS: Checked the instrument, found improper flow from waste tubing. So drained the waste tubing and sonicated inlet valve.,2-Mar-20,Completed,NA,NA
SYS_LC-00329,32,NA,3-2-2020,3-2-2020,Breakdown,Leakage: Checked the instrument and found leak inbetween the loop and needle, arrested leak from loop and found okay.,2-Mar-20,Completed,NA,NA
SYS_LC-00291,22,NA,3-3-2020,3-3-2020,Breakdown,Baseline Issue:Checked the instrument data with noisy baseline,so flused the instrument and then performed the intensity found OK.,3-Mar-20,Completed,NA,NA
SYS_LC-00400,22,NA,3-2-2020,3-3-2020,Breakdown,No Peak:Observed no peak in single injection of a sequence,request for injection audit trail,NA,Pending,Instrument under usage,NA
SYS_LC-00467,32,NA,3-3-2020,3-3-2020,Breakdown,RSD Failure:Checked the instrument data with RSD failure,so performed repeatability with RS7 and RS8 standard found RSD within limit./ 4-Mar-20 Performed the sequence with new samples/ 9-March-2020 Replaced the mobile phase and solvents, found the the results are satisfactory.,9-Mar-20,Completed,NA,NA
SYS_LC-00467,32,NA,3-Mar-20,3-Mar-20,Breakdown,RSD Failure:Checked the instrument data with RSD failure,so performed repeatability with RS7 and RS8 standard found RSD within limit./ 4-Mar-20 Performed the sequence with new samples/ 9-March-2020 Replaced the mobile phase and solvents, found the the results are satisfactory.,9-Mar-20,Completed,NA,NA
SYS_LC-00381,33,6003686931,2-Mar-20,2-Mar-20,PM,Replaced parts/03-Mar-20 Performed the intensity test,failed.So cleaned the source lens and flowcell and then performed intensity test,passed./4-Mar-20 PM completed as per checklist.,4-Mar-20,Completed,NA,PM spare Kit
You are losing the csv formatting (quotes for each element) somewhere along the line, probably because you are trying to build your csv file manually instead of using lists.
Make a list for your headings, and append the list from google sheet
I was able to store the data in sheet. Thanks for your help.
But now I need to update a data in google sheet. Is that possible?
AI2 and Google Drive/Docs/Sheets
I see you have asked the same question on Thunkable, and possibly switched to using Airtable.
Closing this topic