gs123 said:
balars4 said:
Dear Admin,
If possible change the column in spreadsheet as next to next, as given. It will be easy to read.
Courier Service Sent Date Received Date Received Time Received by 'No. of Days Taken if possible'
I agree. At this stage, this "next to next
" information makes more sense to me also as people just started sending applications but later (may be mid next month), these columns will not be as relevant to be kept together and can be switched back As Is again.
Over to Admins to decide.
binuky said:
Dear admin,
Please sort the spread sheet entry on basis of the time of receipt the application in the cpo along with date.
Hi guys. Actually, this is exactly what I wanted to discuss with everyone.
First, regarding the column order. Initially I thought the same, the columns should be in chronological order. But then I realized if I move the "Application received at CIO" column to the same place where "Receiving time" column is now, it will be rather inconvenient to scroll horizontally all the time between the "NOC", "Visa Office" columns and the "Application received" column - these 3 columns (maybe arguably) contain the most interesting information now.
Do you believe it's not an issue and it's still better to move the "Application received" column to the left of "Receiving time" column?
Feedback from everyone is welcome.
Next, about row sorting. I've used the FSW 2013 spreadsheet sorting order as a reference, and also it seems to be convenient when applications are sorted by their status, then by NOC, and then by Received date. Looks logical to me, but again, feedback from everyone is welcome. Let's ask and see what most people prefer.
And don't forget - there's sorting filters available, in the menu: Data->Filter Views. You can choose your own favorite filter from them and use it
Also, sorry for some bugs - currently the person who updated their information last is placed to the end of the list, due to specifics of how Google Spreadsheets refreshes formula results. I'll try to find a workaround.
I'll also think how to resolve duplicates issue - looks like default Google Form behavior is buggy and under some circumstances it creates duplicates even when someone edits their info using an edit link.