
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 07, 2019 10:06 PM
Hi. I have system where the users email address is effectively the unique identifier, as such I take these email address and use excel to manipulate that into a powershell script that i can batch create user accounts.
So I’m provided with email addresses
ivor.bunnion@acme.com
and the excel sheet give me the following script.
New-PWUser -UserName ivor.bunnion -Password WSP2018!! -Identity ivor.bunnion@acme.com -Email ivor.bunnion@acme.com -Description ivor.bunnion
The excel formula (my excel skills are basic) is
=$A$3&" “&C19&” -"&$A$4&" “&$B$4&” -Identity “&B19&” “&” -Email “&B19&” -Description “&C19&”"
Is this in principle feasible in Airtable as I’d like to move to as the capturing tool rather than excel.
Regards
Rob

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 08, 2019 12:49 AM
Yes: You’re mainly parsing out the user id from the email address and using it to fill in the blanks in a canned statement. The only tricky part will be generating the password, for which, AFAIK, there is no canned Airtable functionality. You’ll have to implement the creation of a properly hashed password yourself — unless someone can contribute working code… hint, hint…
