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: How can I get the Id number of a record in a linked table?
Try this: let thistype :=first(select MasterListLabels['Label' = "Project"].Id); m.(Type := thistype) Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
@ Ninox Support: can you help us with that? Or anyone else...
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
I think your text field must be in the footer. Can you check that? Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Displaying external Dropbox images. The solution if your database contain many pictures to keep the database size small.

Pictures say more than words... Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- 24replies
- 4192
- 3
- Learn and share
Re: Have a Page number on the Print document
A possible hack is to increase the hight of the page in the print layout screen and afterwards set it back to normal. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
It's normal in the print preview there are only some records/pages visible but once you create the PDF all records/pages should be visible. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Have a Page number on the Print document
Add a text field with this:Page $page of $pages Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: If a text field has > 30 '#' then show alert
Sean, No problem at all, I'm not familiar with RegEx (I know you do, an I was already kinda expecting an answer from you ) so I gave an alternative solution. Steven.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: If a text field has > 30 '#' then show alert
Hi, Try this for the first question in a formula field: you can always add if r>30 then alert("message") end let r := 0;let k := length(Text);for i from 0 to k doif substring(Text, i,…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Simple Log in system with date/Time registration.
Thanks Michael, This is a small part of my POS system, where a new record is indeed created with the name belonging to the entered code. This way you can see who entered the orders.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Learn and share
- Reported - view
Re: Horizontal line separator in form
Or you can use a formula field and hide the label ,with this as formula: html("<hr>") in the style chose background rgb as above. Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Houw can I protect the database with a password
Or this: https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/simple-log-in-system-with-datetime-registration.-5e11d00509d132371a594f5c
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Houw can I protect the database with a password
Maybe this can help you? https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/template-for-password-protected-database-5c253469a92e630e863e2c64 Steven.
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Calculating a sell price in edit field without using a formula field
Mel, yes you can do this while adding new records in the trigger after update of the fields, but when you have existing records, they would not be updated, only when you change the value of a field.…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Filtering contacts from a specific client
Hi, have a look here in the topic 'Constraints' : https://ninoxdb.de/en/manual/tables/table-references-and-relations or do a forum search on constraint... Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Forumula fields justification
Steven
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Webinars
The webinars are free
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
Re: Count similar records in same table
Follow this: first make a variable with the content of the field First Name in your form. let c := 'First Name' then we count all the records in the Customer table with the same first name and make…
- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Get help
- Reported - view
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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Comment Group, VLookup assistance
You're welcome, glad you found it.
- Ninox partner
- RoSoft_Steven.1
- 5 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
- 5 yrs ago
- Get help
- Reported - view

1 50 51 52 53 54 64

Welcome to the Ninox community

RoSoft_Steven

My Posts

Re: How can I get the Id number of a record in a linked table?

Re: Have a Page number on the Print document

Re: Have a Page number on the Print document

Re: Have a Page number on the Print document

Re: Have a Page number on the Print document

Re: Have a Page number on the Print document

Re: If a text field has > 30 '#' then show alert

Re: If a text field has > 30 '#' then show alert

Re: Simple Log in system with date/Time registration.

Re: Horizontal line separator in form

Re: Houw can I protect the database with a password

Re: Houw can I protect the database with a password

Re: Calculating a sell price in edit field without using a formula field

Re: Filtering contacts from a specific client

Re: Forumula fields justification

Re: Webinars

Re: Count similar records in same table

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

Overview