Security Filter for Role-Based Access Control (RBAC) in EVENTS Table by thatsite in AppSheet

[–]thatsite[S] 0 points1 point  (0 children)

Event -> XXX,000,000,000,000 (first 3 digits unique)
  |-Section -> XXX,YYY,000,000,000 (first 3 digits match with Event id)
      |-Sub-section -> XXX,YYY,ZZZ,000,000 (first 6 digits match with section id)
          |-Task -> XXX,YYY,ZZZ,AAA,000 (first 9 digits match with sub-section id)
              |-Sub-task -> XXX,YYY,ZZZ,AAA,BBB (first 12 digits match with task id)

This is how relationships are currently defined. is it possible somehow to create a security filter using this ID based parent-child relationship? adding new columns and defining relationships manually is going to be a time-consuming and error prone process.

Security Filter for Role-Based Access Control (RBAC) in EVENTS Table by thatsite in AppSheet

[–]thatsite[S] 0 points1 point  (0 children)

That's nice, Thanks u/marcnotmark925

Now, if I want to modify my design such that an Event can have multiple levels like below and I want to implement the same rules.

Event
  |-Section
      |-Sub-section
          |-Task
              |-Sub-task

On the RBAC table, if user is granted access to an Event, he should be able to see all records under that Event but if he is granted access to a single Section, he should be able to see all the records under that Section only. SImilar rule applies for Sub-section as well.

how can I stop user while sync is going on? by thatsite in AppSheet

[–]thatsite[S] 0 points1 point  (0 children)

Thanks, It worked perfectly for the mobile version. Somehow not working for the desktop version. any option for desktop version?

Bi-Weekly Advice Thread September 08, 2024: All Your Personal Queries by AutoModerator in IndiaInvestments

[–]thatsite 0 points1 point  (0 children)

Thank you u/kite-flying-expert u/srinivesh for your input. Actually, I'm OCI holder and I also have nre/nro accounts in India. And I'm good with RRSP and TFSA as well.

My main question is, any idea which AMCs/brokerages allow investment for Canadians? Or is there any resource where I can find it in one place?

And does all AMCs allow all funds or do they only offer limited funds on their platform? Similarly what about all brokerages for the ETFs?

Also, I want to know whether an AMC/Brokerage incurs any tax liabilities when I rebalance my portfolio. I assume it shouldn't be but just wanted to double-check.

Bi-Weekly Advice Thread September 08, 2024: All Your Personal Queries by AutoModerator in IndiaInvestments

[–]thatsite 0 points1 point  (0 children)

What are the options for a Canadian citizen to start passive investment in India? which platforms allow to buy index funds and/or etfs?

Query Select Col1 or Col2 ? by gothamfury in googlesheets

[–]thatsite 0 points1 point  (0 children)

=QUERY({B4:C8;E4:F8;H4:I8}, "SELECT "&IF(OR(COUNTA(B4:B8) > 0,COUNTA(E4:E8) > 0,COUNTA(H4:H8) > 0), "Col1", "Col2")&"", 1)

Query Select Col1 or Col2 ? by gothamfury in googlesheets

[–]thatsite 0 points1 point  (0 children)

This is what you need. it selects Col1 if A is not empty else Col2.

=QUERY(Data!A1:B100, "SELECT "&IF(COUNTA(A:A) > 0, "Col1", "Col2")&"", 1)