=IF(ROW > 1,INDEX(Table_1.Single_Line,ROW()-1,""))
This just refences the row above. It is recursive but not circular.
This was to replace javascript so they can use the new forms designer.
Take a look at Matthew Tingey's solution in this post as he mentions the same circular reference issue and his workaround for a running total. I'm not sure if you are trying attempting a running total or something different but his solution may present you with ideas to solve your specific build.
It seems he says that even adding another redundant field still creates a circular reference. In the end he just found that the SUMIF method appears to allow him to eliminate the circular reference.
We are not trying to SUM anything though so we can not use SUM if. We just want row 2 to equal row 1 and this is recursive but not circular.
Note: Although the formula indicated a circular reference it still allowed me to save and it still pulled in the expected data from the previous row. However, this stopped working as of build 11.0.2307.40556 and the form now will not allow me to use the formula and is throwing the circular reference error during preview and live view, which it did not do previously.
The formula is very basic and I just want to get the value from the referenced field in the previous record. Since this is in the new form designer, I don't think I can do something like this in JS, but if there's a way please let me know.
=INDEX(GL_Coding.Account_Number,ROW()-1)