... Friday at 08:00 in the morning and will create a task if time logged is too low and will remind via Popup at about 4pm (16:00). You will need a connector (I've called mine joel_timesheet) and I've given ...
What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have:
#copyright a{
margin: 10px 0 0 85px;
box-shadow: ...
What?
This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet.
Why?
The Excel file in question was about 36000 rows and had a file ...
What?
This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet.
Why?
I'm being tasked to work with ...
Some memory aids for me so that I don't have to keep looking them up:
/*
.joe_subtable td
.joe_subtable i
.joe_subtable .jst_label
.joe_subtable .jst_pre
.joe_subtable .jst_fn
*/
MySQL ...
... this week, 1 for the week before, 2 for the week before that...
$timesheet_query_per_user="
SELECT DISTINCT
s.StaffUserID AS 'UserID',
(
SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) ...
... a data table in ZohoAnalytics to hold the attachments
Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time
Add a dummy row with ...
... "Maci", "Macala", "Mack", "Macoy", "Macey", "Macedonia"...
Source(s):
Wikipedia: Category: Compound surnames
Diana, Goddess of the Hunt - Every-Name Index to Family Group Sheets: Mac / Mc
Wikipedia ...
... of Zoho Inventory. In this task, we are simply getting a CSV with all the order IDs for a particular year output as a spreadsheet.
How?
Similar to how we retrieved the eBay active listings (see ...
... tabs along the top to display each section.
How?
The way we do this is by applying our own stylesheet and overriding certain CSS elements that the vanilla or out-of-the-box Zoho Creator ones provide. ...
... someone may want to open this in Google Sheets or Microsoft Excel:
//
// init
l_NewCSVrows = List();
v_ThisEventTime = zoho.currenttime;
//
// loop through dataset
for each r_Event in zoho.crm.getRecords("Events", ...
... > Connections)
Click on "Add Connection" and click on "Zoho OAuth"
Give a lower connection name, eg. "joels_connector"
Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ):
...
... my workspace so that I can easily create a stylesheet and javascript file specific to this app:
Adding third-party frameworks: I’m going to use my favorite third-party extensions (Bootstrap & jQuery) ...
... of the image so that you can position it as per your requirements.
That should do it....
The Gist
Don't load in images bigger than an A4 sheet...
Additional Notes
I found that some ...
What?
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook).
How?
So for demonstration ...
... folder (my preference) and add the linked stylesheet in the head section of your webpage. I'm selective of what icons I copy over but the full directory can be found at https://github.com/FortAwesome/Font-Awesome:
...
... a new module (Insert > Module)
Copy and Paste the Excel user defined function belowSub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.