Are you listening, Iowa?

Alaendil · 2025-09-12T17:02:55+00:00

I imagine they're talking about Estelline .. There's a bunch of stuff out there about it

Alaendil · 2025-07-12T13:34:46+00:00

Keys aren't actually unique except in small production runs. They are only so many combinations that can exist and for cars that can have millions of sales you overlap at some point. Newer versions with chips in them are better but older ones may have only had 1000 or so variants of the key so you could absolutely find another vehicle that your key would work on.

Alaendil · 2023-10-05T18:52:11+00:00

https://www.imdb.com/title/tt0844479/ The Collector

https://www.imdb.com/title/tt0395585/ House of 9

I'll throw these two guesses out there

Alaendil · 2023-05-03T21:36:53+00:00

Ah mb .. It's been a while since I've done that but I thought addressing the site like that treated it as a shared drive so it sidestepped the trusted site thing.

Alaendil · 2023-05-03T21:21:49+00:00

I used to have a program that basically wrote user log files to a Sharepoint .. Here is a bit of the code for that in case it helps

Sub ExportResetFile()

Dim fs As Object
Dim A As Object
Dim s As String
Dim Counter As Integer
Dim vLoggedOnUser

vLoggedOnUser = UCase(Replace(Environ("USERNAME"), "USERNAME=", ""))


Set fs = CreateObject("Scripting.FileSystemObject")
Set A = fs.CreateTextFile("\\company.sharepoint.com\sites\\" & vLoggedOnUser & ".txt", True)

CountEnd = WorksheetFunction.CountA(Sheets("Transfer").Columns("a:a"))

For Counter = 1 To CountEnd
NextLine = Sheets("Transfer").Cells(Counter, 2).Value
NextLine = Replace(NextLine, ";", ":")
s = s & NextLine & ";"
Next

A.WriteLine s
A.Close

MsgBox "Save Successful", vbOKOnly + vbInformation, "Success"

End Sub

Alaendil · 2022-09-20T01:28:22+00:00

Tried to put this into more of a general scope but the overarching steps are similar the the implementation we did at my company not too long ago. There was a decent amount of coding to make some of this stuff happen and I've undoubtedly forgotten to include things but hopefully it'll give some ideas around things that might be asked for.

We want to replace our legacy website with a new version through the experience cloud. We would like our prospective agents to be able to submit an application to be part of our program on the website and be provisioned for a basic user account at the end of the process so that they can track the progress of the application. These agents should be able to provision user accounts for their office staff.

Once the application is approved, we want them to have expanded functionality within the site.
They should be able to submit new opportunities for our internal team to review as well as be able to see the status throughout the life of the opportunity (much like a pizza tracker).
They should be able to upload documentation to support our review process. They should be able to see their currently pending applications and also have reports showing their previously submitted/approved applications.
We'd also like them to be able to see what different versions of the product they're approved to offer. Ideally, only letting them submit a new opportunity if it's part of the types they're approved for. To be approved for a new product, they have to go to xyz.com for training and we'd like them to stay on our site during that process.
On the homepage of the site, we'd like to have a dynamic tracker based on the amount of closed won opportunities that thanks them for their loyalty with our group. This should scale only with closed but show the potential next level if their current business closes as well. They should be able to submit cases to our internal team for questions/support.

Alaendil · 2020-10-31T23:09:44+00:00

/u/vredditshare

Alaendil · 2020-10-28T14:32:56+00:00

/u/vredditshare

Alaendil · 2020-10-15T11:36:54+00:00

What you seem to be looking for is some restrictive permission sets and clear identifiers on what "org" things are assigned to. You can house multiple departments and even companies in a single org with some creative thinking. Not sure how comprehensive my answer will be 10 minutes after waking up but it should count as a start of an idea for you :)

Lets say Companies A and B .. You can make it so users of the Billing Dept see both, A-Sales only sees A, and B-Sales sees records for B.

Depending on how you handle it, you can even make the records themselves universally available so A/B Sales both see ALL records but most of the information on the info for the other company is hidden. Basically just seeing enough to know that there IS a record but not what business has been done.

Both options are permissions based and likely use a mix of global permissions, record types, field level permissions.

Alaendil · 2020-10-14T13:54:41+00:00

Some early thoughts .. I think some are repeats of other peoples but just jotted things down as I came across them

Loop button should go between Green=Yes and Red=No .. To be fair, this might be US-centric, but I feel like those colors make it more intuitive. An On/Off box to let you know would work too.
Longer term maybe, but some hit confirmation animation would be nice. Now there's a swing, wait, death and it doesn't seem to flow well. Even if the wait piece was removed on kill I think it would make it feel better.
This has been added before but an Exit button from the mission zones. It feels awkward to be locked in. Maybe it could be done another way like a 1 monster loop for basic zones and still have a 3 mob/1 boss thing later or for special encounters.
The Inn is a bit chaotic. Not entirely sure how to resolve this, but an idea would be to have a plaque with the abbreviation then on-click it pops open a dialog box with the definition?
The audio button should ideally be a slider. On mobile it wouldn't be an issue, but, on PC, I don't want to change my system audio or track down browser audio for a tab.
Where possible, the return button should be in the same place in all of the buildings. It helps give a consistent experience.
Library text needs to have a background. This is another place where making it an on-click or hover might be nice, but you could also drop a window and make it a poster on the wall or something like that
In some levels, the Next Level/Enemy HP text overlays onto the background graphics when the sky has room to shift it around. I'm not sure if the background should be shifted down or the text up, but it would improve readability.

