Skip to main content

Ninox-Documentation

Faz

Faz

Xstra Group

14
0
0

Joined: Wed May 15 22:58:18 UTC 2019

My Posts

Latest Posts

Re: Roles for Owner
and that workaround doesn't work for views
- Xstra Group
- Faz
- 4 yrs ago
- Get help
- Reported - view
Re: Roles for Owner
using readable if and writable if, you can explicitly include/exclude users by username or email address ... potential workaround - but then it isn't purely role-based
- Xstra Group
- Faz
- 4 yrs ago
- Get help
- Reported - view
Roles for Owner

Is there a way to explicitly grant permission to the owner? The owner doesn't seem to be able to have roles assigned ... if I set a table to be visible to admin only, the owner can't see it,…
- Xstra Group
- Faz
- 4 yrs ago
- 4replies
- 1527
- Get help
Re: Is there a way to allow a user to see some records but not others in a table?
In my case, I wanted a particular user to be able to only see records pertaining to them - so my formula is like record.person.name = myUsersName or userRole()="SuperUser" and it is working as I…
- Xstra Group
- Faz
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way to allow a user to see some records but not others in a table?
Grazie, that helped - for anyone else who is looking for similar - against the table you can use "Readable if" and "Writable if" : with a formula such as:record.…
- Xstra Group
- Faz
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way to allow a user to see some records but not others in a table?
... or is there a way to set a filter on a table that users can't change?
- Xstra Group
- Faz
- 4 yrs ago
- Get help
- Reported - view
Re: Somewhere to share user templates?
Thanks Birger
- Xstra Group
- Faz
- 4 yrs ago
- Learn & Share
- Reported - view
Is there a way to allow a user to see some records but not others in a table?

For example, if I add a customer as a user, could I make it that they can only view their invoices and not everyone elses?
- Xstra Group
- Faz
- 4 yrs ago
- 4replies
- 2100
- Get help
Re: Creating A invoice Number or Order Number
my pad function is probably over complicating, it was actually a part of something else I was doing in another process that I've just sort of stuck with ... Try this: let invNo:=max((select invoices).…
- Xstra Group
- Faz
- 4 yrs ago
- Get help
- Reported - view
Re: Creating A invoice Number or Order Number
Here are some of my global functions that may help you: function left(sourceString : text,leftLen : number) dosubstr(sourceString, 0, leftLen)end;function right(sourceString : text,rightLen :…
- Xstra Group
- Faz
- 4 yrs ago
- Get help
- Reported - view
Re: Somewhere to share user templates?
Hi Jörg, Could I get an invite too pleaseRegardsChris
- Xstra Group
- Faz
- 4 yrs ago
- Learn & Share
- Reported - view
Re: Lock color field on iphone
found a workaround - hide the color field and display it in a formula
- Xstra Group
- Faz
- 4 yrs ago
- Get help
- Reported - view
Lock color field on iphone

I am trying to lock a color field - it works on the web browser, but on the iphone the user can always change the color I have set criteria in WritableIf and set the WritableBy to admin - and a user…
- Xstra Group
- Faz
- 4 yrs ago
- 1reply
- 856
- Get help
Re: Search should search the whole field and not just the begining
the work around is to use an index function ie index('hello', 'll') would return 3, so you can search like:(select TABLENAME)[index('FIELD NAME', 'SEARCH TERM')>0]
- Xstra Group
- Faz
- 4 yrs ago
- Learn & Share
- Reported - view

Back to top

Ninox-Documentation

Overview

View all topics