RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Formula Problem
@Rafael there is a solution for that, if I understand you right, you want the view "No Emitidos" to be dependable of a button yes? I would use a choice field for that.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: How to update a field with a lookup value from another table?
By placing a := instead of a = := is used to assign a value to a field or variable = is to compare two values.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem
@Rafael let myFrom := 'Desde Fecha'; let myTo := 'Fecha Corte'; select Documentos where 'Ganado REAL' = null and FechaR1 >= myFrom and FechaR1 <= myTo Should give the right results.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem
@Rafael select Documentos where FechaR2 >= myFrom and FechaR2 <= myTo and 'Ganado REAL' = null Does this gives the wanted result? Not? The try first with select Documentos where 'Ganado REAL' = null…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Formula Problem
@Rafael can you try with text('Ganado Real')=null does this work?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: How can I set up two fields, one showing date/time record was created, one showing date/time of last modification?
@Lorenzo Milani Yes your're right, didn't know that was your question. I have a solution/trick for your case: If you want to monitor for example a field called "Input" ,…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: How can I set up two fields, one showing date/time record was created, one showing date/time of last modification?
@Lorenzo Milani Only put _cd or _md in a formula field. _cd for creation date and _md for modification date.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: HTML text format doesn't work in view print preview
@bflack You are right if html is used in the printeditor, the shown result is ok but once PDF created, the styling is lost. About using the Richtext fields, they are basically html.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Populate a Related field
@Rodrigo Cuenca Using select functions always gives an array, no matter how many records there are (yes even 1) Using the first() function will give you the right result.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Not to update a field after completed
@Rodrigo Cuenca In the settings of the field is a setting "Writable if:". There you can use this formula: Textfield = null or isAdminMode() With this, the field is only writable if the field is…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
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

1 23 24 25 26 27 65

Welcome to the Ninox community

RoSoft_Steven

Re: Formula Problem

Re: How to update a field with a lookup value from another table?

Re: Formula Problem

Re: Formula Problem

Re: Formula Problem

Re: How can I set up two fields, one showing date/time record was created, one showing date/time of last modification?

Re: How can I set up two fields, one showing date/time record was created, one showing date/time of last modification?

Re: HTML text format doesn't work in view print preview

Re: Populate a Related field

Re: Not to update a field after completed

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.

Overview