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: Is it possible to make a view with a top 10 only?
@Mconneen, an option for reversing the order would be to assign the group to an array and use rsort()
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Exporting Formulas to XLS?
There might be, but it would probably be easier to copy and paste them to a cell in the spreadsheet and then copy it to the rows necessary.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Split number
Thierry, I'm sorry, I misunderstood your original post. My solution was for converting whole numbers to decimal numbers so please disregard it. The number format is based on operating system settings…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Add between item
If you are wanting to automate the process, it is similar to this thread...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Split number
I assume the comma is a decimal separator? This is one way to do it for a single record... let myNum := text(WholeNumber);let myNumLen := length(myNum);let myNum := substr(myNum, 0, myNumLen - 2) + ".…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: What's the for loop syntax?
Interesting and that appears to be correct. I thought you couldn’t declare a variable repeatedly in a loop (meaning define not assign), but it appears it is an issue of scope.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Record ID number and concatenate function
I don't know how you managed to get the Id order like that in your first screenshot. The ^ symbol indicates the Column order should be ascending, but it's not in your screenshot.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Inserting Table into Formula
Nevermind, I figured it out.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Inserting Table into Formula
I'm rephrasing my question. In the line... " + 'Pump-down'.'Rate & Pressure' + " I don't understand how you are getting rows of information without using a for-loop.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Inserting Table into Formula
I'd say well done for your first time. I am familiar with the range() function, but I'm still not understanding your use of it here. This is unrelated to the coding, but apropos to your location...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Inserting Table into Formula
Nice work! I'm trying to understand what you did here. Are you saying you used a separate formula field to build the table data and then inserted it into your summary formula?…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Hide field if formula not empty
You can use an if-then-else condition in your Formula field to return your concatenated string if the condition is true or return something like "Hidden" if the condition is false (you can use any…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Can add comment to the Ninox query language
@Mconneen, Absent any other return value the first method will be returned as a string in a Formula field. I imagine anyone wanting to document their code would be mindful of that.…
- Sean
- 5 yrs ago
- 1
- Learn and Share
- Reported - view
Re: Creating a summary from data
Using the example in your first post you would combine the string like this... "Stage Number " + YourStageField + " P&P" if YourStageField is a Text field and "Stage Number " + text(YourStageField) +…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Populate a multiple choice field with values from a table, and easily add new values
The only way a Multiple Choice field can be edited currently is through "Edit fields...". You already have the Table Reference set up, you could click on the Search icon in your Interests field and…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Œ
You can use "Update multiple records...". When you select the field you want to change in "Update multiple records...", select "Assign calculated value" and use this as the formula...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Switch statement evaluating to default value
OK, scratch that previous post. I remembered a post from last August that is similar to what you are wanting to do. Change the switch statement to... switch 'FL Value' > -20 and 'FL Value' < 50 do…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Switch statement evaluating to default value
You can only use an expression in the switch part of the statement and the result of that expression is compared to the case values. If you changed your first case statement to... case 48.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Looking for more learning help...
There are already a lot of coding examples in the forum so be sure to search the forum and you can find the language reference here...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how do i delete a reference between rows
Click on the unlink button...
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: formula giving error
Well, at the risk of beating a dead horse I'm going to correct myself . 6.112 * 10 - is the base and 7.5 * Temp / (237.7 + Temp) * Humidity / 100 - is the exponent and the result is the power
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: formula giving error
You bet. Here's a link to the Ninox functions... https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: formula giving error
Power, so in the formula... 6.112 * 10 - is the power and 7.5 * Temp / (237.7 + Temp) * Humidity / 100 - is the exponent
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Create another record from button
This works... let myIN := this;let NI := (create InterviewLog);NI.(Candidate := myIN.Candidate);popupRecord(record(InterviewLog,number(NI.Id)))
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Show everything in find menu
Just use command-F again and you'll have the "Show everything" option.
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 51 52 53 54 55 71

Welcome to the Ninox community

Sean

My Posts

Re: Is it possible to make a view with a top 10 only?

Re: Exporting Formulas to XLS?

Re: Split number

Re: Add between item

Re: Split number

Re: What's the for loop syntax?

Re: Record ID number and concatenate function

Re: Inserting Table into Formula

Re: Inserting Table into Formula

Re: Inserting Table into Formula

Re: Inserting Table into Formula

Re: Hide field if formula not empty

Re: Can add comment to the Ninox query language

Re: Creating a summary from data

Re: Populate a multiple choice field with values from a table, and easily add new values

Re: Œ

Re: Switch statement evaluating to default value

Re: Switch statement evaluating to default value

Re: Looking for more learning help...

Re: how do i delete a reference between rows

Re: formula giving error

Re: formula giving error

Re: formula giving error

Re: Create another record from button

Re: Show everything in find menu

Overview