Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Trigger after update record not triggered when linking/adding records to sub-table
You can use the trigger After hide of the tab element in your child table. If you don't have a tab element, you can add one in the first position where you can set up the trigger.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: The New IPhone Display Mode
@Fred On the Iphone, on top right is a gear. Clicking on the gear brings up the settings where you can switch between New design or classic design.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and share
- Reported - view
Re: New Record with prefilled date field
Hello, @Admin 1) You can use the above code in the "Trigger on new record" setting in the table. 2) If you want to use a button to create new record, then use this code:…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: New Record with prefilled date field
@Admin Try this: let d := last((select 'Snorkel / Sea Scooter Bookings').Date); Date := if d then d + 1 else today() end; let dS := datetime(date(Date),time(10, 0)); let dF := datetime(date(Date),…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: New Record with prefilled date field
@Admin The code I placed is to be used in the "Trigger on new record" of the table setting. If you want to use it in a button, then try this: let d := max((select 'Sight See Fish Feed / Marine…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: New Record with prefilled date field
let d := last((select YourTable).Date); Date := if d then d + 1 else today() end Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Colour Coding
@Admin Yes, You're right, I'm converting the formula field again to a number. number(text('10am Snorkelers')) should give you the number value of this field.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Colour Coding
@Admin you can eighter use let S := sum(Guests.Guestspresent) and use the variable S for the calculation or second option is to convert the first formula field to a number again :…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Note: Query values of function fields via REST API
@Karen Estrada The best thing you can do is send a request to support@ninox.com
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Colour Coding
There are several methods to achieve this, this is one of those: let S := sum(Guests.GuestsPresent); if S > 'Max Pax' then styled(text(S), "red") else styled(text(S), "green") end Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Info delete Field
@Alain Fontaine Thanks. Didn't thought about that. 👍
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Info delete Field
you can use this to make a field empty: Fechas := null If you want to do a selection at once you can use a loop structure like: for i in select yourTable do i.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Message - Improvement
You can use a flag "mail sent" ? Or a date field "send on"? If these would be true then don't send a mail... Steven.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Question new functions

Found some new functions in the .js files. Anyone knows what these functions do? createTempFile(string,string) and appendTempFile(string,string) or are these not yet implemented?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 2replies
- 167
- 1
- Learn and share
Re: Formula don't work
Using a select always gives an array of multiple records. You need to specify which record you need, like: first((select FechaCorte).DataDate) This gives the first record or if you need the last…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Sticky Messages or Tags
Count me in👍
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and share
- Reported - view
Re: help !!!
Is er nergens een filter toegepast op een kolom die nog actief staat? Als u in het formulier staat van die nieuwe record, kunt u dan naar de vorige records navigeren(deze die zogezegd verdwenen zijn)…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: How to import data from text field to dynamic choice field
It is not recommended to put the patients' names in a dynamic choice field because only 100 will be visible. It is better to use a linked table along with the other specs of that patient. Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: how do I delete values from a choice field
Andrew, have you the latest mac-version? 3.5.13 is the most recent. Some updates are not always shown, only if you go to the app in the app store like you would get info about it by clicking the icon…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Submit Button
I think you don't need to reffer to the parent table in subject: subject: "Tritec Tool Box Talk Record: " + 'Toolbox Talk Title Subject:', Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Submit Button
Hi Terry, To link the new created SignedList record to the current change your button formula to: let me := this;let p := (create SignedList);let t := TTRef;let s := 'Toolbox Talk Title Subject:';…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Alert message on CloseRecord
John, I tried to replicate it and I have the same strange behavior. This must be a bug, I will forward it to support. And yes, the updates are sometimes unpredictable but always innovative when there…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Alert message on CloseRecord
Strange. And if you manually set a Type value first and then use the bin icon(not the button), does it still popup? If not i guess the setting of the type is happenig on the server and deletion is…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Alert message on CloseRecord
John, Deleting the record is the same as leaving the TAB so it checks if the required field is present. If the case is that Type-field is empty then you also get the warning.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Order by desc
Maybe this will work: order by number(Dato)*-1 Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view

1 24 25 26 27 28 65

Back to top

Overview

View all topics