About Rodney_Reid

Rodney_Reid

Hi Guys and Gals,I've done a bit of searching and can't find a solution to something that I would have thought would have had a standard function. I have a data table pre-populated with data and a blank data table for form functions.In my form, I hav...

Rodney_Reid · 10-09-2023

Hi Guys,A short summary of app:Invoice lines get captured(INVOICE) - the customer makes one bulk payment(PAYMENT) and payment then needs to be split up between invoice lines(P.ALLOCATIONS). Payments can be made either in full or split payments per li...

Rodney_Reid · 09-11-2023

Hi Guys and Gals,I'm finding that when I have a field with a type of Decimal it automatically pre-populates the data field with a zero (0) value even if one sets the initial value as ""(Blank). I've tried using IF functions to check that if a certain...

Rodney_Reid · 07-08-2022

Hi Team,I'm probably overthinking something that will have a simple solution so I need to bounce it off some fresh minds and get a different perspective.I have a simple Enquiry form for a consultant to complete. The customer details need to either be...

Rodney_Reid

Unless I'm understanding you incorrectly - I'm finding that Select() has the same limited function whereby the Column needs to be set data and cannot be a Variable.

Rodney_Reid · 10-10-2023

Suvrutt to the rescue once more!The suggestion put me on the right path and gave me a fresh view of the problem. The solution was to place the expression in the P.ALLOCATIONS Ammount field with a few tweaks:[INVOICE ALLOCATED].[Total.Selling]>=([INVO...

Rodney_Reid · 10-09-2023

Apologies Gents - my initial thought was to put it in the PAID.VIRT column seeing that there was the first interaction between the two tables relating to the payment allocation. Then I moved it to the OUTS.VIRT thinking that might I might be prematur...

Rodney_Reid · 10-09-2023

First one that came to mindValid_If([Outstanding]-[Paid])>=0 - but then I realized that the paid column would only update once the data table P.Allocations syncs so I tried using a PAID Virtual column.So I tried ([Outstanding]-[Paid.Virt])>=0 Tried d...

Rodney_Reid · 09-11-2023

Thanks Willow - I actually found a simple workaround to this. I created a virtual column with the formula IF([EXPRESSION]=0,"",[EXPRESSION]) and used that column as a tag in the PDF report, and the tag in the PDF shows a value of ""(blank) when gener...

My Stats

Rodney_Reid's Bio

Badges Rodney_Reid Earned

Recent Activity

Using a Lookup Function on a Variable Column

Updating of parent record and checking if value is valid before updating

Decimal Value of 0 showing in data when not supposed to

Customer Inquiry Form / Customer Contact Details

Re: Using a Lookup Function on a Variable Column

Re: Updating of parent record and checking if value is valid before updating

Re: Updating of parent record and checking if value is valid before updating

Re: Updating of parent record and checking if value is valid before updating

Re: Decimal Value of 0 showing in data when not supposed to