Switch Case Statement: combine multiple cases with same code

I have a switch/case statement where I would like to combine "case 1:" and "case 4:" since both use the same if/then code (rather than duplicate the code in a separate "case 4:…

• Answered

is there a way to count number of item within a selection field?

I have a selection field and I wish to use to number of item inside to check if all those item are used in the table. For example: selection field = red, blue and green table entry:…

Formula field not displayed in table view

Hi guys, I've entered a valid Formula in Ninox that displays the result in the Form view. However, this result (only one) is not displayed in the Table view.…

Is it possible to disable sum symbol ∑ in Table view

I am using the free version of Ninox with the iCloud syncing functionality. I have a table with equipment and each piece of equipment has a price. When I have the price column activated with the…

Formula need

@Fred I need a fórmula on 'Spend Hours' field that adds the sum for each 'Activity Name' for Disciline cumulative, on 'History Hours' table here the name is 'Activity:…

accumulation

how can i make the same text do cumulative sum

Problem N:1 Activity_Name

@ Fred On Staff Hour table, I create Activity_Name (N:1 'Staff Hours' To Activitires) for select the Activity. With the Add Register button add the info to ' History Hours' but no find the way to…

• Answered

Delete a record and related records in other tables

I have a table named « Accounts » which is the main table where I add all my customers. From the Accounts table, I created a Yes/No field which has the mission of deleting the selected account…

Is it possible to copy/separate tables?

I'm still rather new to Ninox. I have one master table. I want to make multiple tables from the one table. For example: In my Master table I want to take all number 1's (which is one of my fields)…

Database Search

I am building a database for veterans listed on the memorial wall in my county. I am the only one who will build or edit the database. However, I do want the public to be able to search the database…

500 Internal Server Error

I have been using the rest API for months, but now all of a sudden I only get a 500 Internal Server Error for all my API requests. Anyone know whats happening? I created a new team and database,…

Help to figuring out work around for MacOS app

Hi all - For those with access to the MacOS app and a cloud subscription. Upload the attached DB to your cloud account and as a local DB. With the MacOS app: Start with the cloud DB.…

Three issues on the Dashboard

@ Fred @ John Halls @ RoSoft_Steven On Show Hours Year/Weeks, need to sort by year/week (yw) Field On Show Week Option The add of the Last 2 and 4 Weeks don't give me correct sum.…

• Answered

Trigger after open problem

I'm trying to do simple switch, but it looks like i cannot select database... select("Influencers") -----> without this i got "Field not found", but with i got an error of "identifier exepted" Status…

All-day 'Appointments'

I need to show events / absences in the calendar that are multi-day. The 'Appointment' field is, I think, the one that permits different start and finish dates.…

Database History

Does anybody know if it is possible to add additional information to the database history? At the moment it is only the table name and record id which is referenced.…

HTML/Rich Text does not work on print record

I've noticed that HTML and rich text do not display in the required format when printing a record. Instead, the text is displayed normally. Does anybody know a work around or whether Ninox plan to…

IMPORT AND SAVE IMAGE FROM URL STOPPED WORKING

I have been using this button to import image and files from url for months now, today it stopped working.

Multiple Choice field showing strange values

Hello Ninox Community, I have a ingredient inventory table with a (multiple choice) field displaying allergens. I also have a recipe table where the ingredients and amounts are added.…

Update a field in another table

Hi, I have a 'Parts of car' table, where after selecting for example the engine, I need to select the parts (in this case 1 part) which is necessary to repair the engine.…

Global Search Column Customisability

Does anybody know whether it is possible to customise the columns which show when you perform a global search? It seems bizarre if this has not yet been implemented,…

como eliminar registro duplicado en mi base de dato

como puedo eliminar registros con mi columna "clave" que se encuentra duplicado?

Issue with the 'select ... where...' function

Good morning ! I create a personalized address book in Ninox. For each company, there are several contacts and I need to display the names of the company's managers only.…

• Answered

Ninox API issue

Below am able to query the records But while trying to use `where` am getting `null` why ? ``` { "query" : "(select 'Klant_Client' where 'Skinvision_Customer_Id' = 'FX0000000108_412').…

Link multiple records to a parent record

Hi everyone. I develop a database for creating a schedule for trainings. I have table with clients' applications for trainings and a table with training groups dates.…