Hi,

can anyone help??!

I am trying to edit multiple records in a database from the same page.

I have entered the page with a -find on all the relevant records - I then want to change one field in all of the records to the same value.

I figured using an inline action from within the [FMP-record] tags would be the best bet - but it doesn't seem to work: Here is the code that I have been using:

[FMP-record]

[FMP-inlineaction: -db=*****, -lay=****,-edit, format={currenttoken:5}]

[/FMP-inlineaction]

[/FMP-record]

I am trying to set the format field to the value of token 5.

can anyone shed some light on how to use Inline actions.

thanks

InlineAction doesn't require the -Format tag, as its results are returned within the [FMP-InlineAction]...[/FMP-InlineAction] tags themselves.

Use this basic structure as an example:

code:

---

[FMP-InlineAction:-DB=database.fp5, -Lay=layout,-FindAll]

[FMP-Record]

.

.

.

[/FMP-Record]

[/FMP-InlineAction]

Note that this tag, like others, must be processed by Web Companion, i.e. InlineActions can only be used on -Format pages returned from FileMaker.

quote:

---

Originally posted by Garry Claridge:

The -recid seems to be missing. You will need this to edit a record.

I guess the field named 'format' is a little confusing, however it should be fine.

---

Whoop -- confused me, that's for sure. Sorry for my misleading reply.

The -recid seems to be missing. You will need this to edit a record.

I guess the field named 'format' is a little confusing, however it should be fine.

All the best.

Garry

Thanks for your notes - the trouble I have is that I am picking up someone else's work - hence naming a field format (they have even named a field recid!!).

I can access the inline action data fine, it's just using an -edit on the data. Is it possible to edit with an inline action?

Thanks again

I just tested editing with an InlineAction and it worked fine. This is what I used:

[FMP-InlineAction: -db={CurrentDatabase}, -lay={CurrentLayout}, find_url="From Inline", -recid={CurrentRecID}, -edit]

[/FMP-InlineAction]

Good Luck.

Garry

The Bridge wrote

quote:

---

InlineAction doesn't require the -Format tag, as its results are returned within the [FMP-InlineAction]...[/FMP-InlineAction] tags themselves.

---

This doesn't help the original question, but a format tag is the only way I've found to get some inlines to work properly - a portal in an inline or the '-LinkPrevious, -LinkNext' are examples. The format is obviously the same page.

I thought I'd mention this as it took me ages to find and the FileMaker documetation on inlines is real sketchy.

regards, Jeff

...oops sorry, wrong here. You need to specify the format to make '-LinkPrevious, -LinkNext' work, but you need to specify the layout to make a portal work.

Isn't the 'edit post' button useful?

[ February 07, 2002, 07:17 AM: Message edited by: Jeff Spall ]

quote:

---

Originally posted by Jeff Spall:

... a format tag is the only way I've found to get some inlines to work properly - a portal in an inline or the '-LinkPrevious, -LinkNext' are examples.... the FileMaker documetation on inlines is real sketchy.

---

I couldn't agree more; thanks for passing along that tip!

So was there any agreement on a way to edit multiple records from one page? I'd like to do this as well. Any way it could be done would work for me.

Thanks,

Carrie

Since the -edit tag requires a -recid tag, it should follow that only one record may be edited at a time. Unless you can figure out how to effectively present more than one -recid.

While a script might handle such an event, caution would be necessary since editing a hundred or more records could take some time and tie-up others from access. And loops are to be avoided entirely.

After posting the above I opened a FMPro db which I use for experiments. Looked at the possibility of editing the records of a found set. Using ScriptMaker such an action is possible using the Replace command. This could resolve the time issue. Setting it up as a browser solution to run safely should take a bit of creativity.