Jump to content
AlesD

Layout sharing?

Recommended Posts

AlesD    0

Hello,

I would like to ask question for which I didn't find answer. I have several filemaker dbs which differs only by data entered. All tables and fields are same. My question is if it's somehow possible share layout design across all those databases because occasionally I need to modify that layout. Change it in all dbs could be time consuming. Of course I can have empty "design db" where I could re-import data after layout change but again it could be time consuming too.

Also I'm wondering if is possible to use field name (in layout) without any table name and table would be used relative by table defined in layout? (Shows records from)

 

Thank you

 

Share this post


Link to post
Share on other sites
Fitch    148

Maybe you should look into the separation model.

 

  • Thanks 1

Share this post


Link to post
Share on other sites
Lee Smith    145

Are you referring to sharing your Theme though out the files?

Your Profile shows 12 Advance, have you upgraded?

Share this post


Link to post
Share on other sites
AlesD    0

Separation model working as I wanted thank you for tip. I didn't know changing file in External Data Sources dialog changes content instantly without any extra work. Thank you

Share this post


Link to post
Share on other sites
Fitch    148

Glad I could help. FYI in FileMaker 16 you can now set the data source as a variable, so it can be scripted.

Share this post


Link to post
Share on other sites
AlesD    0

One more recent question. I have replicated my filemaker tables also in mysql. All names (tables & fields) are same. I've also keep same creation order but  when I change my data source to mysql via ODBC connection all relations gets screwed. That means wrong fields are connected between tables. Any hint how to fix it? For migration I've used FM pro Migration proggie.

Thank you 

EDIT: it seems custom order causing this problem and need to check that out

Edited by AlesD

Share this post


Link to post
Share on other sites

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


  • Similar Content

    • By Stickybeak
      I generate an invoice by a report.
      The work is totalled and then VAT/GST is calculated and the total work + GST = the invoice value.
      These 3 fields appear in a trailing grand summary. One above thew other above the other:
      Total Work
      GST
      Total this invoice
      Depending upon the number of items in the invoice the invoice may have more than one page. Again depending on the precise number of items in the invoice I can finish up having 2 of the 3 summary fields on one page and the remaining one on another page.
      I would like to be able to print the invoice knowing that the 3 summary fields will be kept together irrespective of the number of items, or pages or where the page break occurs.
      I cannot see how this can be achieved.
       
    • By surgite71
      Greetings and thanks for giving this a look!

      I am rebuilding a client's database that was done formerly in PHP. I'm now using FM 16 Pro Advanced. There is one print layout I'm having trouble recreating.
      There are a number of data fields the realtors fill out...some get filled in, other times some don't. In addition it needs to print the name of the data field then the data itself, so for instance "Construction  Stick Built". I've figured out how to go through and print only the fields (and their labels) that have data. The issue I have is with the spacing in the columns.
      In the attached photo, you can see that each label/data line is neatly organized in a column so that the space between the label and the data is consistent all the way down the column. It's not centered, and it's not justified...it calculates for each row of data, how much space is needed in that row to line everything up.
      Would I need to determine how wide the column is, and then calculate how long the combo of the field name and data is (with that nice separator space in between them) and then use that to space everything? Seems like a lot of calculations going on but maybe that's what needs done?

      I also need to figure out if the data will require it being in 1 column or using a 2 column like the one in the picture. I believe I can figure that out...it's this 2-column alignment/spacing that's got me tied up.
       
      Thanks!

    • By Dimitrios
      Hello,
      I am not sure if this is a tip, or if it is already known.
      Anyway it has a practical value for me so I thought I post it.
      Sometimes I need to present data in a layout with several sub-summary parts and usually no body parts
      I find it good interface, to give the user the ability to click on the only visible sub-summary part and reveal the next part in the hierarchy, and so on...
      Thus expanding and collapsing the list by clicking on the headers.
      From what I read in the forums the standard technique for this is to have a global variable to store whether part X is expanded or not.
      I don't like that method very much so I thought of an alternative.
      Layout  Example Structure
      Sub-Summary Part1   (based on COUNTRIES::Name)
      Sub-Summary Part2   (based on COUNTRIES::CityID)
      Sub-Summary Part3   (based on CITIES::SalesmanID)
      To the right of the sub-summary part, just off screen we put an instance of the field we are sub-summarizing by. 
      For example, inline with sub-summary Part1 we put an instance of the field COUNTRIES::Name and we name the Object as "Part1"
       
      Now if the sub-summary part is visible using the following :
      GetLayoutObjectAttribute ( "Part1";"source" ) will give us "COUNTRIES::NAME"
      or if the sub-summary part is not visible will give us error 102 (Field is missing)
       
      By looping with a $counter variable through all sub-summary parts (1....n) 
      we can get a list of the visible sub-summary parts (the fields they are based on)
      Then we can use this information to sort the records anyway we want to.
       
      That's it!
      I think it would be nice if someone thought a way to have the list sorted in the way the parts are presented.
      Thanks, Dimitrios
    • By 123
      Hey,
      I want to use the same header on all my layouts in FileMaker Pro 15 Advanced but I can't seem to find a way to accomplish it. I read on Google and other forums that there is no way to do it, however the posts I found are all at least a year or two old. Did they add a way to do it in FileMaker 15 or do I still need to duplicate a layout to get the same header on a different one?
      Thanks in advance,
      Mike
×

Important Information

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