it looks like you used user-specific columns, so it will only show what that specific user entered, for only this specific user
Yes… That’s exactly what I want it to do…but how do I get those blank entries off for the other users? Did I design this wrong? I want each user to be able to input their information in and only see their entries. So for instance…if I add another entry to my personal account…another blank entry will show up under the other user. I don’t want any entries showing up for other users unless they enter it in themselves.
is not showing anything… so everything is good, only if they enter, it will show…
i think I know what you mean… you don’t wanna show empty rows?
So I had the other user sign in and when he went to the Purchase tab, there were 3 blank entries…and he asked me what that was. So he’s going to have a full row of blank entries anytime anyone enters a new purchase. It’s showing up just like the 2nd screenshot. I’m not sure if you can see 3 blank profile pics with empty screens they can open. Can you see it on the screenshot?
Yes…I don’t want to show any blank rows. What am I doing wrong?
yes… you don’t want to show empty rows… all you have to do is click options for that list and use filter => DATE is not empty…
it is showing empty rows because you have there a rollup column that shows total… so the rows are not really empty
ok…let me try that right quick please.
Ohhh I see what you mean. Because I’m adding that column for another tab…then that row is technically not empty. Ok…I put that filter on, it didn’t work, but I will play around with it. I noticed that filter will act a little janky at times…but filtering by Date should work. Thanks again. That’s why I come to the experts. I’ve been wracking my brain for hours. LOL
Whoops!!! It worked. I was on the tab instead of the inline list when i tried to filter at first. I just filtered the list and it worked!!! Whoo Hooo!!! Thank you.
This will work, but I would recommend replacing user specific columns with normal columns. Then make sure your rows include a column with the email of the user that created the row. Then you can simply apply row owners to that email column and you won’t have to worry about adding any extra filters. Users will only see their own rows.
I initially tried it the way you suggested at first, but for some reason I wasn’t able to get the user email to transfer from the the Profile sheet. I went back in and added the columns you mentioned, redirected the form button to look at those cells and everything populates except the email addresses. I’m assuming that I needed to point the “User” column to Profile>User>Email…but I don’t see an option to do that.
The users email address should be added when the row is created. Refer to the below doc:
Thanks Darren. I never knew what those components were used for. I tried it but I didn’t get all of those fancy options like the link showed. (There isn’t an option to “update by email” Although it did seem to grab the email address, it still isn’t pulling the value into the sheet. And now the data is no longer showing up on my inline list. Sigh
So just so I understand, after you submit the form a new row is added to your Purchases table with an empty value in the User column?
That doesn’t sound right, because it looks like you have the form setup correctly.
Let’s set the Inline List aside for the moment, and get the form working correctly first.
I don’t know what happened, but when I changed the component from “Special Values” to “Values from User Profile” it seems to be working now. Weird bc I tried "Values from User Profile"after trying “Special Values” and it didn’t work. Seems to me there wouldn’t be a difference between the two. But it’s working now. However, my inline sheet is still blank.
Can you show me the configuration settings of your Inline List please?
Okay, just one last thing - are you still using a filter on the Inline List?
If you are, I would recommend removing it as per Jeff’s earlier suggestion, and apply Row Owners to your User column instead.
That’s a much simpler way to do it, and it has the added benefit of being more secure.
Sorry for getting back to you so late. Yes, I removed the filter from the Inline List and added Row Owner to my email column. Now it’s working pefectly. I just have to make some adjustments to my “Total Purchases” Rollup" column now, as it’s summing up everyone’s total together.