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: Accidentally hid all columns in linked table view
I'm not making light of your situation... That's kind of like the perfect storm. I duplicated the condition and I can see the scroll bar move up and down,…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How to modify the view of the file .txt created with createTextFile ?
Don't use return. :) If you create a text file with a text editor you will get the same result.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How to modify the view of the file .txt created with createTextFile ?
I tried this and it worked with a regular space... createTextFile(this, rpad(myName, 50, " "), "TestPlainSpace.txt") Try your code with a regular space in the rpad function and see if it works.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How to modify the view of the file .txt created with createTextFile ?
I can only tell you what I know from testing. A regular space only requires one byte, but a non-breaking space (option+space) requires two bytes in a text file.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: "while" vs "for" statements in Console
It's not just the Console. The same thing happens in a Formula field. I have no meaningful answer for why they are different only an observation of the difference...…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Having records sorted in Table by more than one column
Thank you and you're welcome. One more line you can add to the end of the "Trigger" code is openTable("YourTable"). This will refresh the sort and it will update the table display if that group is…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Having records sorted in Table by more than one column
I agree and I'm a little surprised that sorting on multiple columns hasn't been implemented yet. Meanwhile, it is flexible enough to let users develop workarounds to solve this kind of problem.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Having records sorted in Table by more than one column
You probably won't like it... :) This is a workaround that requires you to add another field for ranking that would be used in the concatenation instead of the actual descending ordered field.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Unique Record Id & Id Field - strange behaviour
Since you didn't post your formula, I can only give you general information. If you don't get the output you expect with Id then use number(Id) in your formula.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Having records sorted in Table by more than one column
This link explains how... https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/can-you-do-secondary-sorts-within-a-view-5bf45478d91e505c0994c84e
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: This expression returns a total of Rev-Amount from my Revenue subtable until the "where" portion is inserted. Any idea why?
Steven, of course :)
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Syntax to use URL in function
Looks like you worked it out. The html() function renders CSS and HTML so if you just want the unrendered string don't use that function.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: age(some_date) function not working on Console
The square brackets are an indication of what it is getting and what the error is. My understanding is the select statement returns an array even if it is empty.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: age(some_date) function not working on Console
Don't use the square brackets even if the date is from an array. You'll need to use the item() function if the date is in an array.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Syntax to use URL in function
htmlString should really be httpString
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Syntax to use URL in function
This should get you there. I used variables for the field names and note the number of quotes for the link. The entire string needs to go into the html() function.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Multiple Choice in nested if formula
@Wynand, You're welcome. Glad you got it working.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: html or pdf print out of table - bulleted list in each cell
Here is an example... let myArr := ["One", "Two", "Three", "Four"];let htmlString := "";htmlString := htmlString + for i in range(0, count(myArr)) doitem(myArr, i) + "<br>"end;html(htmlString)
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: html style not working
Looks like I should have waited a couple of minutes ;-)
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: html style not working
You have too many quotes. Try this... html("<h1 style=""color: blue; font-size: 86px;"">" + 'Base Name' + "</h1>") It looks like you'll need to adjust margins or padding though.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Sort related records by specific field
In your original post you said you need to get related records from another table. I assumed you have a table reference and in your parent table form you have a reference view of your child table…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How to remove the duplicate button in a form view?
You can hide the duplicate button using a formula field and then hide the formula field. Here's the code for trash, duplicate and add... html("<style>.hud-menu-button.menu-icon.…
- Sean
- 4 yrs ago
- Learn and Share
- Reported - view
Re: Loop error / syntax
Try this for the sum... myInvoice.('Invoice Amount' := sum(i.'Pupil Attendance Detail'.'StuChg £'); The pupil table is already selected by the for-loop.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Sort related records by specific field
You could sort on 'SV Number' in descending order in the Table Reference view and so it would be the first record.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Sort related records by specific field
Yes, it will slow performance if you have many records, especially in the browser version. Will this formula generate a unique value for each record in that table?
- Sean
- 4 yrs ago
- Get help
- Reported - view

1 36 37 38 39 40 71

Welcome to the Ninox community

Sean

My Posts

Re: Accidentally hid all columns in linked table view

Re: How to modify the view of the file .txt created with createTextFile ?

Re: How to modify the view of the file .txt created with createTextFile ?

Re: How to modify the view of the file .txt created with createTextFile ?

Re: "while" vs "for" statements in Console

Re: Having records sorted in Table by more than one column

Re: Having records sorted in Table by more than one column

Re: Having records sorted in Table by more than one column

Re: Unique Record Id & Id Field - strange behaviour

Re: Having records sorted in Table by more than one column

Re: This expression returns a total of Rev-Amount from my Revenue subtable until the "where" portion is inserted. Any idea why?

Re: Syntax to use URL in function

Re: age(some_date) function not working on Console

Re: age(some_date) function not working on Console

Re: Syntax to use URL in function

Re: Syntax to use URL in function

Re: Multiple Choice in nested if formula

Re: html or pdf print out of table - bulleted list in each cell

Re: html style not working

Re: html style not working

Re: Sort related records by specific field

Re: How to remove the duplicate button in a form view?

Re: Loop error / syntax

Re: Sort related records by specific field

Re: Sort related records by specific field

Overview