Northbay

I want to create a global text field to put tech journals. It's supposed to be big. Seems OK for now, but I'm just worried about sometime in the future ...

So that mean the maximum limit for a single text field is just 10,000,000 characters, right?

comment, based on Krim M's explanation, may I say the maximum a text field can hold is "10,000,000 characters x 32,000" ?

Yes, that's the first one I searched. I just still have no idea how many a text field will hold finally because I can't find any explanation for "10,000,000 characters per field per repetition" before Krim M give one.

Thanks for the explanation, Kris M. Hi comment, yes, it's not a official source because I can't find any. The link is here. By the way, do you know any info about the maximum of a text field, i.e. 2GB or something else?

Looking for text field limit for FileMaker 14, and this is what I got: 2GB, or "< 10,000,000 characters per field per repetition (limited by available memory)". This is where I got confused. What does it mean "10,000,000 characters per field per repetition"? It definitely not is the length of the full text, I believe.

Got it. I'll just need to create a script trigger. Thank you, eos, really appreciate!

Thanks, eos. This is a great idea! But is it possible to make it within a single portal? Because I use the portal for both creating and selecting record. When I click a portal row within the portal on the left, that specific record will be shown on the right. If I do it with a separate single-row portal, it will be a little bit awkward to show record from different TOs at the same location of the layout.

When creating a new record via relationship in a portal, the empty row for the new record is always pushed to the end. Can we, in some way, put the empty row on the top so we don't need to scroll all the way down? I did search this forum and found a couple topics on this, but, for some reason, all the attached demo files are missing and can't be downloaded. Can anybody give me an idea or show me a demo file? Thanks so much!