Hello,
I have a scenario where the automation watches for a new response from Tally. Once that comes through, I would like to update a user’s field (via ACF) in WordPress with one of the fields from Tally - let’s call that total_score. Within Tally, I request the user to
input their username, so that it gets mapped to the username stored in WordPress. However, I ran into an error while trying to test this. The Error is on the WordPress side. The “User ID” within this WordPress Update a User module appears to be a number type and isn’t reading through the value, which can be varchar for a username. I’ve attached a couple of screenshots for reference. Not sure what to do next. I would appreciate any guidance on this.
Hi Andrew,
Have you tried using the “Get a User” action first before updating. On several Make automation’s I’ve worked on I’ve had to incorporate the “Get a Record” action before “Update the Record”, usually to identify when a record needs to be created vs updated but I think it can help here.
If you’re looking to avoid adding that step then you can always try using the toString function.
Please let me know if that works!
Hi, thank you for your feedback. I tried using “Get a User” before “Update a User”, and I ran into the same error. I also tried using “toString,” but I encountered the same. 
Ok I think I’ve got it, after looking at the wordpress api documentation. User_ID is an integer value, you cannot search for a user with a string in that field - this is standard wordpress data schema that can’t be changed.
You’ll need to use the “Get a user step” to search for a user by a field other than User_ID, for example, email address. The output of this step will provide you a user ID you can use on the update step.
1 Like
I got it!! Thanks so much.
I ended up using “search user” and was then able to obtain the ID based on the username, so I was able to map the data accordingly. Thanks for the help!
1 Like
Wonderful to hear Andrew!