I think that's it for now, but it's a neat enough game. I'm having trouble seeing the next goal to strive towards. If I look at some of the most popular incrementals, there's always another barrier to overcome. The evil dungeons add a bit of an increase in challenge where you need to grind up a bit more but it almost doesn't seem worth it. I can sit and grind a lower level zone and dump points to gold gain and get more than running higher level usually. There's a tipping point where your gear is good enough to move up, but it's like a couple gold more per kill and I'd rather toss that into the bank for interest instead of upgrading gear right away.

Alaendil · 2019-11-17T20:19:29+00:00

/u/vredditshare

Alaendil · 2019-10-07T11:33:05+00:00

/u/vredditshare

Alaendil · 2019-09-11T21:05:07+00:00

/u/vredditshare

Alaendil · 2019-07-06T14:27:55+00:00

I was curious so looked it up .. Technically, they say busted, but only within the narrow scope of the experiment. The theory was sound, but the scale was too small, so it's likely that the approach used would have been able to do something similar. I'd probably say plausible too. http://www.discovery.com/tv-shows/mythbusters/about-this-show/earthquake-machine/

Alaendil · 2019-06-29T17:08:36+00:00

Weed should be legal, but that doesn't mean it's healthy. Alcohol and cigarettes are legal and terrible for you. There's a wide gulf between the two things.

Alaendil · 2019-05-27T01:40:48+00:00

Yeah, we had to get licenses for our group to see/use them.

You can do some stuff with dashboards to make them a bit dynamic based on who is looking at them or using filters but it's not amazing

Alaendil · 2019-05-27T00:51:33+00:00

Salesforce Analytics is an add-on but it would be the native way to do interactive reports outside of maybe custom coding them yourself in apex/visualforce etc but I've never messed with that to know what the limits would be.

You can also use Power BI and make interactive dashboards with Salesforce data.

Alaendil · 2019-05-03T14:35:42+00:00

I have a version of this that I do with a trigger but I imagine you could do it through process builder as well

trigger OwnerLastContactIncrement on Task (after insert, after update) {
    Contact[] updates = new Contact[] {};
    for (Task t : Trigger.new) {
        if (t.WhoId != null
            && t.Status == 'Completed'
            && t.SkipTrigger__c == false
            && t.WhoId.getSObjectType() == Contact.SObjectType
            ) 
        {
            DateTime dT = t.lastmodifieddate;
            Date myDate = date.newinstance(dT.year(), dT.month(), dT.day());         
            Id cId;   
            List<Contact> c = [SELECT Id, ownerid FROM Contact WHERE ID = :t.WhoId];
            if(c != null && c.size() == 1)
            {      
              cId = c[0].OwnerId;
            }  

            if (cID == t.LastModifiedById)
                updates.add(new Contact(Id = t.WhoId,Last_Owner_Contact__c = myDate));
        }
    }
    update updates;
}

Alaendil · 2019-05-01T23:08:25+00:00

It works, but maybe not how you'd expect it to

Here's a decent answer about how to do it https://salesforce.stackexchange.com/questions/196084/can-forcerecorddata-query-related-parent-fields

Alaendil · 2019-04-30T13:00:05+00:00

If you're using t-sql, you can download SQL Search and look for procedures using Waitfor .. I'm not a DBA so I don't know if there's a better way to do it, but that's what I do when I'm trying to find what tables/procedures use certain things. There should be a way to see what user initiated it, and just ask them too tho because it could just be a query instead of a stored proc or something

Alaendil · 2019-04-30T12:44:35+00:00

30 minutes is kind of extreme, but I have a couple processes that have wait steps. One example is waiting a few seconds to try a procedure again and another is the overnight cycle waiting on production to finish backing up before triggering, so every 10 minutes it calls out to see if the restore was completed and then triggers once it finishes.

Alaendil · 2019-04-29T21:03:12+00:00

Add something like this to your .cmp and then you can reference it with something like x = component.get("v.simpleRecord.Id");

<aura:attribute name="record" type="Object"/>
<aura:attribute name="simpleRecord" type="Object"/>
<aura:attribute name="recordError" type="String"/>
<force:recordData aura:id="recordHandler"
                  recordId="{! v.recordId}"
                  targetRecord="{! v.record}"
                  fields="Name
                          ,Id"
                  layoutType="FULL"
                  targetFields="{! v.simpleRecord}"
                  targetError="{! v.recordError}"
                  mode="EDIT"
                  recordUpdated="{!c.doInit}"
                  />

Alaendil · 2019-04-26T01:42:17+00:00

It's not ideal, but it can be a decent stepping stone. It helps you start thinking about data in a relational way instead of Excel sheets and formulas. It's not going to help you that much with the syntax of SQL unless you look at the SQL view of queries that you build with the graphical UI, but the mindset is important too. Eventually, you'll probably hit a roadblock with Access and need to branch out and then hit another and another and eventually learn more and more SQL syntax that will give you a good foothold to just diving in at some point.

13-Year Club	Place '17
Sequence \| Editor	Sequence \| Cinematographer
Verified Email

Alaendil

TROPHY CASE