Sam

Sam.1

Joined: Thu Mar 17 19:36:13 UTC 2022

My Posts

Latest Posts

Re: Dynamic Choice Fields reference table
@Jacques TUR The changes were made exactly. The new data was placed starting at the row with the highest number. Same as with the initial code. Is there another change that might work?
- Sam.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Dynamic Choice Fields reference table
@Jacques TUR thanks Jacques! I’ll make the changes and let you know
- Sam.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Dynamic Choice Fields reference table
@Fred yes
- Sam.1
- 2 yrs ago
- Learn and share
- Reported - view
Dynamic Choice Fields reference table

Hi Helpers, I'm having difficulty solving the following code that is used to enter custom data into a table referenced by dMC fields. As an example, The last/highest number(row) in the Number column…
- Sam.1
- 2 yrs ago
- 13replies
- 241
- Learn and share
Re: coding for create record
@RoSoft_Steven thank you Steven! This worked for me as well
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Sort view by initial exam
@Fred Patient B ID should be 101 for both rows. My typo in the first example
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Sort view by initial exam
@Fred hi Fred,I apologize for the delay. Busy week. Here is the before and desired filtered view showing the first exam for each patient. PATIENT PATIENT ID EXAM ID A 100 600 B 101 601 D 104 602 D…
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Sort view by initial exam

Hi All, I have a view of all patients examined in a given month. Some of the patients have been examined more than one time during the month. How can I sort the view so that it is filtered to view…
- Sam.1
- 2 yrs ago
- 3replies
- 44
- Get help
Re: MultiLine Text field with multiple rows alongside in form
@Fred Hi Fred, Could you please show the corresponding codes for each formula field that you floated ? thanks
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: MultiLine Text field with multiple rows alongside in form
@Jacques TUR hello and thank you for the code!
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Filtering by first record
@John Halls yes, customer is a field
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Filtering by first record
@John Halls Our messages were in transit at the same time. @John Halls I’ll try it as you mentioned without the select
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Filtering by first record
John, The return I have is the first Order record only. I’ll keep working at it and let you know.
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Filtering by first record
@John Halls Hi John, Thanks for looking! The Parent is Appointment. The child is Order. The current filter is: let t := this; (select Order)[Appointment = t][Customer]
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Filtering by first record

Hi All, I would appreciate some help with filtering a table view. How can the lines for only the first record of each customer be shown? thanks
- Sam.1
- 2 yrs ago
- 6replies
- 84
- Get help
Re: Copy text field to reference field
@Sam Im sending this after changing the status to answered. Just curious to see if the thread continues.
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Sam Got the data where I need it! Thanks Fred :) I used your first 2 suggestions. If I use the last one I'll let you know.
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Fred
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Fred @Fred I’ll let you know how it goes thanks
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Sam I’ll double check to be sure.
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Fred Will you have multiple records in Table1 linked to a single record inTable2? yes
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Fred I think it may be linked through the dMC ‘Other Data’ The Dynamic value is: let xTemplate := number (‘Other Data’); (select Table2)[‘Other Data’ = xTemplate]
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Fred @Fred yes, a inventory/service item is added by choice in table1
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Fred thanks again for looking!
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Fred if 'AUTO CREATE RECORDS' then do as server let xCurrRec := number(Id); let xTemplate := number('Other Data'); for i in (select Table2)['Other Data' = xTemplate] do "CHECK TO SEE IF ITEM SHOULD…
- Sam.1
- 2 yrs ago
- Get help
- Reported - view

1 2 3 4 5 6 7

Welcome to the Ninox community

Sam

My Posts

Re: Dynamic Choice Fields reference table

Re: Dynamic Choice Fields reference table

Re: Dynamic Choice Fields reference table

Re: coding for create record

Re: Sort view by initial exam

Re: Sort view by initial exam

Sort view by initial exam

Re: MultiLine Text field with multiple rows alongside in form

Re: MultiLine Text field with multiple rows alongside in form

Re: Filtering by first record

Re: Filtering by first record

Re: Filtering by first record

Re: Filtering by first record

Filtering by first record

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Overview