RoSoft_Steven

RoSoft_Steven.1

Ninox partner

Belgium

1589
211
5

Joined: Sun Sep 30 17:18:00 UTC 2018

https://www.rosoft.be

My Posts

Latest Posts

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
- 5 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
- 5 yrs ago
- 5replies
- 2105
- 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Formulas
Algo assim? IMC := Peso/sqr(altura) Saudações Steven
- Ninox partner
- RoSoft_Steven.1
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Set Background Color?
wellwell..
- Ninox partner
- RoSoft_Steven.1
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Auto-populate one field based on another
Try number(Field1)*number(Field2) maybe that will work Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Automatic updated field with date for each time I update something
Hi, check here:…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Support nested if
Hi, Have a look here in the manual under the section 'Making decisions': https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language For examples you can also have a look at the…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How I can prevent duplicate records being added?
To delete it in the script you can use: delete this Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: How I can prevent duplicate records being added?
@ Wolfgang, where did you put your script? In the Trigger after update of the 'Field' is the right place. try using =2 instead of >1 in the script. this works for me in the webapp windows 10 chrome.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: CRM DB
What did you have in mind Stephen? If it's not too extensive, I'll make one for you. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Map image with location field?
Hi, have a look here:https://developers.google.com/maps/documentation/javascript/get-api-key It seems like you'll gona need a payed subscription in order to get an api key. Steven.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view

1 51 52 53 54 55 64

Welcome to the Ninox community

RoSoft_Steven

My Posts

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

Re: Auto-populate one field based on another

Re: Automatic updated field with date for each time I update something

Re: Support nested if

Re: How I can prevent duplicate records being added?

Re: How I can prevent duplicate records being added?

Re: CRM DB

Re: Map image with location field?

Overview