Filemaker Pro 12

I have a database with two tabs. In the first tab, I have fields labeled "first" and "last" which comprise a client's name. in the second tab, I have a field "full name". I'd like to create a button or a check box on the first tab, that, when selected, will insert and concatenate the first and last name from tab one to the full name in tab two. This needs to operate for case by case for each record. I cannot figure out the steps or the script for this. Appreciate some helpl. Thanks.

I think what would really help is if, based on the info I provided, you could just write the script with the "if" statement and explain the steps involved in "binding". A copy of the file is attached to make this easier. Thanks.Contacts-experiment-Copy-Clone.fmp12

Ok, I've setup a script in this file called UpdateLeadFullName, and I've used a script trigger to bind that script to the drop down field you have (I don't see check boxes..??)

If you go into layout mode and right click on the drop down field you'll see a Set Script Triggers option. Go into that and you'll see how I've bound the new script to this item via script trigger. Any time that value changes it runs the script.

This probably wouldn't be ideal, because if that value was set prior to the name getting filled in and then never touched again the script wouldn't run, but this will at least give you an idea of how it's done.Contacts-experiment-Copy-Clone.fmp12

OK, great. Almost there. If I wanted "Company" in the leads tag to equal "Company" in the "Contact" tab using the same trigger, would I just add another If statement? How should that read? Also, when I open the file, it shows a contracted form view and I have to select an icon to the left of the name for the full form to show. Is there a way to default to full form when opened? Thanks so much for the help.

You would just add an additional Set Field statement into the existing If/Then code. That is, if you're still basing it on that value equaling Client. If you need to make changes based on different values for that field you would use Else If statements.

That said, the way you have it right now the Company field is the same for both tabs (Contacts::Company) so you if you change it in one place that same change will take place in the other. You would need to separate that into separate fields (or even better, separate tables) in order to keep them separate from each other.

For the layout that it's starting on, your file actually has some logic in place to decide what layout to drop you on.

If you go to File -> File Options, and then click into the Script Triggers tab you'll see that it's currently setup to run the "Trigger | On First Window Open" script when that window is first opened. So then if you open up that script you'll see it's checking whether or not they're on an iPad or in regular FileMaker Pro, and based on that it sends them to the Contacts layout. So in your case you could simply change that line.

Go to Layout["Contacts"] and Go to Layout["Contacts | iPhone"] would be come Go to Layout["Contact Details"] and Go to Layout["Contact Details | iPhone"] accordingly.

By the way, it looks like you'll be needing a lot more help on this thing if you're struggling with these basics. Sites like this are great for that, but you might find value in my training services I offer. If you're interested in more information on that please contact me directly.

Featured Post

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …