RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Delete record if fieldA := fieldB
@Gianluca It seems to me it's a BUG, I've tried it a moment ago myself and my code doesn't work eighter.(I'm using webbrowser) First my textFiscalcode field was't updated eighter but when creating…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: database wide variables
@Dariel There are videos on youtube by Nioxus explaining Global functions and variables : https://www.youtube.com/watch?v=psPLrRX2_AA&t=749s Hope this helps.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: database wide variables
you can use the "global script definitions", located in the Options - TAB when you are in ADMIN-mode. these are database wide accessible.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Delete record if fieldA := fieldB
@Gianluca 1.) I would dismiss the formula field you're using now and create a static textfield for that.(In this example called txtFiscalCode) 2.) Use the trigger after update of your Birthplace…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Delete record if fieldA := fieldB
@Gianluca You’re right. It must be triggered. Maybe, if you can,using a trigger after update somewhere?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Delete record if fieldA := fieldB
delete this is the code to delete current record
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Merging RTF Fields
@Louis Cornacchia Rtf3 := raw(Rtf1) + raw(Rtf2) this copies 2 rtf-fields (Rtf1 and Rtf2) into a third Rtf3 field.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: sum( where) help needed
👍
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: sum( where) help needed
@Michael Chung let xYear := year; sum((select Invoices where year('Invoice Date') = xYear).'Grand Total') I suppose year is a numberfield? If not then you might want to use todays year?…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Character Occurrences Count
@Lars Indeed, item() also works on strings.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: Save trial database work to my recently purchased Local Mac Ninox environment.
@Andreas I understand. I had also thought of your option and this is indeed a good way of doing this for your case.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Save trial database work to my recently purchased Local Mac Ninox environment.
@Andreas you are right, starter plan doesn't do that. I wonder if you invite me (as admin) to your team, if I couldn't make a download and send it to you.(I have prof. subscription) Not sure though.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Search view Formula don't work
Try: let yBusqueda := text('Busqueda Tipo Documentos'); select Documentos where text('Tipo de Documento') = yBusqueda I'm guessing the order of your choice field is not the same as your searchform…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Integromat "Webhook" Module: Bring the Ninox ID Record
Just add > ?RecID = text(Id) If you want to add more parameters split them with & Example:…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: What means these mensage.
It means there is some error somewhere. Go to that table and in design view (red wrench) click on the left icon "Edit fields" on the bottom. Then you get a list of all your fields.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Pie chart for a single record
Another approach is to use google charts. https://developers.google.com/chart Google Charts is open source and is free to use. Lots of different chart types possible!…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 3
- Get help
- Reported - view
Re: Filling Lines of Orders/Articles with Dynamic Multiple Choice Fields And Cascading Dynamic Choice Fields.
@Javier If you have a cloud subscription, you can ask support to be invited to that team. And while you're at it ask for an invitation to the Webinar DE 2022 team at the same time.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and share
- Reported - view
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

1 23 24 25 26 27 65

Welcome to the Ninox community

RoSoft_Steven

Re: Delete record if fieldA := fieldB

Re: database wide variables

Re: database wide variables

Re: Delete record if fieldA := fieldB

Re: Delete record if fieldA := fieldB

Re: Delete record if fieldA := fieldB

Re: Merging RTF Fields

Re: sum( where) help needed

Re: sum( where) help needed

Re: Character Occurrences Count

Re: Save trial database work to my recently purchased Local Mac Ninox environment.

Re: Save trial database work to my recently purchased Local Mac Ninox environment.

Re: Search view Formula don't work

Re: Integromat "Webhook" Module: Bring the Ninox ID Record

Re: What means these mensage.

Re: Pie chart for a single record

Re: Filling Lines of Orders/Articles with Dynamic Multiple Choice Fields And Cascading Dynamic Choice Fields.

Re: Trigger after update record not triggered when linking/adding records to sub-table

Re: The New IPhone Display Mode

Re: New Record with prefilled date field

Re: New Record with prefilled date field

Re: New Record with prefilled date field

Re: New Record with prefilled date field

Re: Colour Coding

Re: Colour Coding

Overview