Get()

So, with Ninox's new get() I could do: get(this,"First Name") However, what if I would like to look up the table and field? Could I do something like get(tableFind("Table Name",recID),…

Multi-Choice Menu Style Adjustment

I have a multi-choice menu (see attached). Is it possible to manipulate the code for this particular field to either hide the (all) button or change its action to select a specific value?

Dynamic Choice/Multi-Choice

Hello, Is it possible to add a list item to a dynamic choice within the Dynamic Value code section? For example, I have: (select Building where Entity = ent) order by Entity.…

• Answered

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