Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Action Scripting not working

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • kyosadls
    replied
    Re: Action Scripting not working

    Hi Tim. Thanks for the input, that's kind of the direction I was heading if I did a revamp of the layout. Interesting about companion forms and the sets, (switching the tables) -thanks for that advice. That does give me some more flexibility.

    I just read your tag line - so true!! Thanks again to everyone, much much appreciated.

    Leave a comment:


  • Tim Kiebert
    replied
    Re: Action Scripting not working

    I would like to suggest a slight modification to the suggestion that companion forms opened this way need to be based on a table and not a set.

    I have found that you can still use a set as long as the set has as its parent the table that the embedded browse is based on.

    So you could have a set that has defendants as parent and cases as child linked 1 to 1



    On the topic of simplifying the overall set structure. You said that "the client wanted to be able to see all the "panels" at all time" In the 'Input Form' you have a tabbed object containing all these 'panels' and so you need a set that provides all this info. However you can only ever see one tab at a time. If the form opens to the client tab and the user wants to see cases they still need to take some action like a mouse click or a hot key to view the cases tab. You could provide the same visual effect with a Client form based solely on the client table and a series of buttons that resembled tabs that opened a form based on the cases table. This 'cases' form would have the overall look of the client form so it would appear like just switching tabs.

    Leave a comment:


  • Stan Mathews
    replied
    Re: Action Scripting not working

    What's the best way to do that?
    Calculated field with a lookup.

    Leave a comment:


  • kyosadls
    replied
    Re: Action Scripting not working

    Yes, unfortunately to get the font size that my client wants I have to make the form rather large. Maybe I'm trying to please them too much? LOL I'm beginning to think there's a problem in version 9 with tabbed forms because twice now I've totally lost the tab structure when I accidently grabbed a tab (the focus was on it not the field I wanted to work on) and shifted it to the right and it blows away everything. Thankfully I had made a backup.

    Another thing I discovered is assigning an action script to a button that calls for the xbasic "enter record" wherein you can choose the fields to be filled in. Its pretty much a vertical browse, but would allow the data entry person to see all the fields at once. Good to know! Thanks to everyone, I've learned alot from all this!
    Last edited by kyosadls; 01-08-2009, 03:37 PM.

    Leave a comment:


  • kyosadls
    replied
    Re: Action Scripting not working

    Stan, that was it! I looked and the Contacts form was built only on the Contacts table, and the Defendants form was built on a set, so I copied it over to just the table, put the button on the form and it worked!! Yippeeee!! BUT the client wanted information to display on this particular form at all times from another table (cases), which is why I had built the original form on a set. What's the best way to do that? Add those fields to the Defendants tables and use Field Rules to lookup from the Cases table? I may just put those two fields on the tab form....

    Leave a comment:


  • Tom Cone Jr
    replied
    Re: Action Scripting not working

    Diana, with Stan's help I found your tabs. Had to increase the resolution of my monitor and then stretch your startup form, but there they were.

    Stan's right. Working with the script on the Defendants tab, the "companion form" should be based on the Defendants table. You have it based on the "Clients to Defendants" set.

    Leave a comment:


  • Stan Mathews
    replied
    Re: Action Scripting not working

    The startup form has the tabbed object but opens, on my machine in v8, with the window sized such that the tabs on the right are hidden.

    Leave a comment:


  • Tom Cone Jr
    replied
    Re: Action Scripting not working

    Diana, I can't find a form that contains a tabbed object in the materials you uploaded. What am I missing?

    The xbasic scripts in A5v4 should run just fine in A5v9. In some cases there are easier alternatives now, but the old xbasic should not be a problem.

    Leave a comment:


  • Stan Mathews
    replied
    Re: Action Scripting not working

    I think your companion forms should be built on the table represented in the browse, not a set. This may mean you have to modify their original design so that only fields from the table are on the form, then copy them to the table.


    The companion browse of a form, and verse visa, should be just a change in view, not a view of a separate entity.

    After experimenting, the companion form can be built on a set with the table represented in the browse as part of the set. Only fields from the table should be represented on the form. (Kinda negates any reason to base the form on the set.)
    Last edited by Stan Mathews; 01-08-2009, 03:07 PM.

    Leave a comment:


  • kyosadls
    replied
    Re: Action Scripting not working

    Thanks Tom. This article was exactly on the money with what I've done so far. I have a feeling the client isn't going to like a new design using buttons to get to other information, but perhaps I can mimic the tabbed layout with a clever form. They just aren't crazy about the embedded browses which is why I'm getting into the popup form snag.

    Now the article mentions that "new child records are created with xbasic". If I copy the code in the article and revise it where needed, is version 4 compatible with version 9?

    Leave a comment:


  • Tom Cone Jr
    replied
    Re: Action Scripting not working

    I'll be happy to respond further after you've read the article. I think it answers the question better than I can...

    Leave a comment:


  • kyosadls
    replied
    Re: Action Scripting not working

    Thanks Tom, I'll do that. This client wants a certain look to the database but I'm not sure that it can be done easily in AlphaFive (at least for someone with limited experience). From your experience, are you suggesting that I should completely redesign this? Can I ask why you say that it is poor design for a local area network?

    Leave a comment:


  • Tom Cone Jr
    replied
    Re: Action Scripting not working

    It may have to do with having the main form based on a set that includes all the tables (because the client wanted to be able to see all the "panels" at all time)...
    This is a common request, and it is often very poor design. Especially for applications that are intended to be used on a local area network. Visit www.learn alpha.com. Read the article "Simplify your applications for better performance". Adopt the design principles the author recommends.

    Leave a comment:


  • kyosadls
    replied
    Re: Action Scripting not working

    Pete, I'm really struggling with this. I went back and created a set from client to defendants and created the form and the button and it worked like a charm. Then I went to the main form to recreate it and I can't because of the set that I have to use for the main form.

    It may have to do with having the main form based on a set that includes all the tables (because the client wanted to be able to see all the "panels" at all time) so I added direct links from the client table to the defendant table (see attached). I realize it was a cludgy way to set up the database but I didn't know any other way to provide the client with what they wanted. But it still doesn't explain why the button on the contacts form works...its the same layout and there's no direct link between clients and contacts.....?

    I also added lookups in the case and contact and defendant tables via field rules to pull the clientid from the client table. Still no luck. Why is it saying "Argument is incorrect data type"? I added a DefendantID field to the Defendants table but that didn't change the error. I've redone the embedded browse, no luck. Is there any other way that I can pull the Defendants form to allow a new record entry from a button? This is making me nuts and I know I'll have the same issue when I work on the medical records and medical bills tabs. Thanks for hanging in here with me...

    Leave a comment:


  • trackmanpete
    replied
    Re: Action Scripting not working

    You can continue on with how you set up your other files, you just need to keep connected as I tried to show in the small sample. The medical file becomes a grandchild of the parent and is connected via id# of the defendant, its' parent, just as the defendant is connected to the client.

    I hope this helps and I am leading you in the right direction. You might want to look at a couple of the sample databases supplied with Alpha 5. There is a sample called "Students and Classes" in the Template folder within Alpha 5 that may provide you with some good information.

    Leave a comment:

Working...
X