SQL Formula Help - Related Items

Ask your questions here.
Post Reply
dhickey76
Posts: 42
Joined: 27 Mar 2020, 20:45
Name: Damien
Location: Utah, USA
Company Name: Techtop Canada

SQL Formula Help - Related Items

Post by dhickey76 »

Hi,
Screenshot_2.png
I would like to SUM the amounts received from the purchase order entity (related items) and show the results in the Shipments entity. When I use a regular function I am given the SUM amount for all records in the Purchase order entity and not just the related item records.

Any help would be appreciated.

Thanks!

User avatar
support
Site Admin
Posts: 3586
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: SQL Formula Help - Related Items

Post by support »


User avatar
elviseras
Sponsor
Sponsor
Posts: 507
Joined: 08 Feb 2017, 03:16
Name: Elvix Sampedro
Location: Galicia - Spain
Company Name: novaTEK

Re: SQL Formula Help - Related Items

Post by elviseras »

Hi Damien,

Could you share your CSS theme? I find it very stylish and beautiful ;) ;) ...

dhickey76
Posts: 42
Joined: 27 Mar 2020, 20:45
Name: Damien
Location: Utah, USA
Company Name: Techtop Canada

Re: SQL Formula Help - Related Items

Post by dhickey76 »

Thanks Sergey I understood that I needed to use a function, I just wasn't sure how to set it up with a related item. For anyone else that needs to do something similar here are the steps.

Total Recd. field is summing the amount received from a separate entity using a related item (purchase order)
Screenshot_3.png
Function {17} - Purchase Orders entity
Screenshot_5.png
Total Recd. field is setup to pull the function but tied to the related item
Screenshot_7.png
Thanks again, case closed!

dhickey76
Posts: 42
Joined: 27 Mar 2020, 20:45
Name: Damien
Location: Utah, USA
Company Name: Techtop Canada

Re: SQL Formula Help - Related Items

Post by dhickey76 »

elviseras wrote:
25 Nov 2020, 16:35
Hi Damien,

Could you share your CSS theme? I find it very stylish and beautiful ;) ;) ...
I use the default theme but with some custom styling. I've attached part of my custom css since most of it is tied to specific fields. But the general layout, fonts and button customizing is there. You'll need to add your own URL into the font face items since mine is loading from my site.

If I were you, I would only add small sections at a time. Test and then add some more :D :D

Good luck!
Attachments
Custom.css
(3.57 KiB) Downloaded 14 times

Post Reply