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

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