Solved

Filemaker Portal running line total

Posted on 2011-03-18
2
965 Views
Last Modified: 2013-12-26
Hi,

I am only just above a newbie Filemaker hacker.

I need some advice re portals.

I have written a cashbook that has 2 tables: accounts and transactions

The transactions appear in the portal for deposits and withdrawals

The columns displayed are:  date, type (deposit/withdraw etc), payee, payment, deposit and balance (at time of transaction)

The parent account details show actual balance at all times.

Inputs are straight forward and work well.

Now, I can edit the transaction (deposit or withdrawal) ad have the portal line balances all reflect a change if a monetary amount changes, no matter which portal line was edited.

However, changing date and having the portal then resort on date and reflect line balances to alter with that date has me tossed.

For example.  Say on line 6 of a portal you had a date entry of Jan 1, 2011 and a deposit of $1,000 showing a line balance at that time of $15,000.

What happens if the entry needs to be edited to June 1, 2010 , that is moving the entry to say line 2 on the portal.  How can I get the line balance to now reflect what it should have been based on the previous line

On a spreadsheet this is easy.  Do I really need to go and trap the previous line (in this case line 1) and start a whole new calculation script . A screen photo is attached

I guess what I need is a calculation for the field holding the line balance that will update based on the line above, a sort of running balance.  Is there an easy way to do that please??

Cheers

Jim
cashbook.png
0
Comment
Question by:jim_pilot
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 

Accepted Solution

by:
jim_pilot earned 0 total points
ID: 35169372
Hi,
after doing a few hours or research in various forums I have found this script works perfectly both for editing and amount plus a date change in my layout portal.

I have attached a screen shot in case it helps someone else.

By way of explanation:  the Parameters table fields are all global fields that I use instead of variables.

so for example, Parameters: param_adjust is a number global field that I use to trap the line balance of the row above the active row.

The DividendsShareEntry is a TOC with various fields storing payment, deposit and the line balance.

It was easier than I thought possible.
Thank you Mr Filemaker.
Cheers

Jim





script.jpg
0
 

Author Closing Comment

by:jim_pilot
ID: 35169373
Hi, I was able to suss this problem out by studying various forums.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question