About AGairAdmin

AGairAdmin · 04-17-2022

I have a table that contains product inventory transactions. and I'm having trouble getting the expression right, I've watched all the app sheet training videos and webiars on it, but i just can't get it to function, it doesn't split out the product ...

AGairAdmin · 04-11-2022

my app has some tables that need security filters that are not related to the useremail() ,i have a table called "users table" , it contains the "Email" and "company key" I'm trying to get the security filter to look at the "useremail()" then 'Users ...

AGairAdmin · 04-11-2022

i have a table with 2 columns, "company name"(EnumList) & "Company Key"(text), the user selects "company name" and then "company key" is filled out automatically and the user can't edit it. --------------------when both company name and company key w...

AGairAdmin · 03-10-2022

user filling out a formi have 2 tables and 2 columnsTable 1 = Company table / Company name , Company KeyTable 2 = User table / Company name, Company Keyadding a record to table 2 "user table" "Company name" column = Valid_IF , references column "comp...

AGairAdmin · 03-10-2022

Security Filter App is multi company app, other companies don't need to see other company data. On the "user table" , there is a column named "Company" (there is a admin table that contains the company data and unique key for the company row) i would...

AGairAdmin · 04-17-2022

i have made the slices , and they are displaying the products, but the products are staying in their groups and not sum up , like 2 product names with separate but correct qty @Joseph_Seddik

AGairAdmin · 04-17-2022

@ChristianLi how would i get the data copied over the to the unique table or would I tie the unique table to the transaction list and then make the virtual columns?

AGairAdmin · 04-11-2022

i don't have any other filters or slice row filters yet, this is the first one. 3 Tables -Users-Company Employees-Equipmentcommon columns-Email-Company Keyfor the table "Equipment list" I would like to set the security filter to show only matching "c...

AGairAdmin · 04-11-2022

This expression seems to have worked SELECT(Company table[Company Key],IN([Company Name], [_THISROW].[Company Name]))

AGairAdmin · 04-11-2022

would it require doing IN([Company Name], LIST(Company table[Company Name], Company table[Company Key]))then a IF() function to return the company key if true? I'm able to get the EnumList of company names to list properly with a comma between themex...

My Stats

AGairAdmin's Bio

Badges AGairAdmin Earned

Recent Activity

Having Trouble calculating inventory in and out on a table

Security Filters and Slice Filters conditions miss match

expression error enumlist & related table

Valid_IF selection list and related column

Security Filter related to a column on user table

Re: Having Trouble calculating inventory in and out on a table

Re: Having Trouble calculating inventory in and out on a table

Re: Security Filters and Slice Filters conditions miss match

Re: expression error enumlist & related table

Re: expression error enumlist & related table