RoSoft_Steven's Profile | Ninox community

Badges

Latest Posts

Re: Button to save a pdf when multiple print layouts are available
I would suggest to use a choice field, for example 'PrintLayout' with exactly the names of your printlayouts. Then use something like this in your PRINT button: let lay := text(PrintLayout);…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: MultiLine Text field with multiple rows alongside in form
@Bernd Krell Is the field called "Notes" or Note" ? Maybe that's the reason?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: date change
Did you report this to support@ninox.com already? Seems like a bug. can you report back what the solution was here please?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Can't see records, while they can be searched and found...
@Bas Jansen Can you post your data model and any fields to learn more about your database?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Avoid new records
This can only be done by using the user role permission in the 'Create new records' setting of your table. Which is only available in cloud subscription.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Avoid new records
If you only want one record in a table (for example if you use a "Settings" table) , you can use 'delete this' (without the quotes) in the "trigger on new record" field of your table.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Filtering data based on manual dates entered.
Try this: count(select Clients ['Pretrial Termination Date' >= startDate and 'Pretrial Termination Date' <= endDate and 'Termination Reason' = 1])
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Upload file to Ninox via API
Maybe these videos will help you: https://www.pscp.tv/NinoxDB/1eaKbQrjbnkxX Steven
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: New record code needing a tweak
Does changing the last line in your code to: popupRecord(newRec,"INPUT") works for you?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: erase, remove a date from a date field
Event_date := null "null" makes the field empty.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
Does this gives the correct result?: count(Clients['Termination Reason' = 1]) + count(Clients ['Termination Reason' = 4]) + count(Clients ['Termination Reason' = 6]) You can even expand to…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Code the top search - Help
@Jarno Vande Walle I see in your code the first 'Datum' is not converted with the date function, maybe that's the reason.
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Code the top search - Help
@Jarno Vande Walle Try this formula: let xBeg := Begindatum; let xEnd := Einddatum; select Prestaties where date(year(Datum),month(Datum),day(Datum)) >= xBeg and date(year(Datum),month(Datum),…
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
Re: Custom HTML Dashboard
Thanks for sharing! Looks very good!
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Learn and share
- Reported - view
Re: add an image to the body text in SendEmail
@Mel Charles Did this work out for you?
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Get help
- Reported - view
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 number…
- 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

1 20 21 22 23 24 66

Welcome to the Ninox community

RoSoft_Steven

Re: Button to save a pdf when multiple print layouts are available

Re: MultiLine Text field with multiple rows alongside in form

Re: date change

Re: Can't see records, while they can be searched and found...

Re: Avoid new records

Re: Avoid new records

Re: Filtering data based on manual dates entered.

Re: Upload file to Ninox via API

Re: New record code needing a tweak

Re: erase, remove a date from a date field

Re: Formula to Include Multiple Filters from Choice Fields

Re: Code the top search - Help

Re: Code the top search - Help

Re: Custom HTML Dashboard

Re: add an image to the body text in SendEmail

Re: Display value from unlinked table

Re: add an image to the body text in SendEmail

Re: sibling tables

Re: sibling tables

Re: [HELP] Ninox Can't Perform Basic "Sumif" Function

Re: Storage Full

Re: need help with the replace function!!

Re: Search by Suppier from a Choice field

Re: Search by Suppier from a Choice field

Re: add an image to the body text in SendEmail

Overview