format page creates new record in other db

[timmy]

i think this should be fairly simple. whenever a particular format page of mine is visited, i want it to create a new record in a database named "tracker.fp5" i want it to do this automatically. no buttons or anything. how do i do this? thanks a million,

tim.

[dspires]

It depends exactly how you want it to work. Either way it will be with a redirect page. The contents of the redirect page will have the following in the head portion:

<META http-equiv="refresh" content="0;URL=FMPro?-db=yourDB.fp5&-format=nextFormat.html&yourFieldsGoHereForInstanceClientAddress=[FMP-ClientAddress]&-New">

The only complication would come if you wanted the record redirect page and format page to be the same format page. In that case (I haven't done this) I would try an FMP-If tag together with a token being passed if the record has been created (page visited).

[Anatoli]

quote:

---

Originally posted by timmy:

i think this should be fairly simple. whenever a particular format page of mine is visited, i want it to create a new record in a database named "tracker.fp5" i want it to do this automatically. no buttons or anything. how do i do this? thanks a million,

tim.

---

[FMP-InlineAction: -db=tracker.fp5, whois={CurrentToken: 1}, page=searchpage, -New] [/FMP-InlineAction]

will create new record in db tracker.fp5 and populate fields whois and page

with values of {CurrentToken: 1} and searchpage

[MeltDown]

quote:

---

Originally posted by Anatoli:

[FMP-InlineAction: -db=tracker.fp5, whois={CurrentToken: 1}, page=searchpage, -New] [/FMP-InlineAction]

will create new record in db tracker.fp5 and populate fields whois and page

with values of {CurrentToken: 1} and searchpage

---

Hey Anatoli - Would you mind explaining what triggers the in-line action to run?

Are you replacing the "URL=FMPro?..." string in the Meta-Refresh tag with the in-line action?

Or are you saying the in-line action would run automatically when the page is accessed, without the meta-refresh? If it will run automatically, what part of the in-line action tells it to auto-run without a submit?

Thanks so much for your help!

[Anatoli]

InLines are processed by page flow. In theory you can have unlimited number of InLines.

That is really beautiful stuff. I did log for all possible actions in our existing PR portal for Press.

With InLine it took me less then hour to redo all 25 HTML pages inclusive of tests.

FileMaker Rocks and Rules!

(I would say that, wouldn't I?)

[MeltDown]

I'm impressed! Can't wait to get that good! I'm working with the office 'FileMaker Guru' to develop/expand an on-line training registration and tracking system with 150+ active htms. We haven't had any success using In-Line Actions, but it sounds like learning more would be well worth our time. Thanks for the reply!

[Anatoli]

My syntax was copied from working pages. I do found sometimes the InLine syntax confusing.

And do not forget to include the LOG database in Web Security for All visitors Create, Edit!

WC version 5.03 was working even without security database and that was changed.

[timmy]

the inline action works great. one more problem though, i have a button on my page that links to another page. in addition to linking, i want this button to create the new record. is there a way to tie the inline action to a button?

[timmy]

on second thought, if its in a button it isn't really an Inline action, is it? well regardless, how would i make a button that links to something AND creates a new record in a database? thanks a million guys,

tim.

[Anatoli]

You can link and create record, but not in two databases.

Just include another Inline on the page you are calling.

[timmy]

let me clarify: the button links to a page that i dont control. for example: the button will link to www.yahoo.com

when the user clicks on the button, i want that button to write to a database AND to go to www.yahoo.com

make sense?

[Anatoli]

Now I see; just from top of my head, create link for new record and try to include the yahoo link.

Or the same through JavaScript.

Or create blank response page after the new record was created with META redirect with 0-sec delay goto yahoo.