RoSoft_Steven's Profile | Ninox Community

Badges

Latest Posts

Re: Table printing: less rows in print than in view
It's normal in the print preview there are only some records visible but once you create the PDF all records should be visible. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Is it possible to link a 'field' to a 'table reference'
Maybe is this what you are looking for: https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/how-can-i-automatically-link-two-fields-from-two-tables-5c8cfc004a46f37365e3968f
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Is it possible to link a 'field' to a 'table reference'
Try this: first(select Customer where Customer.Email = WooCommerce_Customer_email) Steven.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Auto filling in of address fields
Something like this: if field = null then 'your formula' end then it will only update if the field is emty. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Comment Group, VLookup assistance
Thanks Karen for the compliments, it feels good and that's why we keep going. Don't miss this…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Comment Group, VLookup assistance
You're welcome, glad you found it.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Comment Group, VLookup assistance
just trying ... let s := upper('Search For');let n := first(select Source where contains(Short,s));'Group Name' := n.GroupName
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Comment Group, VLookup assistance
I see, is the search word always on the left? Then you could use this: let s := upper(substr('Search For',0,3));let n := first(select Source where Short like s);'Group Name' := n.GroupName Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Simple Log in system with date/Time registration.

Hi all, This is a simple login system with Date/Time registration. In the Startscreen there are some hidden fields and most of the code is in the Red Enter button.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- 5replies
- 2129
- Learn and share
Re: Question
I guess making an array of the iD's of the records and then select the last one - 1. let k := cnt(select Products);let l := select Products order by iD; let j := item(l, k-1);let m := record(Products,…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Comment Group, VLookup assistance
Made this. Formula is in the trigger after update of the 'Search For'-field in the Comments table. Also in the Source table the field short contains the upper formula to make input easier.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Comment Group, VLookup assistance
Well, it's not exactly in line of your case but what i do in this example is getting the name of the person with the corresponding logincode from another table. Have a look if you can use this idea.…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Best way to show "Created By", Modified By", "Created On" and "Modified On" on Forms and Views?
I think( i always go for that) formular fields are always real time .... they are not stored for each record and always recalculated when displayed.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Formulas
Algo assim? IMC := Peso/sqr(altura) Saudações Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: If statement not running
Found something interesting with the string() function. It gives back the hexadecimal value of a Multiple choice field. You can even manipulate the choice field by giving a hex value to that multiple…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: "This formula may not change the data."
just to understand your case more... What happens when you put a spiff file in an image field and then click on it? Does it opens VLC? In that case you could say like Image:= 'your .…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: If statement not running
Not even in the German-version site is it documented and not even in the German webinar team 0001_Ninox-Referenz database. Sometimes Ninox is difficult to fathom...…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Need help with IF / Then Statement in NX script
!= means is not null
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Need help with IF / Then Statement in NX script
Maybe this : if amID != null then Code... end (no use of the else) Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Set Background Color?
wellwell.. 🤔
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: iCloud sync
Sorry for my bad english, i mean Stand alone application which you also can use as cloud-version when you're logged in. Not sure where Icloud files are stored for sync (I think they are not…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: iCloud sync
I think the only databases syncked with icloud are those in your 'My databases' tab of the native app. steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Set Background Color?
Hi, when you create a tab and drag and drop this tab to the top in your 'edit fields' list, you can change the color and even the name of your form. Steven
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Auto-populate one field based on another
Oops , not compositions but 'Constraints' is the keyword.
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view
Re: Auto-populate one field based on another
Median issue here: https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/median-value-5b30296eb47ab5425dd1be25?post=5b3a517d7ae3710d101e86b2&page=1 Table relations here (composition is…
- Ninox partner
- RoSoft_Steven.1
- 6 yrs ago
- Get help
- Reported - view

1 52 53 54 55 56 65

Welcome to the Ninox community

RoSoft_Steven

Re: Table printing: less rows in print than in view

Re: Is it possible to link a 'field' to a 'table reference'

Re: Is it possible to link a 'field' to a 'table reference'

Re: Auto filling in of address fields

Re: Comment Group, VLookup assistance

Re: Comment Group, VLookup assistance

Re: Comment Group, VLookup assistance

Re: Comment Group, VLookup assistance

Re: Question

Re: Comment Group, VLookup assistance

Re: Comment Group, VLookup assistance

Re: Best way to show "Created By", Modified By", "Created On" and "Modified On" on Forms and Views?

Re: Formulas

Re: If statement not running

Re: "This formula may not change the data."

Re: If statement not running

Re: Need help with IF / Then Statement in NX script

Re: Need help with IF / Then Statement in NX script

Re: Set Background Color?

Re: iCloud sync

Re: iCloud sync

Re: Set Background Color?

Re: Auto-populate one field based on another

Re: Auto-populate one field based on another

Overview