Sean

1762
79
0

Joined: Tue Jul 31 23:45:13 UTC 2018

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Switch syntax wrong?
You were close. I didn't know you could combine actions in the case sections until now. Here's what I got to work... switch text(Choice) docase "A":Number := 1 + (Text := "A")case "B":Number :…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: "Display field only, if" multiple-choice field is = 1
That would be quite a switch statement. I'm not a math wiz, but there would a lot of possible combinations with just 5 items in your multiple choice field.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing records from 1 table to another
Bas, This is an example using Trigger on create... if not contains(text((select Table1 where Id = number(last(select Table1).Id) - 1).Text), "Art") thenlet newRec := (create Table2);newRec.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: NX language examples - where?
Off-grid, The forum has many examples and answers, granted they aren't always easy to find because the search function isn't great. You can also send an email to support that requests access to…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: "Display field only, if" multiple-choice field is = 1
Off-grid, here is a link to the language reference... https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language Use command+f to search for that function on the page.
- Sean
- 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?
Bas, You're welcome and I learned something also. I finally figured out that once you start to concatenate strings to array elements it stringifies the array so join() wouldn't work.…
- Sean
- 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?
Ok, let's try this... replace(concat('C) Materials Used'.(Quantity + "x " + 'Part Name')) + " | " + sum('C) Materials Used'.'Total Price'), ", ", "") Of course,…
- Sean
- 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?
Bas, in your code example... join('Project Items'.'Materials Used'.text('Suggested Sales Price'); 'Project Items'.'Materials Used'.text(Quantity), " tada") you have a semicolon in the formula.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: another way that filtering
A View layout element might work for you. Here is the format of the formula you would use... select YourTable where YourField = "Sweden"
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: share record view?
https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/if-i-want-to-send-one-of-my-team-a-link-to-a-record-can-i-construct-a-url-5d68a6fa9d8a4f52104d1c5a?…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing records from 1 table to another
Hi Bas, Yes, it makes more sense now. In a perfect world you could use a "Trigger on create" to create a new record in "Items and Quantities" and concatenate the fields in the new record,…
- Sean
- 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?
You have an extra ). Remove the last one before the comma and see if that works.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing records from 1 table to another
I don't follow why you use a separate record for Article Number and Quantities. Why not create a formula field instead and concatenate the the fields?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Anybody else having issues logging into Ninox site using Chorme today?
No editing has been one of the gripes on this forum.
- Sean
- 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?
Bas, try replacing concat() with join()
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: A new concat() function
Interestingly, join() does not convert a numeric array to text automatically the way concat() does. Will this change in the future?
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: A new concat() function
Thanks Ninox Team! I just realized that's what the new join() function does.
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Search Inside a Table on Ipad, Apple IOS
@Bas, You are referring to Mconneen's code, but as far as I know, it's not possible to set focus to a field programmatically yet.
- Sean
- 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?
Hi Jörg, Thank you for that. The reason I said "Another" is there are still others that are missing. I did mention this in another thread... https://ninoxdb.…
- Sean
- 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?
Another undocumented function... join()
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Hide part of a database?
Mr. K., are you wanting to copy the data model? https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/is-it-possible-to-copy-a-view-5c237f6ccf005e2aa0747ab2
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Time Stamps for Status Changes
The code would go in the "Trigger after update" for the Yes/No and Choice fields.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Time Stamps for Status Changes
I assume you have Date/Time fields setup to accept the time stamp? If so, you can add something like this to your Yes/No and Choice fields... let t := this;if t.'Yes / No' thent.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: New View/Form? What is the purpose of this view?
https://ninoxdb.de/en/forum/ideas-and-suggestions-5abb9f4f45eda7ea1e75ed02/unique-form-views-5d17a70dccd6ea4c56021f9d
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Button Formula - Duplicate Record + sub-records
I know I tested this before I posted and now I remember how it worked. Following your example, you would use... let i := duplicate(this)
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 45 46 47 48 49 71

Welcome to the Ninox community

Sean

My Posts

Re: Switch syntax wrong?

Re: "Display field only, if" multiple-choice field is = 1

Re: Parsing records from 1 table to another

Re: NX language examples - where?

Re: "Display field only, if" multiple-choice field is = 1

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: another way that filtering

Re: share record view?

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: Parsing records from 1 table to another

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: A new concat() function

Re: A new concat() function

Re: Search Inside a Table on Ipad, Apple IOS

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: Hide part of a database?

Re: Time Stamps for Status Changes

Re: Time Stamps for Status Changes

Re: New View/Form? What is the purpose of this view?

Re: Button Formula - Duplicate Record + sub-records

Overview