Do you have the query parameter in the url in the browser when you are testing this in the builder? If there is no sponserID in the url of the browser, then your column isn’t going to pull anything. That’s why I mentioned to try this in the published version.
Yes, but if you are expecting a certain query parameter while within the builder, that query parameter needs to be in the url in the browser, doesn’t it?
1 Like
no i dont think that i have. as i mentioned, the only thing from the current setup that has anything to do with the User ID of the sponsor is the custom action set column values. iv done so many changes i can hardly follow my own steps.
would you please give me the steps to the solution? i mean, what column do i need to add where, or what component, what action?
i would imagine this scenario is rather common for membership apps. thanks
I feel like you are overthinking the whole thing. Your ‘Get Sponsor ID’ column looks correct as you have showed it above. The problem is that the url for the builder in your browser does not contain a query parameter of sponserID in the browser’s url bar. If you were on a page with sponserID in the url, then that value would be populated.
Do a favor for me. Add a text component to the screen that loads when a user opens a link shared to them by the sponsor. Point that text component to the ‘Get Sponsor ID’ column. When you open the link of the published app, you should see the ID loading in that text component.
For reference
thanks jeff. like this one here? i have tried this before, just to test the URL parameter.
1st edit, it kept returning a constant User ID.
2nd edit, it returned the logged-in user’s own User ID
and now it’s returning nothing.
the way i did this was via a template combining the current URL screen and the User ID. i watched both Grumo and Robert P’s videos, but i cant figure out how they’re appending the URL. i tried command+click, shift+click etc, but coukdnt get that modal to pop up, that part when they’re appending the URL. that’s why im trying to recreate it with this template column.
You need to stop focusing on your ‘Current Url’ column. That is only useful for sharing the url with someone else via the QR code. It plays no part in retrieveing the sponsorID from the url in your browser. Just pretend that your ‘Current URL’ column doesn’t exist for a minute.
Let’s just worry about this one, which is correct in this picture. This is where you retrieve the code out of the url after a user visits the page.
i
1 Like
ok will do just that.
so if have just one table, with just columns for row ID, username, and photo, and i only have one blank screen without any components in it:
how would you make that screen to be a signup form for the next user and tag the existing user as the sponsor,
what columns would you add to the data table,
and what actions would you add, if any?
data editor:
- current Screen URL
- get part of URL
- ???
that’s as far as i can go. am really sorry to burden you guys with this.
I would have a Get Part of Url column to retrieve the SponsorID from the url that the user entered into their browser. Then any additional user specific columns for any other info you want the user to enter via entry components. Finally a button with an Add Row action to take all of the user input as well as the sponsorID retrieved from the url, and write it to another table.
1 Like
you are a boss! ill try this right away. thanks
this definitely, totally works! im too much of a moron to know why it works, but it does. you are a literal life-saver.
thanks to the both of you for bearing with me. and now, i finally get to sleep!
2 Likes
Yeah, that’s correct, and you’re also correct for saying OP should test with the real app in this one.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.