air travel – Can a visitor visa person enter into US from India via Mexico?

The ban is not on “Indians”, but people who have been in India in the last 14 days. The same applies to many other countries (all Schengen Area countries, the UK, Ireland, Brazil…), and to any person who is not a US citizen or permanent resident or one of the few exempted classes.

So you could indeed travel to any country which is not subject to a ban, stay there for 14 days, and then travel to the US.

US visas do not have any restrictions on where you are coming from, so you can indeed enter the US from Mexico if you want to.

Note that you should absolutely not try to pretend you weren’t in India in the last 14 days if you were. They will ask, and it is extremely likely they will find out, and they will be very unhappy, cancel your visa right away, send you back to where you were coming from, and this will be a big black mark on your record.

Note also that even airside transit counts as presence in any of the countries subject to the ban, so transits via most European countries also count as time in a banned country.

Finally, you should of course check any restrictions and requirements for entry into the other country (Mexico in your question), and that you will need a recent PCR test before you can board a flight to the US (and most other international flights, really).

spells – Is allowing to Polymorph Any Object into a specific person balanced?

By default, polymorph spells cannot be used to mimic the appearance of a specific creature, as per the rules for transmutation (polymorph) spells:

Unless otherwise noted, polymorph spells cannot be used to change into specific individuals. Although many of the fine details can be controlled, your appearance is always that of a generic member of that creature’s type.

The spell polymorph any object can act as greater polymorph, which in turn can act as alter self. These are all transmutation (polymorph) spells. None of them specify that the target can be made to look like a specific creature, so by RAW, it is not allowed.

Magically impersonating a specific creature would typically require (1) a transmutation that specifically mentions looking like a specific individual, or (2) an illusion like disguise self. And even with magic, attempting to pass as a specific person may require an opposed Disguise skill check versus an observerer’s Perception check.

Allowing any polymorph spell to achieve this may be unbalanced, because it is situationally very powerful, and would be providing another spell’s benefit for free.

gdscript – third person camera errors

gdscript – third person camera errors – Game Development Stack Exchange

dnd 5e – Can Disguise Self be used to impersonate a specific person?

The limits are as follows:

  • You can change your height by 1 foot up or down.
  • You can change your weight (be thin or fat)
  • Must be same body type (ie if you’re 4 limbed biped, target must be as well)
  • Things don’t hold up to close scrutiny.

After that the extent of the illusion is up to you, you’ll probably have to work with your GM some to work out how exactly this works.

However, yes, you could definitely impersonate the warden of the prison, not just a generic guard. Though a close inspection of your face would reveal that you’re not him. And someone who knows him will might know something is off if you were having a conversation, though they might be fooled from across the room.

Ultimately though, the check matters the most. It’s an Intelligence (Investigation) check vs your spell save DC. That’s what will determine whether your disguise is a good one or you’re made.

Can a person with type-D schengen visa transit from london to another european country without any UK visa?


Your privacy


By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.




mysql – using (case when then) One identity Id must be correct to identify the person, all column is null then should say not identified

You can do an IF clause or CAsE WHEN

CREATE TABLE Table1
    (`ID` int, `SSN` varchar(11), `PASSPORTID` varchar(5), `ITIN` varchar(7))
;
    
INSERT INTO Table1
    (`ID`, `SSN`, `PASSPORTID`, `ITIN`)
VALUES
    (1, '111-11-1111', 'AA155', '123ITIN'),
    (2, NULL, 'AA156', '124ITIN'),
    (3, NULL, NULL, '123ITIN'),
    (4, NULL, NULL, NULL),
    (5, '222-22-2222', NULL, '126ITIN'),
    (6, '333-33-3333', 'AA117', NULL)
;
SELECT `ID`
, IF (`SSN` IS NOT NULL OR `PASSPORTID` IS NOT NULL OR `ITIN` IS NOT NULL, 'identified', 'NOT identified') as checkup1
,CASE WHEN `SSN` IS NOT NULL OR `PASSPORTID` IS NOT NULL OR `ITIN` IS NOT NULL THEN 'identified' ELSE 'NOT identified' END as checkup2
FROM Table1
ID | checkup1       | checkup2      
-: | :------------- | :-------------
 1 | identified     | identified    
 2 | identified     | identified    
 3 | identified     | identified    
 4 | NOT identified | NOT identified
 5 | identified     | identified    
 6 | identified     | identified    

