I've just started using Creator and my initial impressions were brilliant. I'm setting up a simple stock control database and was planning on using filemaker when I came across this suite.
I've had a play around and now I've slammed into a brick wall.
I initially created the following 3 tables/forms:
Item form - So new items can be created to be booked into stock
Stock In form - Items booked into stock go into a list
Stock Out form - Items booked out of stock go into a list
Both of the In/Out forms have a drop down list to select the product to book in which looks up the data from item list.
Finally I grouped the data and asked it to show me totals of stock in and out.
At this point I thought "great, this is going to be easy"
Then I attempted to create a third view which would show a summary of current stock levels based on the quantity goods that have come in and gone out for each item.
Simply a list saying:
Item 1 - 200 Item 2 - 154
I thought this would be just as easy but so far has the solution has eluded me.
I realised scripting using the html view was probably the way to go but have found the learning curve near vertical in that area.
Finally, I hate to criticize something that has clearly taken a lot of effort but from a beginners point of view the help docs on scripting are not very good at all and contain simple errors and poor grammar which is very off putting e.g
Example: In the below given sample, the field
TotalMarks is of type formula,
English and
Maths are the fields in the form.
TotalMarks
(
type = formula
value = English + Arts
)
Any help or a few pointers would be much appreciated and my resulting app I intend to share, I really don't want to give up on Zoho as I think it has huge potential.