Sean

1760
79
0

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

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Sort two fields?
https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/can-you-do-secondary-sorts-within-a-view-5bf45478d91e505c0994c84e
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: This Forum Needs a Replacement.
+1
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Templates and Manual
Sorry, "YourFilterCondition" should read "YourFilteredField"
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Templates and Manual
If you are referring to the View layout element you can use an if-then-else to select records... let t := this; if t.YourChoiceField != null then select YourTable where text(t.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Templates and Manual
Lawrie, I totally get your frustration. There are many changes to the forum alone that would make getting the information you are seeking a more productive process.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Templates and Manual
Lawrie, Please don't take this personally... You say you don't like the "pedestrian" YouTube videos, but you complain about not being able to accomplish a task that is covered in many posts in this…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Dialog function when creating a new record
https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/dialog-function-5b557619b23d4c7ca268b581
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to check which View Name is currently open?
I think they are working on something like that. https://ninoxdb.de/en/forum/ideas-and-suggestions-5abb9f4f45eda7ea1e75ed02/unique-form-views-5d17a70dccd6ea4c56021f9d
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How do I copy a row in a table?
I tried to research what is and what isn't OOP and wound up feeling a gray as ever. I do know that you can't declare objects like you can in JavaScript using the Ninox language.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Create x number of records with button
Hi Sarah, You're on the right track. You can use something like the following to update the date field... for i from 0 to x dolet newRecord := (create YourTableName);newRecord.(Date := today() + i)end
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How do I copy a row in a table?
Here is the link to the Language Reference... https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language I don't work for Ninox, but I can say from my own experience and inquiries…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Create x number of records with button
Yes, you can use a for-loop to create x numer of records. for i from 0 to x docreate YourTableNameend
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
I figured out the the way I used unique() function was causing the problem. Here's the updated formula... let myTable1Id := (select Table1).Id;let myTable1Text := (select Table1).…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
One more point, you can use the View Layout Element which will update dynamically if the data changes.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Just to be clear, the first code will only link the records in Table10 where the Text field matches the Text field in Table1 of the currently selected record in Table1.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Urgent change
+1
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Linking Tables/Records

I uploaded a database named LinkTables that demonstrates how you can link records based on like fields in different tables.
- Sean
- 5 yrs ago
- 9replies
- 1786
- Learn and Share
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Additionally, you would replace the generic names Table1 and Table2 with your respective table names. You would also replace "Text" with field names you are using to link the tables.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
From the 4th post in this thread... let myTable1Id := (select Table1).Id;let myTable1Text := (select Table1).Text;myTable1Text := unique(myTable1Text);let myTable1Cnt := count(myTable1Id);…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Have you tried linking the tables one at a time?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Hey ! Do you want another tricky question ??? Again concerning sorting…
Laurent, I agree with Mconneen about attaching the code to a button if you update that information infrequently.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Unique Form Views

Currently, users can create multiple unique views for Table views only. Any change made in one Form view is copied to all of the other Form views in the same table.…
- Sean
- 5 yrs ago
- 5replies
- 1477
- Learn and Share
Re: Hey ! Do you want another tricky question ??? Again concerning sorting…
I guess I'm not sure what you mean by "tablular mode" unless you are referring to the table view. If you are referring to the table view, that solution works.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Hey ! Do you want another tricky question ??? Again concerning sorting…
You are! This requires another Formula field and this is the code I used... let t := this;count(select YourTable where Choice = t.Choice)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to show only the first line of a multi-line field?
Westy, Try this... var firstLine := item(splitx(theString, "\n"), 0)
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 49 50 51 52 53 71

Welcome to the Ninox community

Sean

My Posts

Re: Sort two fields?

Re: This Forum Needs a Replacement.

Re: Templates and Manual

Re: Templates and Manual

Re: Templates and Manual

Re: Templates and Manual

Re: Dialog function when creating a new record

Re: How to check which View Name is currently open?

Re: How do I copy a row in a table?

Re: Create x number of records with button

Re: How do I copy a row in a table?

Re: Create x number of records with button

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Urgent change

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Hey ! Do you want another tricky question ??? Again concerning sorting…

Re: Hey ! Do you want another tricky question ??? Again concerning sorting…

Re: Hey ! Do you want another tricky question ??? Again concerning sorting…

Re: How to show only the first line of a multi-line field?

Overview