Hi, I’m currently trying to create a Discord bot that automatically gives a user a role upon order_paid in WooCommerce. There is an additional billing field on my site where users can input their Discord usernames, in the format ‘Example#1234’.
In Zapier, I’ve set it up to grab this data correctly, however when I try to ‘Add a Role’ for Discord on Zapier, it can only find users from their display name only.
In-depth: The full username is ‘Example#1234’ but Zapier can only search for ‘Example’. If it finds a user for ‘Example’ it will give that person the role. This doesn’t work because there can be two people named the same thing or have the same characters in their name.
Either way I tried to use Zapier’s formatter to truncate the input from ‘Example#1234’ to ‘Example’ (so it would be able to find someone at least), but the truncate function only allows you to:
1. Set a Maximum character limit,
2. Skip the first nth characters,
3. Remove ONLY the last 3 characters and append ‘...’ to the end for some reason. (??? wtf just make it remove the last x characters)
Zapier assigns roles/other functions for Discord accounts based off their UserID (a long string of numbers). How would I be able to get Zapier to assign a role based off the literal username & ID of someone?