Page 1 of 1

Really cool framework. Need a little help though.

PostPosted: Mon Aug 24, 2009 2:03 pm
by effgee
I've been struggling with Filemaker for some time but its non intuitive and non standard SQL syntax really kept me from progressing.

I have made alot of progress with Xataface but I still am really confused on how to progress.
I've used the basic layout to accomplish related tables and insert sample data and display related records, but I am unable to progress from here.

I have a very simple application.

I have a Product.
Each product has many synths.
Each synth has many steps.
Each step has instructions and related materials per step.

How can I change this from editing each record, to a more "app" like interface.

My code can be downloaded from here. (8kb) sql included.
http://www.mediafire.com/?sharekey=6995 ... f6e8ebb871

I have more features to add in the future, but I cannot seem to get past this block.

PostPosted: Tue Aug 25, 2009 1:44 pm
by shannah
What do you mean by "more of an app"? You have a few options for optimizing the workflow. If you can describe how you would have set it up to work in Filemaker, I may be able to suggest a Xataface configuration that will be comparable.

PostPosted: Wed Aug 26, 2009 5:31 am
by effgee
Steve,

Cool, I will get back to you in a little. Time constraint issues.

Once again..
Just wanted to say awesome job with this framework.
It its very useful, and easy to work with.
In fact I haven't found anything else quite like it.

PostPosted: Wed Aug 26, 2009 3:35 pm
by effgee
Here is an example of what I am thinking of.
I didn't have the time to do it in Filemaker, but here is a HTML mockup.

There are a few things missing from the SQL that I uploaded regarding information presented in the layout/template.

Such as, Material_Amount, Material_unit, Step_Time, Step_Title

But the general idea is there.

Image

PostPosted: Thu Aug 27, 2009 11:02 am
by shannah
To get it looking exactly like this you would need to create a custom action. It wouldn't be all that difficult.

You can get a similar effect by simply creating relationships from:
Products to Synths
Synths to steps

In the synths table you would use the grid widget to be able to edit the steps directly in the edit form.

It would provide all the same functionality and with *almost* the same steps.