Skip to Content
author's profile photo Former Member
Former Member

Submit data macro question

Hi All

I have a very simple requirement but schedule is not working as I expect and is driving me nuts. Hope you can help me.

A very simple schedule with submit button. Also my row expansion has insert member option.

User can open the schedule and can insert new rows and enter data in the row. user can also go and modify the existing rows data to 0. On submit what i expect is the schedule to send data, expand and refresh data.

It has to send data

It has to expand because i want it to sort the rows as user mayn't have inserted in the right place. Also as I want the rows to be suppressed, if the user has entered 0 in any of other rows those rows should be hidden.

Hence my submit button should send data and expand. I am using below in the button assign macro.

Behavior i am seeing is, It sends the data, removes all the newly added rows and keeps the data where 0 was entered.

When we click the second button - "Refresh" which is essentially same as the second macro here, it then expands with new rows, hides the 0 rows and sorts properly.

I am not sure what is going on. If it is executing both the macros, user shouldn't have to click on the refresh button after submit button. How do i make both the macros run on click of submit button.

We are on 7.5 NW SP6

Submit Button

Application.Run ("MNU_eSUBMIT_REFSCHEDULE_BOOK_REFRESH")

Application.Run ("MNU_eTOOLS_EXPANDANDREFRESH")

Refresh Button

Application.Run ("MNU_eTOOLS_EXPANDANDREFRESH")

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2011 at 10:01 PM

    Hi,

    I have noticed the same behaviour that sometimes if I call 2 actions, the second one doesn't seem to run.

    I think this might be a timing issue? ie the first task is still running while the 2nd kicks in?

    Just have a play with different commands.

    for example a send without refresh (faster?) and then do each step seperately?

    Application.Run "MNU_eSUBMIT_REFRESH"

    Application.Run "MNU_eTOOLS_EXPAND"

    Application.Run "MNU_eTOOLS_REFRESH"

    (or try one of these for sending:

    MNU_eSUBMIT_REFSCHEDULE_SHEET_NOACTION

    MNU_eSUBMIT_REFSCHEDULE_BOOK_NOACTION)

    Hope this helps

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.