Sam

Sam.1

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

My Posts

Latest Posts

Re: Split Records
@Fred ok, Thanks! I'll do it.
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Split Records
@Fred This worked nicely. Thanks Again Fred!! I had no particular reason for linking the way I did. It just made workflow sense to me at the time. I appreciate the suggestions and will give them a…
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Split Records

Hi Guys, I have attached a sample database called CONDOS. It has a subtable called JOB with a parent SERVICE. The Condos have multiple owners. Each owner has a percentage given in the OWNER table.…
- Sam.1
- 2 yrs ago
- 4replies
- 83
- Get help
- Answered
- Answered
Re: customize tables appearance
Some color can added for data field columns by using conditional formatting. Yes/No fields can have color by following the recent post https://forum.ninox.…
- Sam.1
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Fred PERFECT!! You're the best Fred! Thank You so much for all your help and patience. Sam
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Sam I did the substitution and it resulted in One invoice for the Appointment with all the lines from both owners. Instead of 2 invoices with One owners per invoice.…
Attachment
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Fred yes,for---- Do you want to create a new field called ApptID and then copy that data over? I deleted the formula field and added the Appt ID data field to Invoices.…
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Fred yes, you are correct. And, only the recreation of the invoices. Thank you for your patience! Sam
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Sam oops, got messed up with the naming. Here is the one without the Appointment table.
Attachment
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Fred Hi Fred, It is working as described and thanks for the streamlined code. However, in this sample I'm sure you'll see better than an explanation. You will see there are 4 appointment ID's in the…
Attachment
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Fred Hi Fred, I was able to see my shortcoming in providing all of the info and references needed for you. Attached will be found a revised sample database with the added references-- customer and…
Attachment
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Fred thanks again Fred! I’ll give it go and update you.
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Fred thanks for the speedy response Fred! I’ll let you know how it works on my end. I really appreciate your time and effort!! cheers
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
Hi Fred, Would have responded sooner if possible. Here is the things you asked for: What is the name of the new Parent table? Invoice what field in your Line table will be used to link to the new…
Attachment
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
@Fred No. The child portion of the Invoice/Line(Line being the subtable) relationship is what I have. The Ninox Invoice template names their Parent/Child relationship -- Invoice/Invoice Item.…
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Re-Creating invoices from the Line table
wish there was a way to edit... should be--- has retained all of the original fields
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re-Creating invoices from the Line table

Hi All, I would appreciate some suggestions on how I could re-create invoices from a table of lines. Preferably creating one invoice at a time from the Line table.…
- Sam.1
- 2 yrs ago
- 20replies
- 161
- Get help
- Answered
- Answered
Re: No sort/filter in view element in iOS v3.7.8
@Fred got it!
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: No sort/filter in view element in iOS v3.7.8
@Sam I can filter but there are no records. Only with the subtable
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: No sort/filter in view element in iOS v3.7.8
Yes. Did you find a solution?
- Sam.1
- 2 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice Fields reference table
@Fred That’s an awesome idea! I’ll jump on it this evening and let you know. sounds like it’s the way to go.
- Sam.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Dynamic Choice Fields reference table
@Sam I see that there is one number field. Do you think that matters?
- Sam.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Dynamic Choice Fields reference table
@Fred color is a text field. They are all text fields.
- Sam.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Dynamic Choice Fields reference table
@Sam that should be —-the new color gets positioned in row number 101of the color column
- Sam.1
- 2 yrs ago
- Learn and share
- Reported - view
Re: Dynamic Choice Fields reference table
@Fred yes they are fields in the table. There are 100 number records. There are 12 colors. When I add a new color it gets positioned in number 101. Add another record that is color or other and it is…
- Sam.1
- 2 yrs ago
- Learn and share
- Reported - view

1 2 3 4 5 6 7

Welcome to the Ninox community

Sam

My Posts

Re: Split Records

Re: Split Records

Split Records

Re: customize tables appearance

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re: Re-Creating invoices from the Line table

Re-Creating invoices from the Line table

Re: No sort/filter in view element in iOS v3.7.8

Re: No sort/filter in view element in iOS v3.7.8

Re: No sort/filter in view element in iOS v3.7.8

Re: Dynamic Choice Fields reference table

Re: Dynamic Choice Fields reference table

Re: Dynamic Choice Fields reference table

Re: Dynamic Choice Fields reference table

Re: Dynamic Choice Fields reference table

Overview