Bas

Joined: 12 Jan 2019

My Posts

Latest Posts

Re: How to make the fields in print preview editable (for data entry).?
Hi Jörg, Please invite me as well. Thanks a lot, Bas
- Bas
- 5 yrs ago
- Get help
- Reported - view
Parse date(today) into a fixed - user local independent - format?

Dear All, 1) How can you ensure that the output of function today() is independent from the user local? I get different formats of the same date depending the date format settings of the user.…
- Bas
- 5 yrs ago
- 1reply
- 1,142
- Get help
Display or hide button based on View(Form)?

Dear All, Is it possible to hide a button based on the name of a View (Form)? I have 1 table with let’s say Button 1A and Button 1B. This table has multiple "Views".…
- Bas
- 5 yrs ago
- 1reply
- 1,452
- Get help
Change field colour based on multiple if then else

Dear All, Any idea why the following code results in the error: if 'Current Inventory' > 'Total Count' thenstyled("Inventory is SMALLER", "#ddeeff", "green", "dialog");…
- Bas
- 5 yrs ago
- 1reply
- 917
- Get help
Re: How to make a kind of genealogic tree ?
Hi there, Do you already know about the possibility of "Composition Tables"? -Bas
- Bas
- 5 yrs ago
- Learn and share
- Reported - view
Re: Parsing records from 1 table to another
Hi Sean, Just to make sure I am following you on a conceptual level, I created this very elimentary draft... You would then set up a Trigger after update for the field "Raw Input" that would contain…
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing records from 1 table to another
Hi Sean, Just to make sure I am following you on a conceptual level, I created this very elimentary draft... You would then set up a Trigger after update for the field "Raw Input" that would contain…
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
Dear Sean, It works wonderfully. This is so great! I also had a look at why you used concat and replace / how this does work; and it makes so much sense now...…
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
https://we.tl/t-RjKiKnnFh6 I called the formula "Keep trying" ;).
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
Here's the DB.
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
join('A) Project Items'.'C) Materials Used'.text(Quantity) + "KEEP GOING" + 'A) Project Items'.'C) Materials Used'.text('Single Price'),"SEPARATOR")
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
Would you like me to upload the database example?
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
Thanks for your immediate reply; very much appreciated... And exact copy paste still gives an error. I don't really understand what it is trying to say.…
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
Sean, thanks for your fast reply. Are you referring to the "code example" or the "actual code"? I removed ) for both; the formulas compile without error,…
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
Well spotted Sean! I have tried the following: join('Project Items'.'Materials Used'.'Article Name', "");join('Project Items'.'Materials Used'.text(Quantity), "");join('Project Items'.…
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing records from 1 table to another
Hi Sean, Thanks for thinking a long. The idea is that the operator would use a barcode scanner to scan products and also scan their associated quantities.…
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing records from 1 table to another
Any ideas? Thanks, Bas
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: Anybody else having issues logging into Ninox site using Chorme today?
*at my end (Also, is it possible to edit my comments after uploading them?)
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: Anybody else having issues logging into Ninox site using Chorme today?
No issues on my hand. At least; none related to the use of Chrome for Ninox ;).
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
Dear All, Any idea if you can replace the comma between parts with a "space or line break" instead? Here's the original code: join('A) Project Items'.("Subproject:…
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: Linking between databases
Hi Sarah, Just to be sure; these 5 offices would still work independent? As in; they don't need to see info from each other? You only want to make sure that Production of Office 1 has different…
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing records from 1 table to another
PS Here's a link: https://we.tl/t-dd9ycraYib PPS What is the best way to share files on this forum?
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing records from 1 table to another
Dear All, Please find attached a database that contains above information. I hope that helps. Thanks again, Bas
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: Print view: invoice form calculations
You are very welcome Joyce (I am just paying it forward :)). If not, shoot. Good luck and have fun, Bas
- Bas
- 5 yrs ago
- Get help
- Reported - view
Re: How to make the fields in print preview editable (for data entry).?
Hi Westy, Just to be 100 procent sure; you would like to work as follows? -Recreate the proprietary forms in Ninox (in exactly the same way)-Hand out access to these forms to the people that would…
- Bas
- 5 yrs ago
- Get help
- Reported - view

1 2

Welcome to the Ninox community

Bas

My Posts

Re: How to make the fields in print preview editable (for data entry).?

Parse date(today) into a fixed - user local independent - format?

Display or hide button based on View(Form)?

Change field colour based on multiple if then else

Re: How to make a kind of genealogic tree ?

Re: Parsing records from 1 table to another

Re: Parsing records from 1 table to another

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: Parsing records from 1 table to another

Re: Parsing records from 1 table to another

Re: Anybody else having issues logging into Ninox site using Chorme today?

Re: Anybody else having issues logging into Ninox site using Chorme today?

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: Linking between databases

Re: Parsing records from 1 table to another

Re: Parsing records from 1 table to another

Re: Print view: invoice form calculations

Re: How to make the fields in print preview editable (for data entry).?

Overview