S Moore
-
Global Variable - Permissions (possible bug?)
Hi community, I have a global variable that is used to check field permissions. It is: function permCheck(permission : text) do let currentUser := first(select 'System User' where int_linked_user =…
-
Separating List into Objects
Hello, I have a list of items that are separated by commas: Objects = "Red, Blue, Green" I would like to convert them to objects, and loop through each object to see if a condition matches. Ex.…
-
Loop through Records
I am creating a user access module. System User User Group User Permissions None of these records are related. My goal is to use Dynamic Choice fields. So a user can be a part of multiple User Groups,…
-
Return JSON
Hello, I have this JSON data that is returned from a SQL select statement: {"result":{"recordsets":[[{"status":"Enabled"}]],"recordset":[{"status":"Enabled"}],"output":{},"rowsAffected":…
-
Replace array of items
Is it possible to utilize the replace() function with an array of options to check? Something like: replace('My Text', [ "Hello", "Goodbye", "Welcome" ], "Custom Message")
-
Loop Syntax Correction
Hello. I am having a bit of trouble with this for-loop, a syntax error and would love an extra pair of eyes on this, I basically have a 'Hire Date' field,…
- Answered
-
Bug in Ninox workdays() formula
As a member of the Ninox beta team, I am no longer sure where to report bugs. However, I did find a bug with the workdays() formula. According to https://docs.ninox.…
-
Multi-Choice (Dynamic) Field
Ahhh, Multi-Choice (Dynamic).... Truly a wild animal. I have a dynamic multi choice field to select multiple records in a table, staff. How do I get the Staff.…
- Answered
-
Code Simplification - Loop ?
Hello, I am trying to simplify this code let num := number(Deduction); let rec := record('Taxes/Deductions',num); let ths := this; if rec.Calculation then ths.(Calculation := rec.…
- Answered
-
Unique Value Formula
Hello, I am trying to create a formula to check for and correct a username to make it unique. Looking at https://forum.ninox.com/t/60hr83k, @Jörg mentioned something like this: let myField := Field;…
-
Dynamic Choice Field Assistance
I am having some trouble with a dynamic field: let ths := this; let thisUserDepartment := ths.Department.Id; let thisUserTitle := ths.'Job Title'.Id; (select 'WFM Permissions' where numbers('Eligible…
- Answered
-
Next Item in Line Formula
I am creating an approval flow in Ninox. I have a field named 'Current Step' and a list of that displays the order of the steps. Named 'Step Order' and the value is '1,2,…
- Answered