Show Posts

This section allows you to view all posts made by this member.


Messages - etech0

Pages: [1] 2 3 4 5 6 7 ... 973
1
Just Shmooze / Re: Is It Ethical?
« on: Yesterday at 05:56:57 PM »
Found it, thanks
IIRC it was me, no?

ETA: yes!

2
Tech Talk / Re: Google Sheets help
« on: Yesterday at 03:26:28 PM »
Anyone know if there's a way to do ctl ditto in Google Sheets?
There's something similar: https://webapps.stackexchange.com/questions/74517/equivalent-of-ctrlapostrophe-in-google-sheets

Basically you need to select the cell with data to copy, and the cell below it where you want to paste, then press control-d

3
Tech Talk / Re: Excel Help and Problems
« on: Yesterday at 02:47:33 PM »
multiple rows
I don't think that can be done with vlookup, there's probably a way using array formulas but I'm not so familiar with them. Hopefully someone else  can answer!

4
Tech Talk / Re: Excel Help and Problems
« on: Yesterday at 02:34:52 PM »
possible to use VLOOKUP to return all data matching the value? (i am not using a UI)
Do you mean all the columns for that row, or multiple rows that have the same value?

5
Tech Talk / Re: Excel Help and Problems
« on: February 21, 2018, 06:45:28 PM »
i have two sheets both have a unique identifier in column A containing the order number, what i want is to fill info in blank column D of sheet1 based on what's in column D in sheet2 for the same order number
VLOOKUP

Example:

=VLOOKUP(A2,Sheet2!A:D,4,0)

A2 is the order # in the current sheet, Sheet2!A:D is where to look in the other sheet, 4 means return the result from the 4th column (since the range starts at column A, the 4th column is D). 0 means only return results if the order number matches exactly.

6
Tech Talk / Re: Excel Help and Problems
« on: February 21, 2018, 03:10:03 PM »
is there a separate thread for Google sheets, or its a "all in one"?
Google Sheets help

7
Destination Guides And Trip Planning / Re: Monsey Master Thread
« on: February 21, 2018, 03:04:17 PM »

8
Destination Guides And Trip Planning / Re: Monsey Master Thread
« on: February 21, 2018, 02:54:52 PM »
Any recommendations for a service that can deliver water for a water cooler (I think it's 5 gallon bottles)?

TIA

9
General Discussion / Re: Site Suggestions
« on: February 21, 2018, 02:16:30 PM »
I was going to try and explain it but I figure why re-invent the wheel?
From a quick glance here it seems this is a good explanation:
https://www.thoughtco.com/absolute-vs-relative-3466208
Thanks, that was a great read! So by "non-static" you refer to  absolute, relative, or fixed?

10
General Discussion / Re: Site Suggestions
« on: February 21, 2018, 01:53:42 PM »
It's not exactly the same, it's a few pixels off.
An absolutely positioned element is positioned based on its closest ancestor with a non-static position.
I think that's a little over my head :) what does non-static position mean?

11
General Discussion / Re: Site Suggestions
« on: February 21, 2018, 01:02:45 PM »
Basically, CSS works right to left. It starts with the rightmost part of the rule and works its way back
So for
Code: [Select]
.subject.windowbg2 divwhich basically says "a div which is a descendant of an element with the classes subject and windowbg2," every time it encounters a div it looks all the way up the DOM to see if it has an ancestor with those classes. Adding the ">" tells it to look at the direct parent only.


One change to make it work for stickied posts
Code: [Select]
.subject.windowbg2, .subject.stickybg2 {
    position: relative;
    padding-left: 50px;
}
Aha! I just didn't realize that
Code: [Select]
.subject.windowbg2 div would work the same as
Code: [Select]
.subject.windowbg2 since you're not referring to the same element.

12
General Discussion / Re: Site Suggestions
« on: February 21, 2018, 12:21:48 PM »
I would do this a bit different....
I don't totally follow, but here's my new code, which seems to work the same:

Code: [Select]
.subject.windowbg2 {
    position: relative;
    padding-left: 50px;
}

a[id^="newicon"] {
    position: absolute;
    left: 6px;
    top: 10px;
}

a[id^="newicon"] > img {
   height:14px;
}

13
General Discussion / Re: Site Suggestions
« on: February 21, 2018, 12:14:47 AM »
For yourself?

Install the Chrome extension called Stylish: https://chrome.google.com/webstore/detail/stylish-custom-themes-for/fjnbnpbmkenffdnngjfgmeleoegfcffe?hl=en

Create a new script that looks like this:



(Copy and paste the code from my post upthread)

For the entire DDF community, you'll have to ask someone who knows how SMF works.

14
General Discussion / Re: Site Suggestions
« on: February 20, 2018, 10:43:38 PM »
I don't remember exactly but it was something like this. (I don't remember the values I used and I'm too lazy to look up the actual element ids/classes)
Got it!
Code: [Select]
.subject.windowbg2 div{
    position: relative;
    padding-left: 50px;
}

a[id^="newicon"] {
    position: absolute;
    left: 6px;
    top: 10px;
}

a[id^="newicon"] img {
   height:14px;
}


Pages: [1] 2 3 4 5 6 7 ... 973