I use Google sheet for Softr data management but the most of my members find it difficult to always shuffle between our discord server and the website build with softr to use input forms there and so I decided to make discord forms with discord bot and successfully linked the form to the spreadsheet and so discord users can alternatively send the input data from discord instead of logging into the website to do so.
The challenge now is that inputs made through discord do not have auto generated Softr magic link even though the user name column has the same user name in Softr but I think that the magic link isn’t there because the input didn’t come from a logged-in user on the website.
How can this be resolved? I tried using google sheet vLookup formula to fix but unsuccessful.
Magic link code is supposed to be auto generated here for linkage when a logged in user fills a form in Softr. Now a discord input form has been linked for users to be able to submit same data via discord and this has been integrated with this google sheet but there is no Softr magic link code generated for those inputs from discord as shown and so cannot be linked to the user. How can this be resolved?
