Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Display value from unlinked table
Using the select() function can give you the wanted results i guess: last((select Currency.RATES).RATE) or something like: last((select RATES [Currency = USD]).RATE) Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: add an image to the body text in SendEmail
@Mel Charles @Alan Cooke (And @support) 😝 Ninox support have come back and said - currently it is not possible to make this work :😟 This code works with me: let sha := shareFile(record(Settings,1).…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: sibling tables
@UKenGB said: Unlike SQL, one cannot specify the fields/columns returned. Yes you can return a Json-formatted list using a select function and even specify custom names to the fields: let x :…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: sibling tables
@UKenGB can you post a sample database we can work on ? Or screenshots of what you mean? Are the number of records the same in both childs c1 and c2? The only thing they have in common are the…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: [HELP] Ninox Can't Perform Basic "Sumif" Function
You can shorten the first part like: sum('Line Items'.'Item Cost') since the line items is a child table. If this gives the right result but the second doesn't, then for the second formula try :…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Storage Full
Maybe contacting support@ninox.com if they temporary can raise the limit so you can make backups.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: need help with the replace function!!
Change let myText := myRichText; to let myText := raw(myRichText); Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Search by Suppier from a Choice field
@Rafael Oops, my mistake, glad you get it to work. Thanks.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Search by Suppier from a Choice field
Not sure what the field Clave does but looking at your screenshot you might want to try: let search := lower(Supplier); select DB where lower(text(Proveedor)) = search Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: add an image to the body text in SendEmail
I gues you can use the function shareFile() on your imagefield and use this in your body like kinda displaying an image in html page.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Global Change (yes / no) field
You can make a button or use the "Update multiple records..." in your table view. With a button as example : for i in select Table1 do i.(yes/no := true) end Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Reference Manual
It is also present on the EN Webinar Team. 😉
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and share
- Reported - view
Re: Diacritic (¨/ ^ / é / ù ...) and failling researches
I came across this post, maybe this can help you: https://forum.ninox.com/t/h7hrmz2
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Track selection of Dynamic Multiple Choice field
Thanks @Fred , Always fun and appreciated when someone exchanges ideas. It would be even nicer if there were a sample database shared with the community. Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and share
- Reported - view
Re: "Join" script function will not show line breaks
Building +" "+Street address+" "+City+" "+County+" "+Postcode+" "+Country I use something like this in a formula field. Make sure the height of that formula field is high enough to display the…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@Sean I think it can be done with the eval() function (Haven’t try it though). let code:= “record(“+ FieldContainingYourTablename+”,number(extractx(text(i),””\d.*””)))”; eval(code,this) Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger on Open....
@Mel Charles thanks Mel 👍
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger on Open....
@Mel Charles Strange, this must be a bug... Does it continue to work after you reopened your database in the first tab or do you have to reopen every time?…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Meters
This one could also be of interest: https://www.dropbox.com/s/7yq86u5ftd9qm42/098_SVG_Progressbars.ninox?dl=0 Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Meters
@Rafael I've created this database, so I can share it with you. https://www.dropbox.com/s/q04vqds5l53tjlw/093_HTML_SVG.ninox?dl=0 Steven.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger on Open....
You could use the 'trigger before' view of the TAB element.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Meters
Code to copy/paste.....😉 html("<html> <head> <script type=""text/javascript"" src=""https://www.gstatic.com/charts/loader.js""></script> <script type=""text/javascript""> google.charts.…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Meters
@Rafael @Mel Charles It is possible with google charts to use their gauge: https://developers-dot-devsite-v2-prod.appspot.com/chart/interactive/docs/gallery/gauge Is this something you can use in…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: CONSTRAINT
@Rafael Weird, it works on my ipad with like: Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: CONSTRAINT
@Rafael The constraint of your ACTIVITIES_Line field should be: a.Product_Line.Line like b.Product_Line.Line Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 1
- Get help
- Reported - view

1 20 21 22 23 24 65

Back to top

Overview

View all topics