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: Button Formula - Duplicate Record + sub-records
Ok, I apologize. I overlooked the linking in the following... h.('BLA Form' := i) q.('BLA Form' := i) There might be a way to do it using duplicate(this), but I'm winding down for the day.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Button Formula - Duplicate Record + sub-records
duplicate(this) will create a new record with all the data from the current record. Did you try this... let reply := dialog("", "Do you wish to revise this BLA?", ["Yes", "No"]);…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to get the value from an external table by clicking on a view
I would say use a linked table. If you click on a row in a View it will popup that record, but there isn't a way to determine the record information from Table 1 so you wouldn't know which record to…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Button Formula - Duplicate Record + sub-records
Hi Sarah, you could reduce the whole "i" section to "duplicate(this)" if you wanted.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Linking Tables/Records
Hi Martin, I’m referring to the browser version of Ninox, but you can also login using the Mac app. Can you see “Start Ninox” at the top-right of your browser window?
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Linking Tables/Records
When you launch the web app, you should see "Webinar EN 2019" in the tab section. If you don't see it, send an email to support and they will include you.
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Coping Multiple Records from One Subtable to Another
You're welcome. :)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Coping Multiple Records from One Subtable to Another
One other suggestion. If each 'Generic Setup' is a single record then this should work and you can use the Ninox Id # without using a for-loop. Create a variable to copy the record to like this…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Coping Multiple Records from One Subtable to Another
William, in the brackets in the following line... for r in (select 'Generic Tech Sheet')['Generic Setups'] do 'Generic Setups' is the group being filtered, but you don't have a filter criteria.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Coping Multiple Records from One Subtable to Another
I realized you are trying to use the Ninox Id and that's not going to work. I guess I was thinking of your T#. If you have an Id # that is not the Ninox Id # you'll need to use that.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Coping Multiple Records from One Subtable to Another
Change [Id = myId] to [number(Id) = myID] Sorry about that.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Coping Multiple Records from One Subtable to Another
William, try this... let reply := dialog("", "You are about to apply the selected generic set-up. Continue?", ["Yes", "No"]);if reply = "Yes" thenlet myID := this.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to unlink a composition (inner related) record?
Westy, I can't speak to the why of it, but there is an example in the LinkTables database on the Webinar. You'll have to create a button and attach the code.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Coping Multiple Records from One Subtable to Another
William, I think someone needs to come up with an exercise where you can finally use your array . Most tasks can be completed without using arrays in Ninox. Please see this familiar thread...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Styled formula background
Steven, Good point about using a yes/no field to alternate between the two and it would keep the display consistent whereas the HTML method would be a little different than the rest of the fields.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Styled formula background
“Using that formula now, but having an issue where my line break is no longer working. The formula field is 3 spaces high so I was using a line break to vertically center the text. Now, no line break.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Styled formula background
Sarah, You can do it that way or build an HTML string and assign it to a variable like... let htmlString := "HTML goes here" and add to it... htmlString :…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Bulk Update - populating linked field
Hi Sarah, If you have access to Webinar EN 2019, there is a database named LinkTables. Take a look at it and see if it helps you with linking your records.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: is there a way to follow code execution?
@Mconneen, It works, but I would personally put the select statements inside the if-then-else statement instead of this way just for clarity. To each their own I guess.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Bulk Update - populating linked field
When you say "update", do you mean you need to link them to a specific record? Do they have a common field?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Formulation Issue
No worries. Glad you got it working.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Formulation Issue
William, the only way I was able to duplicate your error was by linking more than one 'Ink Cure Duration' record to one 'Trial Summary' record. Will you normally only have one 'Ink Cure Duration'…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Create tables with autonumbering with ease.
Thanks Steven. Now, if users would kindly use the "Search forum..." function before posting questions that have already been answered!
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Formulation Issue
Don't worry about chosen() or numbers(), what you are doing with contains() works fine. I'm going to have to look at the rest again tomorrow. It's been a long day for me.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Styled formula background
Sarah, yeah you're right. The only way I know of to do what you want is to use the html() function, but it will only display properly in form view. If table view is not a priorty and you are…
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 46 47 48 49 50 71

Welcome to the Ninox community

Sean

My Posts

Re: Button Formula - Duplicate Record + sub-records

Re: Button Formula - Duplicate Record + sub-records

Re: How to get the value from an external table by clicking on a view

Re: Button Formula - Duplicate Record + sub-records

Re: Linking Tables/Records

Re: Linking Tables/Records

Re: Coping Multiple Records from One Subtable to Another

Re: Coping Multiple Records from One Subtable to Another

Re: Coping Multiple Records from One Subtable to Another

Re: Coping Multiple Records from One Subtable to Another

Re: Coping Multiple Records from One Subtable to Another

Re: Coping Multiple Records from One Subtable to Another

Re: How to unlink a composition (inner related) record?

Re: Coping Multiple Records from One Subtable to Another

Re: Styled formula background

Re: Styled formula background

Re: Styled formula background

Re: Bulk Update - populating linked field

Re: is there a way to follow code execution?

Re: Bulk Update - populating linked field

Re: Formulation Issue

Re: Formulation Issue

Re: Create tables with autonumbering with ease.

Re: Formulation Issue

Re: Styled formula background

Overview