[URGENT] Am unable to see rows, addressed to me as...

Simon_Mukabana · 12-22-2020 01:56 PM

I have a quotation approval app, with a table called quotation which has Requestor Column(email)- a user email requesting for approval, Project lead column (email)- for any an app user who can see approve, deny action on the submitted quotation, and other columns.

Challenge
A project lead(user), I can see all quotations rows submitted to all other project leads. But I can’t see row data of quotations that have been submitted to me for approval.

Currently, there are no security filters set on data, no row filter set on any slice views.

Anyone with the solution?

LeventK

All project leads (users) can see all approval requests?

Simon_Mukabana

They can see all approval requests of other project leads but not theirs.
Like if am the project lead, am able to view approval request of other project leads(users) but not mine; Exactly opposite of what I want to achieve, In the long run. I need to filter out and view only my requests

LeventK

Simon_Mukabana

Thank you @LeventK,
I removed all security filters and any other limit to data, since the rows that I need to view as a project lead are not Visible.

The strange thing is when I view data

Am able to see those records using my account as a project lead.

I don’t know if that makes sense

Simon_Mukabana

But in the app nothing is displayed.

MultiTech

This might be of help:

Simon_Mukabana

And all project leads and Requestors are users in this case, when filling out the quotation ,Requestor field is automatically assigned useremail()

LeventK

And so?

Marc_Dillon

I’d suggest providing screenshots of what you see in the app, how your tables and columns are setup, show us that security filters and slice row conditions are indeed blank. Hopefully it will uncover something for somebody to identify the issue, because it doesn’t make any sense so far.

Simon_Mukabana

Okay.

This my table

sample data here
No security filter
This is the slice for pending quotations, where Approval status =“Pending” and Project Lead=USEREMAIL()
This is the result I get when I view as a project lead.

Am getting this one record because I used the same account to submit the quotations.
I should get this data?

Marc_Dillon

Looking at the last screenshot you posted, I see a discrepancy between the emails in [Requestor Name] and [Project Lead], that are otherwise the same… @incentro vs @incentroafrica.

Do you log into the app with 2 different accounts?

Also a bit of advice that may help you later. Instead of putting USEREMAIL() in as the app formula for [Requestor Name], put it as the Initial Value, and turn off edit capability. Otherwise this value will change to whoever was the last person to modify the record.

Simon_Mukabana

Thanks @Marc_Dillon
They are two different accounts and both have access to the app. I logged in as xx@incentro.com to make a requisition. and as xx@incentroafrica.com to view all requisitions sent to me. I have added a workflow and as a project lead am able to receive an email but I can’t view the quote.

Thanks for the advice, I have changed to initial value instead of app formula

[URGENT] Am unable to see rows, addressed to me as a project lead for approval