RoSoft_Steven

RoSoft_Steven.1

Ninox partner

Belgium

1544
197
4

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

https://www.rosoft.be

My Posts

Latest Posts

Re: Question
Oneliner: sum((select Reservations where month('Date & Time') = 7 and year('Date & Time') = 2021).'Total Fees'); Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Loops syntax
Strange, the second should also work I think.... If you try: ----------- for i in range(0, xTotalMatchingRecords) do item(Table.Field, i) end ----------- does this work? And by the way,…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Loops syntax
The last time your loop is run you add 1 more to the counter XCount. Maybe using a select command would be more advised: cnt(select Table [conditions]) Is this the whole set of your code we see above?…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Filling Lines of Orders/Articles with Dynamic Multiple Choice Fields And Cascading Dynamic Choice Fields.
Thanks Nick & Sean, Yes, it's GIF, but the max size you may upload at once is 2MB so i had to post a picture of the second instead...
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and Share
- Reported - view
Filling Lines of Orders/Articles with Dynamic Multiple Choice Fields And Cascading Dynamic Choice Fields.

In this database you can fill order lines with Dynamic Multiple Choice Fields and Cascading Choice Fields. It is located in the EN Team webinar and is called Cascading DCFields. Steven
- Ninox partner
- RoSoft_Steven.1
- updated 2 yrs ago
- 5replies
- 1202
- 1
- Learn and Share
Re: Fonts, Colors and Borders
Nice, thanks Sean.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and Share
- Reported - view
Re: VIEWING IMAGE SIZE
There is a formula now, use this example in a formula field to display the size of the image along with the name of that image: let k := index(text(item(files(this), 0)), "/") + 1;let n :…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: WhatsApp and Viber formula
Does this code goes in a button? Then openURL("viber://pa?chatURI=<https://msng.link/o/?"+Mobile+"=vi>") might work or openURL("https://viber://pa?chatURI=<https://msng.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: WhatsApp and Viber formula
Maybe this will work: (not sure about the use of text() here or where this code goes in your usecase) text("viber://pa?chatURI=<https://msng.link/o/?"+Mobile+"=vi>") If you want to embed a field in a…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: WhatsApp and Viber formula
As I see it in your screenshot, your phone-field is called Mobile, so your formula should be: openURL("https://wa.me/" + Mobile + "?text=This%20is%20a%20message") Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Scrip to unlink table
This would work without the +sign: 'Show something' := true ; ChildForm:=0 so to have another line of code you must use ; (semicolon) Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: I’m doing a questionnaire
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: I’m doing a questionnaire
Best practice is to use choice-field i guess
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: I’m doing a questionnaire
Are they Multiple choices? Then you get wrong number (Hex Values)
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: I’m doing a questionnaire
I see you put the 'Agree' first in line, then you can use: if Choice then 6 - number(Choice) end to get the right value. To sum your values you can add your formula-fields. e.g.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: I’m doing a questionnaire
If you have a choice field with choice values starting from Disagree down to Agree. So the first option is Disagree and the fifth option is Agree. Using number(ChoiceField) would give you the number…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Serious?

Are you kidding me? more than 230 pages spam.... I've given up on 230... who knows how many more there were...
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1reply
- 179
- Get help
Re: Have field remain blank if sum is zero
if 'PO COST' + 'SC COST' then 'PO COST' + 'SC COST' end Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: How do you make a multiple choice into a number in a separate text box?
cnt(chosen(multiplechoice))
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: How do you make a multiple choice into a number in a separate text box?
see also: https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/multiple-choice-facts-5f6cebdb496de40e7f818b1d Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: How do you make a multiple choice into a number in a separate text box?
numbers('Multiple Choice')
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Execute eval() in triggers
The same problem here, cloud-version-Triggers of fields are unpredictable, sometimes the code works and sometimes not. The same code in a button does work.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and Share
- Reported - view
Re: Doppelte Einträge finden
Frank, Maybe this helps: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/how-i-can-prevent-duplicate-records-being-added-5b7697059efc8227533e7d76?page=3 Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
The way Ninox displays images in a formula field is changed?

When I call an image from another table -> record(Settings,1).Imagefield) - they used to be small. Now they are bigger with the new release? Can somebody confirm this? Solutions? Thanks, Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1reply
- 384
- Get help
Re: issue trying to get a table view to work in a non related table
Although John's solution is the neatest, to understand your formula, this also works: let me := CustID;select Quotes where CustID = me Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view

1 26 27 28 29 30 62

Welcome to the Ninox community

RoSoft_Steven

My Posts

Re: Question

Re: Loops syntax

Re: Loops syntax

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

Re: Fonts, Colors and Borders

Re: VIEWING IMAGE SIZE

Re: WhatsApp and Viber formula

Re: WhatsApp and Viber formula

Re: WhatsApp and Viber formula

Re: Scrip to unlink table

Re: I’m doing a questionnaire

Re: I’m doing a questionnaire

Re: I’m doing a questionnaire

Re: I’m doing a questionnaire

Re: I’m doing a questionnaire

Serious?

Re: Have field remain blank if sum is zero

Re: How do you make a multiple choice into a number in a separate text box?

Re: How do you make a multiple choice into a number in a separate text box?

Re: How do you make a multiple choice into a number in a separate text box?

Re: Execute eval() in triggers

Re: Doppelte Einträge finden

The way Ninox displays images in a formula field is changed?

Re: issue trying to get a table view to work in a non related table

Overview