Jump to content

format page creates new record in other db


This topic is 8415 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

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

smile.gif" border="0

Link to comment
Share on other sites

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

smile.gif" border="0

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! crazy.gif" border="0

Link to comment
Share on other sites

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?)

Link to comment
Share on other sites

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! cool.gif" border="0

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8415 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.