About portal

[jealindgar]

Hello from Spain,

sorry my poor english

my database is about photos and I want this:

 

I have register A and a field "numphotos" and its portal

I write a number in that field but I need that if I write, for example, a six (6) and that portal generate automatically 6 lines like this one:

 

Field Photo

001

002

003

004

005

006

 

and an other field of my portal I write photographer and description, like:

 

Field Photo (generate automatically by FM)| Photographer (by me) | Description

 

001 | Silkdie Suzan | Me with embassy Loren Driek

002 | Lorraine Hei | Loren Driek, Derick Mujdki and his right is me

etc.

 

did you understand me? smiley-cry

[AHunter3]

Set Variable [$Num, 1]

Go to Portal Row [First]

Loop

Set Field [Portal::Numphotos, "00"&$Num]

Set Variable [$Num, GetAsNumber($Num)+1]

Exit Loop If [GetAsNumber($Num)>6]

Go to Portal Row [Next]

End Loop

[jealindgar]

THANX!!!!!!!!

but where? sorry, my knowledge are poor

[jealindgar]

sorry again, do you know where can I get an example?

 

 

thanx

[AHunter3]

It's a script. You write it in the ScriptMaker and attach it to a button next to your portal.

 

Examples: I could make you one and post it here but you'll have to sign up to be able to download attached files.

[jealindgar]

thanx as usual AHunter3, but i don´t understand you, already i´m sign up

[jealindgar]

What I want to explain you in images

 

 

but that code is wrong in my database smiley-undecided smiley-frown

[AHunter3]

Here you go

 

 

EDIT: Aha, you want to SAY how many and then it makes that many rows.

 

OK, I changed the example file, it does that now.

 

Set Field [Local Table::g.NumPhotos, ""]

Show Custom Dialog ["How many Photos? Type a number" {Input field = Local Table::g.Numphotos} "OK", "Cancel"]

If [Get(LastMessageChoice) = 2]

Exit Script

End If

Set Variable [$Num, 1]

Go to Portal Row [First]

Loop

Set Field [Portal::Numphotos, "00"&$Num]

Set Variable [$Num, GetAsNumber($Num)+1]

Exit Loop If [GetAsNumber($Num)>Local Table::g.NumPhotos]

Go to Portal Row [Next]

End Loop

[jealindgar]

ops, now i understand you, sorry, but i´m not a FileMaker Cafe Member

 

but i´ll try that script in my DB

 

thanx a million!!!!!!!