RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: All I want for Christmas!
@Jacques TUR True, as in this example where you can make a json from a select function with customized field names.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: All I want for Christmas!
@Fred try this: let t := this; let var1 := if field1 = null then first((select Table1[field1 = t.field1]).fullname) else first((select Table1[field1 = t.field2]).…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Formula diferent result
@Rafael 'Ganado REAL' is a formula field that displays % so you could use this: cnt(select DOCUMENTOS where number('Ganado REAL') = 30) Hope this helps.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Formula diferent result
@Fred 😄, just at the same time.😉
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Formula diferent result
Is Clase a formula? The code can be shortened, Can you try this plz : let cla := text(Clase); cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.Clase = cla)
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: The New IPhone Display Mode
@havrup Hi Niclas, Normally the button to switch between the 'modes' is just above the Rate Ninox button. Do you use the latest version of the iphone app? Current version is 3.5.14
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
@Jacques TUR @Fred True, they still have 10 Jobs open 😉Maybe a career switch Jacques?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and share
- Reported - view
Re: Choose more than one?
@John Halls @Lars It is actually not that difficult. If you want to limit the choices to 2 you can add this in the Writable if setting of the multiple choice field:…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Choose more than one?
@Lars you can limit the # of selected choices in a multiple choice.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: How to sort on multiple columns in interface?
@Mike Only one form for each table. But,... If you make different Tab elements in your form, you can kinda create different formlayouts per Tab, each containing their own fields.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: How to sort on multiple columns in interface?
@Mike https://forum.ninox.com/t/x2hr8j3 Maybe this helps.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Set another field's value from calculation?
Textfield := text(Formulafield) Or Numberfield := number(Formulafield) A trigger with a button is needed.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: How to display y data values on charts?
https://forum.ninox.com/t/h7hrmm9#x2hbksh Google charts?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: How to get max value + another column?
If the first part is correct, you can assign a variable to this select function and get the two values of the record: let i := max(select Cats).cat i.cat + " " + text(i.WeightDate)
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Include field content in Formula acting as a button.
styled("PROTOCOL NOT SET"+ xtrafield, "", "", "")
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Create JSON file for line items
@Mike Oh, sorry, didn't read your post in detail. Yes using a loop is a solution e.g.: let PJ := parseJSON(YourJSONdataField); for i in range(0, cnt(PJ)) do let id := number(item(PJ, i).…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Create JSON file for line items
You can also use a select funtion e.g.: (select invoices).{ desc : DescriptionField, date : format(Datefield, "DD/MM/YYYY"), name : NameField, adress :…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Fix 0 Value on Line Curve Graph
@Rafael Using following formula in a supplementary formulafield is the solution: if '% Acumulado Real' then '% Acumulado Real' else last(select Avances where '% Acumulado Real').…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Fix 0 Value on Line Curve Graph
@Rafael I'll check this tomorrow and reply to you.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem
@Rafael I'm not sure but on my computer with my formula (with 'or') in the formula, I get all the empty 'Ganado REAL' records and also the records between the two dates. Isn't this correct?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem
@Rafael so if 'Ganado REAL' is NOT empty, they may not be displayed? Only the empty ones may show? If so we have to change the 'or' to 'and' in all the codelines.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem
For the community's interest, I've placed a choice field (Fecha) above the view (No Emitidos) where the selection can be done which column to filter. Formula in view: let myFrom := 'Desde Fecha';…
- 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?
@Mike You need only: emp_fk := Employee.emp_PK in the trigger after update of your Employee - selection field.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
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

1 22 23 24 25 26 65

Welcome to the Ninox community

RoSoft_Steven

Re: All I want for Christmas!

Re: All I want for Christmas!

Re: Formula diferent result

Re: Formula diferent result

Re: Formula diferent result

Re: The New IPhone Display Mode

Re: add onselect event for view field

Re: Choose more than one?

Re: Choose more than one?

Re: How to sort on multiple columns in interface?

Re: How to sort on multiple columns in interface?

Re: Set another field's value from calculation?

Re: How to display y data values on charts?

Re: How to get max value + another column?

Re: Include field content in Formula acting as a button.

Re: Create JSON file for line items

Re: Create JSON file for line items

Re: Fix 0 Value on Line Curve Graph

Re: Fix 0 Value on Line Curve Graph

Re: Formula Problem

Re: Formula Problem

Re: Formula Problem

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

Re: Formula Problem

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

Overview