I want to make a feedback view system so when somone selects the user from the dropdown you can see the feedback im stuck because i dont know how to pull the username of the person selected, one more thing is there any way to make a avrage with like stars next to it so if its 4.6 it would show 4 and a half stars I have the emojis for it just dont want to make 10 differenty if statements
You’ll have to make the star system as there’s no direct endpoint for your specific system in Discord but for the user dropdown, you can use the Get User block to get the username of the selected user
One more thing how can i search in the database for all rows containing a certain dicsord id and then write all of them down
Write the rest of the collumns down
The “Dropdown Values” output from the trigger will be their user ID. you can then use the Get User block to get their username/display name.
This custom block should work. https://inventor.gg/dash/share/component/b1f4bf8c4dde42edae9b4b74fa44ed57
There are two if statements, one will append a half star and one will append a star. You can adjust those to pick how you want it to round up/down.
- Create Local Variable
- Get Rows by Values
- Append Line to Local Variable (put whatever info you want to here)
Thanks for the last thing i dont get it fully can you explain it a bit more
And how can I impliment emojis that i have for stars
Those will be the custom block inputs. There’s an input for full and half star. Just put the text in the format <name:id>
I gave you the exact blocks
What should I put as the value in the get rows by values?
Hey how can I make a avrage for the ratings in the database
You’ll need to figure that one out on your own, I won’t spoonfeed you.