Answered

Circular reference Problem!

(0) Share

Report

Posted on by JeffT2022

137

In my app there are cells for Months (which correspond with month columns in a sharepoint list), these month cells are text fields which form a grid.

I'm creating an auto-populate feature that uses an invisible table with dates and some basic math (total amounts, divided by months equals monthly amount).

I got this to work successfully in my test environment, however - when working with the live app, any time I try to have one of the visible month cells reference one of the hidden math cells (either total, monthly count, or monthly amount) it tells me it creates a 'circular reference' between properties - but it doesn't, I don't think.

The monthly cells do total up in another area, but that field isn't being referenced in any of the equations - has anyone else had trouble with non-existent circular references?

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

JeffT2022 137 on at

Like (0)

Report

Re: Circular reference Problem!

I was able to resolve my issue, for anyone reading this later....

my problem was the hidden cells I was trying to reference were not actually "in" the edit form, rather floating on top (invisible) - I remade the table in a custom card within the edit form and it works fine.
mmollet 3,187 on at

Like (1)

Report

Re: Circular reference Problem!

Make sure you use Self.Value instead of ControlName.Value when referencing the same control you are typing code in for. This can cause what you are talking about. So for example:
If(Label1.Text = "Monday", **do something**)
If(Self.Text = "Monday", **do something**)