About mirzaei

mirzaei

Hello everyone,I have a table called Quotes and 4 Sales reps who each can only see their own quotes. This table has a key column called [Quote ID] with initial value of MAX(Quotes[Quote ID])+1. Problem is that in this formula MAX expression applies o...

mirzaei · 04-07-2024

I recently deployed an app with 10 users and I'm facing an issue after launch. I have a table called Quotes, in which there's a column called Sales rep with type "ref" and initial value USEREMAIL() and not editable. The Sales rep column is referenced...

mirzaei

Yes, I figured. Thanks for sharing the article.

mirzaei · 04-08-2024

Yes, I can see in the cell history that initially the wrong (random user's) email address was added and then I have to manually edit it. I put the screen shots here for your reference.

mirzaei · 04-08-2024

No automation bots has been implemented, neither any action on save. Also, I'm simply using USEREMAIL() as initial value for the [Sales rep] column. No ANY(SELECT()) has been used.

mirzaei · 04-08-2024

Hi AleksiUnfortunately there are only 2 archived versions of the table for the whole day and I don't find a version in which the wrong email address was captured. We edited the Sales rep column after we it was wrongly saved and I don't see the versio...

mirzaei · 04-07-2024

Exactly! So I have a row in the table in which the last modified column is "Date_Time by correct users's email" but the Sales Rep column with initial value USEREMAIL() populated by another random user's email address. Please note that I have made the...

My Stats

mirzaei's Bio

Badges mirzaei Earned

Recent Activity

Using MAX() + 1 for ID number causes row overwrite

USEREMAIL() captures another user's email address

Re: Using MAX() + 1 for ID number causes row overwrite

Re: USEREMAIL() captures another user's email address

Re: USEREMAIL() captures another user's email address

Re: USEREMAIL() captures another user's email address

Re: USEREMAIL() captures another user's email address