Posts

Get the second last child of an element in CSS

In order to query the second last child of a HTML element in CSS, you can just simply use this: .my-menu:nth-last-child(2) assuming .my-menu is the class name of the parent node.

My first time at Vietnam Tech Conference as a presenter

Image
Just like every year, this weekend the school where I'm working hosted a conference name Vietnam Tech Conference (VTC). I was helping the conference by building its website, designing all the materials (badges, banner, ...). This year, I'm a presenter . I was assigned 2 sessions to be talked in Vietnamese with the intention to expend VTC to local school in Vietnam. So I chose to make one session about Google Apps for Education and how it can help Vietnamese schools and teachers and students to make their teaching and learning better. The session went very well even though there were only six people in the room and not all of them have technical background (teachers). After I showed them how easy it is to have Google apps for education setup in their school, I offered to consult and help for not-for-profit organizations or public schools in Vietnam for free . Please check out my contact in the presentation below: At the end of my first session, I was proud to show ...

Apple USB to Ethernet adapter not working on my Mac Air

Image
As you've already known, the Apple Macbook Air does not have an Ethernet port so I had to get a USB to Ethernet adapter to plug in my Internet cable. For some reason, when I plugged the adapter in, nothing happens. The folks on the Internet says that it's a bug of Macbook Air and Apple doesn't seem to have any fix for that. Luckily, there's one way to make the adapter works is to create a new network location . By creating a new location, I tell Mac OSX to load all the proper drivers for the network adapters which was missing in the previous locations. It's good for now.

Medium to Wordpress migration

Image
Even though the writing and reading experience on the  Medium platform is very great,  I had to move my publication to WordPress because Medium's lack of customization. The following steps showing how I did that: 1. Make sure you expose your medium articles to RSS feeds in full text format: Go to "Homepage and settings" >> Syndication >> Select " Full " >> Click " Save " 2. In your wordpress site, install the WP PIPES plugin, activate it: https://wordpress.org/plugins/wp-pipes/ 3. Then go to the Pipes sidebar menu and set it up: Configuring source (RSSReader, https://your.medium.pulication.url/feed) and destination (post): Mapping fields from feeds and wordpress posts: 4. Click " Test this pipe " and enjoy Note: I haven't found a way to migrate the images to WordPress, so I have to do it manually for now.

Arrange posts by "order" attribute in WordPress

It's just simple as this function: function my_get_posts( $query ) {     if ( is_home() && false == $query->query_vars['suppress_filters'] )                 $query->set('orderby', 'menu_order');                 $query->set('order', 'ASC');      return $query; } Basically, you need to order the posts by menu_order attribute.

Auto merge data from multiple sheets in a google spreadsheet

Image
Ok, so I heard that you want to merge multiple sheets (let's say 2) in a google spreadsheet? That's easy (after hours of trying :"D) Assuming you have 2 sheets as following: Sheet1 Sheet2: In the merged list or master list you need these information: First Name, Last Name, Company, Job Title, Email Address 1. First thing you need to do is to find out a field to use as merge key . It's Email Address in this case. You also should be noticed that there should be no duplicate email addresses. So in order to get all the unique email addresses from 2 sheets, you need to use UNIQUE. But UNIQUE will also give you a blank row (ending row), so FILTER will do the job: =FILTER(UNIQUE({Sheet1!H2:H;Sheet2!E2:E}),NOT(ISBLANK(unique({Sheet1!H2:H;Sheet2!E2:E})))) Notes: Look at how I refer to another sheet (Sheet!H2:H...) You only enter the formula in cell E2 of the Master list, all the email addresses will be filled in other rows automatically. 2. Then ...

Amazing!!!!

Image