Kindly correct the Formula

1

I need to move row to a subpage (once certain condition meet), and delete it in the main page. Here are my formulas and the automation. With the DeleteRows(currentvalue) added the pushbutton did not function. If the deleteRows(currentvalue) removed, the button functions,but the closed rows in the main page remains, and also added into the subpage where all closed items should be. Second problem also, once new closed items are added and clicking the push button the paid section where previous closed items added it multiplies the closed items depending on how many click you do.

RunActions(
[TR-SBTC]
.Filter([TR-SBTC].[Liability Status] = “Closed”)
.FormulaMap(
AddRow(
[PAID-PN/TR],
[PAID-PN/TR].BANK, CurrentValue.BANK,
[PAID-PN/TR].[Original PN/TR Number], CurrentValue.[Original PN/TR Number],
[PAID-PN/TR].[New PN Number], CurrentValue.[New PN Number],
[PAID-PN/TR].[Company Name], CurrentValue.[Company Name],
[PAID-PN/TR].[What was this money used for], CurrentValue.[What was this money used for],
[PAID-PN/TR].[Credit Limit Classification], CurrentValue.[Credit Limit Classification] ,
[PAID-PN/TR].Sequence, CurrentValue.Sequence ,
[PAID-PN/TR].[Copy Last], CurrentValue.[Copy Last] ,
[PAID-PN/TR].[Orig Amount], CurrentValue.[Orig Amount] ,
[PAID-PN/TR].[BEG BALANCE], CurrentValue.[BEG BALANCE],
[PAID-PN/TR].PAYMENT, CurrentValue.PAYMENT ,
[PAID-PN/TR].[END BALANCE], CurrentValue.[END BALANCE],
[PAID-PN/TR].FROM, CurrentValue.FROM ,
[PAID-PN/TR].TO, CurrentValue.TO,
[PAID-PN/TR].[Is it Weekend], CurrentValue.[Is it Weekend] ,
[PAID-PN/TR].[INT RATE], CurrentValue.[INT RATE] ,
[PAID-PN/TR].[NO OF DAYS], CurrentValue.[NO OF DAYS] ,
[PAID-PN/TR].[INT DUE], CurrentValue.[INT DUE],
[PAID-PN/TR].WTAX, CurrentValue.WTAX ,
[PAID-PN/TR].[NET INT DUE], CurrentValue.[NET INT DUE] ,
[PAID-PN/TR].[Doc Stamps], CurrentValue.[Doc Stamps] ,
[PAID-PN/TR].[TOTAL DUE], CurrentValue.[TOTAL DUE],
[PAID-PN/TR].[Check Number], CurrentValue.[Check Number] ,
[PAID-PN/TR].[Payment Status], CurrentValue.[Payment Status] ,
[PAID-PN/TR].[Liability Status], CurrentValue.[Liability Status]), DeleteRows(currentvalue)))

Automation

image
image238Ă—497 15.2 KB

1 Like
2

Hello @Margelyn_Ballesteros ,

  1. unless you have tens of thousands of records, a checkbox (named something like “status”) would really do the trick better: you only have one table with a view for your main page and a view for your subpage, filtered for showing only non-closed or closed items.

  2. in your current setup the deleterows() function should work, so I guess you made a mistake in the formula, but you don’t show what the formula with deleterows() looked like. You might have forgotten to separate the functions in the runactions() with a comma.

  3. You are talking about pushing a button and you are talking about an automation. Are you talking about a row button or a canvas button? Either button can work, but it needs to be setup properly. But having a button and an automation does not sound OK.

If you share a dummy doc resembling your document, it is a lot easier for the community to help you.

Greetings,
Joost

3 Likes
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.