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: Leading zero's in a number field
Try using lpad() or change the "format mask" so it is 4 digits longer than the number of digits in your Invoice #.
- 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?
Hi Halio, You've misunderstood the purpose of this thread. The linking is for users who have separate tables, from another app usually, that they want to connect via reference.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing formatted_address from Google Geocode JSON
You're welcome and thanks for letting me know you can use a variable in the http() function... that doesn't work in all parts of Ninox. I don't know if you have tried this,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing formatted_address from Google Geocode JSON
The sparse information on the item() function can be found here... https://ninoxdb.de/en/manual/api/http-calls https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language I can't…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing formatted_address from Google Geocode JSON
Ignore my second post, otherwise you would have to test for a valid response again.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing formatted_address from Google Geocode JSON
...After the if-then-else statement.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Parsing formatted_address from Google Geocode JSON
Using your first example where you store the result like this... 'JSON OUTPUT' := text(googlecoder.result); you add this line... item('JSON OUTPUT'.results, 0).formatted_address
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Json object - get a property without quotation marks
I think so... https://youtu.be/Lv3lR6dwNWo Did the link in my previous post work for you?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: INNER JOIN
Who said anything about the tables being related? If you want a list view instead of a table view, then the solution I posted using the join() function in a formula field will work.…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: INNER JOIN
I think the View layout element would be perfect for implementing the various JOINs.
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Json object - get a property without quotation marks
Do you even Google, bro? Just kidding! Surprisingly, there isn't much information on this that isn't specific to Word or Outlook. Try this... https://youtu.be/cbzYO3D4Pos or this... https://youtu.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to place fields from two related tables onto embedded view
It makes sense to concatenate, however, the entries would need to be very short for all of the child records to be visible. Most likely, the user would have to click on the parent record which would…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to place fields from two related tables onto embedded view
Jen, You followed them correctly. I chose concatenate because it doesn't aggregate like the other options. Once you have it displayed in the View, you can click on that column header,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to place fields from two related tables onto embedded view
Jen, When you use a View layout element, just select the parent table. You can select the fields/columns to display using the user interface just like you would with the table view.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: INNER JOIN
@Jörg, Would you please provide an example where it produces a virtual table. If that was possible, I would think you could use it in the View layout element or the function itself would return…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Problem with last()
Yep, I just tried it with Safari and got the same result.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Attachment tab that shows number of attachments
You could use a Formula field with, count(files(this)), on your Form view.
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: How to update new number field to contain the table record id
Try "Assign calculated value" and use number(Id) as the formula.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to hide Multiple Choice values that are not ticked/selected?
You can use the html() function to enable scrolling. You lose the Switch formatting, but that could probably be added with some CSS tweaking. html("<style>.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Formula to keep an extra "0" from getting added when scanning in a UPC-A Barcode (12 digits).
@Karen, Ok, I did everything on my phone. You put the code in "Trigger after update" in iPad app.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Formula to keep an extra "0" from getting added when scanning in a UPC-A Barcode (12 digits).
@Karen, I did everything in the iOS app. Tap the hamburger menu to get to "Edit fields" and then the hamburger menu for the Barcode field.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Formula to keep an extra "0" from getting added when scanning in a UPC-A Barcode (12 digits).
This worked for me... Barcode := substr(Barcode, 1) Barcode is the name of the Text field I used to capture the barcode (clever, right). I put that line in "On update" under "Advanced options" of the…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Formula to Create a random number
Have you seen this thread? It might work for you. https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/generate-unique-numeric-key-for-table-5cd642447172574710f1f315
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Scientific Notation
I think I've got this worked out, but if you try it and find errors let me know. The number field can't have any formatting for the formula to work. The field name I used is "Number" and it converted…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Limit Input to Rational Numbers in a Text Field
I think this is my final version... let isNeg := "";let ldZero := "";if length(replacex(TasN, "\D", "g", "")) = 0 thenTasN := nullelseif number(replacex(TasN, "\D", "g", "")) = 0 thenTasN :…
- Sean
- 5 yrs ago
- 1
- Learn and Share
- Reported - view

1 42 43 44 45 46 71

Welcome to the Ninox community

Sean

My Posts

Re: Leading zero's in a number field

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

Re: Parsing formatted_address from Google Geocode JSON

Re: Parsing formatted_address from Google Geocode JSON

Re: Parsing formatted_address from Google Geocode JSON

Re: Parsing formatted_address from Google Geocode JSON

Re: Parsing formatted_address from Google Geocode JSON

Re: Json object - get a property without quotation marks

Re: INNER JOIN

Re: INNER JOIN

Re: Json object - get a property without quotation marks

Re: How to place fields from two related tables onto embedded view

Re: How to place fields from two related tables onto embedded view

Re: How to place fields from two related tables onto embedded view

Re: INNER JOIN

Re: Problem with last()

Re: Attachment tab that shows number of attachments

Re: How to update new number field to contain the table record id

Re: Is it possible to hide Multiple Choice values that are not ticked/selected?

Re: Formula to keep an extra "0" from getting added when scanning in a UPC-A Barcode (12 digits).

Re: Formula to keep an extra "0" from getting added when scanning in a UPC-A Barcode (12 digits).

Re: Formula to keep an extra "0" from getting added when scanning in a UPC-A Barcode (12 digits).

Re: Formula to Create a random number

Re: Scientific Notation

Re: Limit Input to Rational Numbers in a Text Field

Overview