Add New Record

[Lewis Howell]

I am new to FileMaker and have received excellent answers to other questions today. The answers I have received have opened new doors to my understanding FileMaker. I am a digger, so my questions come after beating my head on the wall :

What I need to do is to add a new record to a table when a user tabs past the last field in a List View.

Thanks in advance,

Lewis Howell

[Vaughan]

Not easy to do in list view.

Easy to do in a portal when the relationship is set to allow creation of related records.

Read up on self-joins.

[Lewis Howell]

Thanks. Being new to FileMake, I had not worked with portals. This is exactly what I need.

[Lewis Howell]

I played with portals and they work great if limiting data in a linked table. I have a table that is a temp check register not linked to anything. A portal initiates a new record how I am looking, but I am unsure how to do this with a List View. Is it possible to capture events, like an after post event or before post event. I do not want to the user to have to click a NEW RECORD button.

[_henry_]

Hello Lewis,

Capturing events? Well, I am not sure if DoScript or ZippScript can help you with your problem. You can read them up on the website (just google it). Hope it helps...

[Genx]

Well, DoScript or ZippScript could help in the following way:

1) Trigger our script on exit of the last field of whatever your last field is - check doco for whatever plugin you use

2) ... I haven't used in FM functions in a while so I hope these are right loool:

If[ Get(RecordNumber) = Get(FoundCount) and Get ( LayoutViewState ) = 1 and Get(LayoutName) = "LayoutYouWantToMonitor"]

/*Essentially - check we are on the last record and that we are in list view, and that we are on the right layout*/

New Record / Request

End If

Edited December 28, 2007 by Guest

[Lewis Howell]

Thanks. I looked at DoScript and it appears to do what I want. However, I am used to doing all my own code and would love to know how to do a plug-in. On the other hand, why re-invent the wheel. My concern though is using something free and not having it avaialable in future upgrades.

[Genx]

I am used to doing all my own code and would love to know how to do a plug-in

I'd stay away from that.

DoScript is likely to continue to be supported, if worst comes to worst you have 2 other equivilants, and the only reason you should really need a new version is if FM upgrades AND changes their plugin engine AND doesn't already integrate event support into that version.

[_henry_]

On the first place, I recommended using DoScript or ZippScript because it is free instead of using plugins (mostly you have to pay). I agreed with Alex (Genx) to stay away from Plugins. Usually, people like Free stuff. However, you are right considering the support. I thought those programs are still supported. If budget is not your main concern, then you can choose which one is the best according to your solution...

[Genx]

I agreed with Alex (Genx) to stay away from Plugins.

Well I didn't EXACTLY say stay away from plugin's, I said try to stay away from writing them - its more of a headache than its worth, there are barely any resources relating to the process, and very few people who can competently do it.

In terms of using the plugins, I've used all 3 and found the authors are keen to work out any issues for all 3 ... not that i've had very many.

Edited December 28, 2007 by Guest

[Lewis Howell]

Trigger our script on exit of the last field of whatever your last field is - check doco for whatever plugin you use

I guess I am missing something in FileMaker. How do I capture the exit of a field?

[_henry_]

Lewis,

You need to read the documentation and sample file from either DoScript or ZippScript. I was reading their demo sample files from their website. One of them can capture event when you exit the Field or even you modify something on the Field. There are some functions that maybe appropriate on your case...

[Lewis Howell]

Thanks...I will download and play with it.

[_henry_]

Lewis,

Here is the link to DoScript 2.0:

http://www.myfmbutler.com/index.lasso?p=416

You can read documentation and study from the sample or demo files...