db<>fiddle here

sharepoint online – How to separate ‘Person or Group’ column values by a comma and display on one line?

When you select multiple Persons from a Person or Group column in a SharePoint List, each value will be displayed on its own line, eg:

Person_01  
Person_02  

However, a Choice column that allows multiple selections will display selected options as:

Some_Choice_01, Some_Choice_02, Some_Choice_03

Person or Group columns are supported in column formatting:

Supported column types

Is there a way to display multiple Persons separated by commas, so that they can be displayed on one line?

This answer provides a solution for multiple options being selected in a Managed Metadata column:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=join(@currentField, ', ')"
}

However, when applied to a Person or Group column it outputs this:

(object Object), (object Object)

problem players – Am I the problematic person here?

I’m currently playing at a table using Discord with some online and IRL friends, once a week. All’s good in the world, but recently, another friend asked me to join, and after checking with our GM, he’s been added to the table. Since then, some of his actions have been chipping away my enjoyment.

His roleplay consists of being the first to talk in some scenes, only to point out the obvious and requesting someone in the group to take a particuliar action, without specifying someone in particuliar.

Found some wounded NPCs?

“I turn to the group and say Someone with healing abilities should heal that person“.

Interrogating a lying NPCs?

“I turn to the group and say One of us who can force a foe to tell the truth should do so“.

A strong, sturdy door stopping our exploration?

“I look at the door, turn to the group and say this door looks very sturdy, someone with great strenght should try to open it“.

Need to translate a book of spells?

“I ask the group Wasn’t there someone in our group that could translate foreign languages?“.

All the while deliberatly knowing someone in our party could, in fact, do the thing that he asked. And I should add that he’s deadly serious: he’s not playing an annoying character, it’s just his way of playing roleplaying games.

I found it rude to, while knowing our capacities, to never address directly our characters, to always ask around and wait for the correct player to act up.
At first, I was flabbergasted. Then, week after week, it begans to annoy me more and more. One night I directly contacted him after a session to ask politely why was he acting like that.

He responded aggressively, saying that it was a recurring memory problem of his, and that he failed to see why it was such a problem to me. We did however talk about it and he promised me to stop doing so.

The very next session, he did it again, several times.

It’s irritating me so much that I stopped interacting with him during our sessions, and now I’m considering quitting the party to avoid playing with that friend. I cannot tell who’s selfish. My friend, for ignoring my plea? Myself, for downplaying his memory problem? Bit of both?

My question is : am I That Guy? Is it wrong of me to feel what now has turned into anger at my friend for his behavior? Should I leave quietly?

Disable first person becoming the host in Google Meet

In Google Meet, always the person who joins the meeting first becomes the host. The only option I have found is to reset the meeting link but resetting the link is adds other complications. Is there any option available to give host permission to only selected people?

Get Group Details from Person or Group field using REST API?

Try using this:

_api/web/lists/getbytitle('listname')/items(100)?$select=Initiator/EMail,RAReviewers/EMail&$expand=Initiator,RAReviewers

Above is working fine for me in case of person or group.

Example:

/_api/web/lists/getbytitle('TestList')/items(1)?$select=TestPersonField/Title,TestPersonField/EMail&$expand=TestPersonField

Output: Below is part of response returned from above API call

<entry>
    <content type="application/xml">
        <m:properties>
            <d:Title>Ganesh Sanap</d:Title>
            <d:EMail>gsanap@tenant.onmicrosoft.com</d:EMail>
        </m:properties>
    </content>
</entry>
<entry>
    <content type="application/xml">
        <m:properties>
            <d:Title>SPConnect Members</d:Title>
            <d:EMail>SPConnect@tenant.onmicrosoft.com</d:EMail>
        </m:properties>
    </content>
</entry>

Where SPConnect Members is a Microsoft 365 group name.

Note: This will not work for SharePoint groups as they don’t have Email property.

DreamProxies - Cheapest USA Elite Private Proxies 100 Private Proxies 200 Private Proxies 400 Private Proxies 1000 Private Proxies 2000 Private Proxies 5000 Private Proxies ExtraProxies.com - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies ProxiesLive.com Proxies-free.com New Proxy Lists Every Day Proxies123.com Buy Cheap Private Proxies; Best Quality USA Private Proxies