![Accelerate Computer Training](/img/default-banner.jpg)
- Видео 58
- Просмотров 563 550
Accelerate Computer Training
США
Добавлен 11 июн 2010
Long Beach, California-based Accelerate Computer Training provides high quality instructor-led training in today's end-user software applications in its public training classes. Visit www.acceleratecomputertraining.com for more information.
020: Import and Export Data: free training webinar for FileMaker Citizen Developers
FileMaker can import data from many different sources, but it is rarely simple. Data from one source sometimes needs to land in separate tables. And what about field validation rules? Can we import a batch of images? What if the source data has no primary key values? In this webinar, I employ several easy yet powerful techniques to overcome these obstacles. We will create temporary fields, temporary relationships, write calculations, and use the Replace Field Contents command to enter the missing data after importing that will solidify relationships between records and make up for what your Excel data did not have. In some cases, where it makes the job easier, we’ll take the reverse appro...
Просмотров: 653
Видео
Relational Database Design: Data Modeling for Beginners Part 2 of 2
Просмотров 1 тыс.Год назад
In Part 2 of this two-part video series, we complete the discussion of how to plan your relational database structures by learning to determine the relationship cardinality, or type of relationship, between entities: one-to-one, one-to-many, or many-to-many. We also learn how to resolve many-to-many relationships by inserting a join table. And lastly, we complete the Entity-Relationship Diagram...
Relational Database Design: Data Modeling for Beginners Part 1 of 2
Просмотров 2 тыс.Год назад
The objective of this two-part video series is to teach you the skills and strategies used to plan the structure of new relational database systems. The emphasis here is on structure, what the database will contain, not interface, or what it will look like. Our target audience for this session is the non-technical user who needs to track related sets of information but wishes to improve their u...
Excel 365 for Beginners: Building Your First Worksheet
Просмотров 1,3 тыс.2 года назад
This Microsoft Excel 365 training video is for extreme beginners. You're going to learn about Excel workbooks, how to make new worksheets, how to make and edit and clear entries, how to undo mistakes, and how to create and duplicate simple formulas.
026: Securing Database Solutions: free training webinar for FileMaker Citizen Developers
Просмотров 4192 года назад
User accounts are the key to letting the right people in and keeping the wrong people out of your database solutions. Accounts, however, are just the tip of the iceberg. In this session, we will explore using Privilege Sets to control what users can see and do once they log in successfully. We will also use Extended Privileges to control what connection methods they can use to access our databa...
025: Container Field Basics: free training webinar for FileMaker Citizen Developers
Просмотров 7542 года назад
Container fields can store files of any type in a FileMaker database table. In this session, we will discuss ways to insert files into container fields from desktop and mobile devices, how to interact with container data, referenced and calculated containers, and remote storage of container data. Webinar led by FileMaker Certified Developer and Claris Training Partner, Tim Jones.
024: Use JSON to Pass Data: free training webinar for FileMaker Citizen Developers
Просмотров 2,6 тыс.2 года назад
Javascript Object Notation (JSON) is a convenient plain text language for packaging and passing data between environments, and the JSON functions available in FileMaker 16 and above make it easy to take advantage of this handy tool for passing data into and out of scripts and web services/APIs. In this webinar, you will learn the JSON syntax and FileMaker's JSON functions to see how you might i...
023: ExecuteSQL Function Applied to Dashboards and Charts: free training for FileMaker Developers
Просмотров 1,7 тыс.2 года назад
In our last session, we examined the syntax of FileMaker's ExecuteSQL function and wrote basic SQL queries. Now let's apply our knowledge of ExecuteSQL to present summary calculation results on dashboards and provide source data for charts. We will discuss unstored calculations as we optimize performance of our dashboards; employ the SQL functions COUNT, SUM, and MONTH, and SQL clauses JOIN, GR...
022: ExecuteSQL Function Basics: free training webinar for FileMaker Citizen Developers
Просмотров 2,8 тыс.2 года назад
The ExecuteSQL calculation function is the most unique function in FileMaker's collection. It allows us to find and retrieve data or a summary result from a table occurrence even if no relationship exists between it and the current table occurrence context. We can use it in field definitions, charting, tooltips, certain script steps, anywhere we write calculations. In this webinar, I will show ...
021: Create Charts from Your Data: free training webinar for FileMaker Citizen Developers
Просмотров 1,8 тыс.2 года назад
FileMaker's Chart tool lets us present data graphically on layouts using seven different chart types. In this session, we will learn how to prepare data to be charted, how to create charts, how to use QuickCharts, and how to format charts to look their best. Webinar led by FileMaker Certified Developer and Claris Training Partner, Tim Jones. If you would like to do the exercises along with Tim,...
Intro to Mac OS X for Windows Users: Live Public Training Class
Просмотров 3,2 тыс.3 года назад
If you have a Windows background and now have to use or support Mac OS X computers, this class will give you much-needed instruction. In this nearly three-hour recording of a live, public training session, you will gain skills vital to using a Mac effectively, including exploring the computer hardware, using the mouse and keyboard, working with Mac Finder windows, launching applications, creati...
019: Web Viewer Basics: free training webinar for FileMaker Citizen Developers
Просмотров 1,3 тыс.3 года назад
FileMaker's Web Viewer tool lets us display on a layout a live web page that is driven by data from our database. FileMaker Pro includes templates for several popular data-driven websites, including Google Maps and Wikipedia. We can also point a Web Viewer to a web address stored in a field, and even insert our data into a website URL by writing a calculated expression. In this session, we will...
018: Perform Script on Server: free training webinar for FileMaker Citizen Developers
Просмотров 6223 года назад
The Perform Script on Server script step can dramatically improve performance of certain scripted operations. In this session, we will explore what it is, how to use it, when it may be advantageous, and the mistakes and pitfalls we should avoid when using Perform Script on Server. Webinar led by FileMaker Certified Developer and Claris Training Partner, Tim Jones.
017: Data-Driven Navigation Part 3: free training webinar for FileMaker Citizen Developers
Просмотров 3033 года назад
The final step in building our data-driven navigation system is adding a Back button so that, just like on the Web, our database solution users can click Back from any layout to retrace their steps through the layouts they have visited previously. We will write a script and use a global variable to keep a history of layouts visited, and then simply walk them backwards through it when they click...
016: Data-Driven Navigation Part 2: free training webinar for FileMaker Citizen Developers
Просмотров 3823 года назад
Now that we have a navigation bar on every layout that we can update from a table of records, we will take a closer look at the scripts that give the nav buttons their functionality. We will focus on writing fewer, smarter scripts, rather than many small, redundant scripts. That way, improvements we make to any script will have a broader impact. I will also describe why I no longer use the Go t...
015: Data-Driven Navigation Part 1: free training webinar for FileMaker Citizen Developers
Просмотров 7723 года назад
015: Data-Driven Navigation Part 1: free training webinar for FileMaker Citizen Developers
014: WebDirect: free training webinar for FileMaker Citizen Developers
Просмотров 2,2 тыс.3 года назад
014: WebDirect: free training webinar for FileMaker Citizen Developers
013: Custom Menus: free training webinar for FileMaker Citizen Developers
Просмотров 8773 года назад
013: Custom Menus: free training webinar for FileMaker Citizen Developers
012: Value List and Text Parsing Functions: free training webinar for FileMaker Citizen Developers
Просмотров 1,1 тыс.3 года назад
012: Value List and Text Parsing Functions: free training webinar for FileMaker Citizen Developers
011: Passing Data In & Out of Scripts with Script Parameters & Script Results: free training webinar
Просмотров 1,3 тыс.3 года назад
011: Passing Data In & Out of Scripts with Script Parameters & Script Results: free training webinar
02 Build the Excel Data Sheet Correctly for Creating a Visio Organization Chart
Просмотров 22 тыс.3 года назад
02 Build the Excel Data Sheet Correctly for Creating a Visio Organization Chart
03 Connect Visio Pro 2019 Organization Chart to Excel Employee List
Просмотров 14 тыс.3 года назад
03 Connect Visio Pro 2019 Organization Chart to Excel Employee List
01 Run the Visio Pro 2019 Organization Chart Wizard
Просмотров 4,7 тыс.3 года назад
01 Run the Visio Pro 2019 Organization Chart Wizard
010: Save Records as PDF: free training webinar for FileMaker Citizen Developers
Просмотров 1,4 тыс.3 года назад
010: Save Records as PDF: free training webinar for FileMaker Citizen Developers
009: Script Triggers: free training webinar for FileMaker Citizen Developers
Просмотров 5773 года назад
009: Script Triggers: free training webinar for FileMaker Citizen Developers
008: Summary Fields and Subsummary Reports: free training webinar for FileMaker Citizen Developers
Просмотров 1,8 тыс.3 года назад
008: Summary Fields and Subsummary Reports: free training webinar for FileMaker Citizen Developers
007: Using Global Fields: free training webinar for FileMaker Citizen Developers
Просмотров 7013 года назад
007: Using Global Fields: free training webinar for FileMaker Citizen Developers
006: Styles and Themes: free training webinar for FileMaker Citizen Developers
Просмотров 7133 года назад
006: Styles and Themes: free training webinar for FileMaker Citizen Developers
005: Intro to Mobile-Friendly Solutions: free training webinar for FileMaker Citizen Developers
Просмотров 5713 года назад
005: Intro to Mobile-Friendly Solutions: free training webinar for FileMaker Citizen Developers
004: Calculations and Custom Functions: free training webinar for FileMaker Citizen Developers
Просмотров 7173 года назад
004: Calculations and Custom Functions: free training webinar for FileMaker Citizen Developers
Tim- this series is really a tour de force. I frequently rewatch it periodically just to refresh. I really hope you’ll find the time to do another one here on RUclips. Most professional training on FM that I’ve come across so far.
This is really clear and helpful, thank you
This is a good video.
I don’t understand why anyone would want to write out all that value data in such a complicated form. I thought the whole point of JSON was to pass your data from Filemaker to someone else or a website, or to retrieve data from a website. Why would anyone want to write in the specific values? Those specific values are already in the database. What am I missing here?
Very helpful Thank you
Double like!!!! Thank you for this video!
I searched for weeks looking for this kind of ExecuteSQL function training. Fantastic, and I am on my way. The adding function in a script is terrific.
Great explanation... what about field names with spaces?
Absolutely fantastic. The only one that enable me to successfully generate an org chart in Visio from Excel with no errors. Thank you very much!
Thank you very much for the great explanation about excel date combining with Viso organisation charts.. I have still one question. You said in the video that all the shape information will be visable after refreshing even you have not selected them but how do I make this dat unvisable again?
This is awesome!!!!!❤
Thanks!
Can someone share the link for visio professional?
Thank you!!! Great Video!!!
Tim's 1:1 are very productive. I've never learned so much pertinent information in 1 hour before. thank you! Lisa G.
The best spent 56 minutes and 5 seconds of recent Filemaker times. And, through watching your style, my developer habits are slowly becoming good habits. 👍👏
This is the best explanation of this I have seen. I wish I had seen this years ago. \"Thank you\"
Amazing, this is exactly what I have been looking for! Thank you very much!!!
Great video. Im new to FileMaker and was wondering how to start building my first app, when I chanced upon this video. The part about selecting nouns and then sorting them as Entities or Attributes is pure gold - its very fluid and makes a lot of sense! Thanks Tim!
Do you need to quit or close the user session that is created on the server when running a PSOP or is it automatically ended after running the script.
Thank you! The quality of the video and the explanations are amazing
This turned a dead end into a four-lane highway for me. Thank you!!! Comment/tip: There is no "Link Data to Shapes" button in Microsoft Visio Plan 2 MSO (Version 2311 Build 16.0.17029.20140) 64-bit, but you can use "Custom Import" which provides that function. Then there is no "AUtomatically Link" button so you use "Link Data" in the Advanced Data Linking section. Question: Is there a way to add a custom org chart format to the OrgChart Shapes tab in the ribbon (or modify an existing one) so that the initial generation is in your desired format?
Very nice! now how do you link an org chart and a spreadsheet that were not created using wizard?
Hi, I have problem. When take from external data my new emloyee, a have in box just name of position and no name, just tittle. Do you know how setting it?
what if we change a manager? In my org chart I have changed the manager of a current employee in the excel data but it doesn't change the shape even though it is linked, I can see the shape data is correct but the actual shape does not move. I have tried to click Re-layout.
So how did you even get a worksheet open? Aplenty I'm even worse than a beginner. Frustrating. Bad tutorial.
Explained in a crystal and clear way. Thanks
Hi, thanks for this informative video, I am facing a problem, it says unable to read names from your file
I make program for Invoicing , contain table Invoice and Invoice line. Which one is the correct one for the Total Invoice: 1. Calculate from Invoice table -- sum(invoice:line amount) 2. or Calculate from Invoice line table using summary function -- summary (Total of : Amount) What is the pros and cons between those two way?
I have problem in printing the List. I need to make a report from the list, I dont want my subsummary is separated in the previous page. by instering the page break, this way also not as i wish where I want to fill up 1 page with several subsummary. sorry for not very clear explanation.
If you want multiple subsummary parts on the same printed page, you should not turn on any of the page break options. It may also be useful to delete the Body part. We are not required to include a Body part on a layout. If you remove the Body part, the report will not include any real records from the table; it will only include the subsummaries (and grand summaries, if you have them).
@@AccelerateComputerTraining Thank you for your help. I have long list in my report. so whenever the report reach the end of the page, sometimes, the "parent" subsummary is left in the previous page where the "child" subsummary is on the other page. For example: My Employee is the "parent" subsummary where the Products Sales is their "Child" subsummary -- 1 page could contain several Employees and their Sales, however sometimes the name of the employee goes at the end of the page and the Product goes to the next page (it makes inconvenience to see whose sales this belong too . I hope I explain this more clearly. Thank you
In FileMaker’s Layout mode, we do not get much control over where page breaks fall. There is no “Keep with next” option to prevent child records from being separated from their parent subsummary. Try putting a page break before each parent subsummary.
@@AccelerateComputerTraining Thank you so much for your Help
Excellent training, simple and full❤
Whenever I add records it copies over whatever data is presently in the table.
Hello there. Thank you for sharing your video. I was attempting to use the store data externally, but I would like that data on a different volume on the server. for example, filemaker resides on volume "C". I would like my data from containers on volume "F". I enabled external on server and added the container path as well. when i go to the DB and go to EDIT-->Manage-->Container, the option to add a path is greyed out. I am unable to add one. I do have admin rights and have advanced tools enabled. i searched the net and looked through videos but no one covers how to add the path when it is greyed out. any help would be greatly appreciated.
To the best of my knowledge, FileMaker Server does not allow us to store container data files on a separate volume.
@@AccelerateComputerTrainingthank you. that makes no sense for them not to allow such a convenience. This would allow for a cleaner data drive and windows drive. plus in case the c: drive gets corrupted, at least the data is save on the data volume. we do not backups of the server, with backup nightly the full c volume to include data files. more work on end-users to do a granular or selected directory path backups to exclude paths not required.
Hi Thanks for the very useful tutorial. I want my data to be linked to the excel but I do not want the extra info next to the shapes, how do I remove it?
Thanks for helping us. I have a question : If I always import the same csv files again and again with updating information , and looking to update my filemaker file, is there a way or a easy funtion to use to automate the process, instead of choosing each field one by one to when importing data. thanks
FileMaker provides a scripting language that you can use to automate tasks, including importing data, and the script can remember which fields you wish to import and in what order. Once you have written the script, you may then run the script and it will perform all the tasks you wrote into the script very quickly and accurately.
Great tutorial, thanks ! I am trying to prevent users from interacting with parts of my webviewer. As stated at the end of the video, trying to stack a rectangle object in front does not render properly on windows... Is there a way to prevent users from clicking on parts of the webviewer (say, the website's menu bar) ?
Thank you! Hoping I can get some help on a problem I'm having with this, though. If I change someone's name, it will show up as updated when I refresh the data. However! If I change who that person reports to, they do not move within the org chart visually. They will show in the external data window correctly, but not change in the visual on who they report to. How can I fix this so it happens when I refresh the data?
Patrick, thanks for watching, and for your question. Sadly, there is nothing we can do to make that happen automatically. You have to do it manually. Just drag the employee's shape onto their new manager's shape in the Visio org chart diagram. Then click the Relayout button on the Ribbon to improve the layout. I plan to include how to do this in a future video in this series.
Thank you for the response and looking forward to it!@@AccelerateComputerTraining
Great video! However, the TOOL menu doesn't show up on my bar, so I can't access the Data Viewer. I'm just learning to use FM and currently have v16. I would appreaciate the help!
The Tools menu was only available in the Advanced version of FileMaker in versions prior to 17. The Advanced version costs a couple hundred dollars more than the Basic version. When you upgrade to v17 or above, you get Advanced automatically, because at v17, Claris stopped selling two versions of the program. However, in v17 and above, you still have to use the Preferences command and turn on the Use Advanced Tools checkbox and then re-launch FileMaker. Then the Tools menu will appear on your menu bar.
Sir what is the number of default worksheet in ms Excel 365
One
Hello do you mind if you provide file with data so I can practice. I have been so busy studying for job tests that I don't have time to create fake data to practice.
Hi - is there a way to edit the role type column in the Table1 that is the linked table? I would like to add titles that represent my organization's structure. I am stumped - can't find the editable source for table1.
I am sorry, but I do not know what you mean by the "role type column". Is that a column in your Excel data list or table? If so, it was likely available to use as a Shape Data field, as discussed in the video at 6 minutes 36 seconds.
Why don' t you use the ExecuteSQL instead of making all these relationships with zNAV? One ExecuteSQL function on the button name and another in ScriptParameter. Much easier? Or?
I like that idea. I am sure I just didn't think of it, though the expressions are quite simple. We could use this expression for the first button's label: ExecuteSQL ( "select Label from zNAV where \"Order\" = 1" ; "" ; "" ) And this for the first button's script parameter: ExecuteSQL ( "select Destination, \"View\" from zNAV where \"Order\" = 1" ; "¶" ; "" ) For the other buttons, just increment the number to 2, then 3, etc. I would probably change the names of the zNAV fields View and Order to names that were not SQL keywords so they would not have to be wrapped in escaped quotes, just to make the code prettier. I cannot think of anything else that would break, can you? Thanks for the great idea!!!
@@AccelerateComputerTraining it is funny that you did not think of it - I watched your executeSQL video and applied it because of your tutorial....I just call the field "Layout order" no trouble with SQL. In the script parameter of the button I also use executeSQL, very simple and crisp.
Wonderful video, I have learned a lot - a "new world"opens! One comment: I guess you can escape illegal SQL terms, with "SetVariable" first and use ExecuteSQL as calculation?
Very helpful, thank you
Thanks for the how-to... however, I'm curious if when the data refreshes if there is any way for a NEW employee to show up or do I have to drag them out of the external data section and connect them manually?
It's nice to see someone still caring enough about Filemaker Pro to put some nice content up.
Hello, Thank you for this Video, Very useful, I Have a problem, when I change Supervisor in Excel Database, then I refresh, It doesn't appear on vision chart !! Can you help me?
That is normal. Visio is not able to disconnect shapes or reconnect shapes when we change the Supervisor of an Employee on the Excel list. You have to do it manually. To connect an employee to a supervisor on the Visio org chart, drag the Employee's shape onto the Supervisor's shape. After that, you may wish to improve the layout. Try clicking the Re-layout button on the Ribbon; it usually does a good job of moving shapes around to fit better.
@@timjones7188 Understood, thank you Tim . I Think that point does not help to create dynamic organizational chart that communicates with Excel in both directions😏The only advantage of this link is that you can upload and assign easily data like Birth date, recruitment date, salary, etc to each employee in the chart 👌
lekker bezig sjaakie
From Saudi Arabia this is the best mac intro i have ever seen..Tim you r great guy.
Thank you so much for watching and for your kind compliments.