New Record with calculation field

[hasru]

Hi all

I running database using Web Publishing, can anybody show me how to create a calculation field to get automaticly the new record after the last

field is submitted.

hasru

[Fitch]

Could you rephrase/explain a little more? I'm not sure what you mean by "get" the record, or "after the last field is submitted." (A record is submitted, not a field.)

[hasru]

thanks

i try to describe more. i work in web instant publishing. Let say one record have 4 field. get new record after the last field in the record is submitted.

rekod #1

Field 1- (submitted)

Field 2- (submitted)

Field 3- (submitted)

Field 4- (submitted)- When this field is valid then automatic go to new record

record 2

Field 1- (blank)

Field 2- (blank)

Field 3- (blank)

Field 4- (blank)

sorry about my poor langguage

hasru

[Søren Dyhr]

The only real thing you have in this direction is "Allow creation of related records" in the relations setup - but as it happens is it making a new phantom record as soon as you enter something in a field in the previous line in the portal.

It is however not fully embraced as proper UI, if you bring this into the equation:

http://developer.apple.com/documentation/UserExperience/Conceptual/AppleHIGuidelines/XHIGIntro/chapter_1_section_1.html

But as it is would anarchy in web interfaces undermine such rigidity, and your users might even understand what the interface is about if you make a selfjoin allow record creation this way?

--sd

[Fitch]

It sounds like what you want is this: create a "Submit" button on your layout, and attach to it a script something like:

Commit Record

If( IsEmpty( Field 1 ) or IsEmpty( Field 2) or IsEmpty( Field 3) or IsEmpty( Field 4) )

   Exit Script

End If

New Record

You may want to do something more before you exit the script, such as set a global field with an "all fields required" message, or go to a hidden tab with that message on it.

[hasru]

THANKS

that's exactly what i need, I copy all your script and test. i change field behaviour from tab to enter but still not run. Can u email or attach sample file.

hasru

[hasru]

:yay: Thanks..it;s really work

hasru