Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4868 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I have a Clients Table + a Jobs Table.

I have a Relationship of Jobs to Jobs where (IDclient and the Year Job was created Match)

Because I want to create a unique job number that identifies the year it was created + order in which is was requested by the client.

I have set a portal in the Jobs Layout to

display Jobs related by id +year.

Sorted in descending order.

This portal is displaying a unique job number utilizing...

The last 2 year digits (date_year)

The client code (client_code)

and the portal row number via Case( Clients::IDClient; Get( RecordNumber))

ex.

11-ME001

11-ME002

11-ME003

The example above is my job number, which displays correctly in the portal.

How do I get that number to display on the individual Job Layout?

I hope I was clear. I need to get back into database and filemaker lingo.

Thanks.

Posted

Thanks. I understand the rationale in the link.

Totally makes sense...

But I still would like to utilized this naming convention.

Jobs created in filemaker are associated with files on the harddrive.

Using a numbering system like is more efficient for the finding of files.

So are there no real options?

Posted

Well in my dream world it world a script would create the initial folder and all the subfolders.

But right now it's just manually.

Posted

It doesn't have to be a dream - see, for example:

http://fmforums.com/forum/topic/79232-using-applescript-in-fm-pro-10-on-mac-os-x-to-create-a-folder

And if you create the folder/s after creating the record in Filemaker, you can use ANY unique identifier to link between the two. You can also have Filemaker open the related folder, using either AppleScript or Open URL{} script step.

Posted

Thanks for the link! A bit over my head, but who knows. I may give it a shot!

This topic is 4868 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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