Simple genie or simple code to use a button to update an adjacent field in grid

[clankford]

Seeking a simple way to assign a function to a toggle-like button to essentially update a field within the same line that the button was pressed.

What I'm trying to do is have an approval queue where when you want to approve an invoice line listed you would simply click a button on the line you want to approve and when clicking the button the function would capture the username and combine with timestamp to create a digital signature.

I'm also open to finding out about an already built UX component or something that would accomplish the same.

Thank you in advance for your help.

[Peter.Greulich]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

Is this a web app?

[clankford]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

Yes, thank you.

[Peter.Greulich]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

You can use the button's onClick event with code similar to this:

var row = {Grid.RowNumber};
var name = {grid.Object}.getValue('G',"NAME_FIELD_HERE",ROW);
var d = new Date();
var dt = d.toFormat('MM/dd/yyyy 0h:0m:0s am');
var name_stamp = name + dt;
alert(name_stamp );

But you must understand that this is complex stuff. You need to try to understand what is going on here, otherwise you might not be able to make it work in your situation.

[clankford]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

Thank you Peter. I certainly will dive into this code and try to make sense.

Being an advanced application builder in Access, this is a Breeze in Access, but I realized and have been learning over the last few weeks that pretty everything I did in Access is readily available in Alpha, I just have to think about it slightly different and as you see, "understand what is going on" in various "codes"

Thanks again,

-Carsell

[CharlesParker]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

You might want to look into the check box selector to approve multiple invoices with a button click...

[CharlesParker]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

https://www.youtube.com/results?sear...Column+in+Grid

[clankford]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

Thank you Charles & Peter...however, I'm still struggling with how to just simply update a field by the click of a button. When I go into on-click event, where can I just insert some basic equivalent code I would write in access - [FIELD1]&" - "&now().....which would basically generate a result like - john doe - 8/20/15 8:50am...

Charles, I would definately be open to using multiple clicks and clicking one button to "mass-update" multiple line items, however I still cannot seem to define which buttons need to get upated with a signature and what the signature is made up of

In the code above it appears I need to supply the row/column, versus the system identifying the row that is clicked? Again, like I would write in MS Access, "-1" would identify which row is toggled.

Hopefully this question makes sense.

Thank you both for your time.

-Casey

[GGandhi]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

i am just modifying peter's code in post #4.
place this following code in the onClick event of the button's inline javascript.

var name = {grid.Object}.getValue('G','FIELD_TO COPY FROM',{Grid.RowNumber});

var d1 = new Date();

d1 = d1.toFormat('MM/dd/yyyy 0h:0m:0s am');

var name_stamp = name + '  ' +  d1;

{grid.object}.setValue('G', 'FIELD_TO_COPY_TO', {grid.RowNumber}, name_stamp);

this is not a complex code by any means, not definitely to anyone experienced in another platform.
you get the value of a field you want to add, and select the timestamp you want to add to it, then set the new field to that value combined.
what makes it different is this is in web portion, where javascript ploughs the field. so you need to write out the constructors for the name_stamp, (the variables are not kept after displaying the field in the browser)
where as in desktop the fields are available (they are all still the memory)and can be added on the fly.
please note the capitals in the statement, they are required to be that way.

[clankford]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

Thank you Gandhi, the code seems to work to specs, however can you provide an example of how I can gather the username logged in to incorporate into the code? For example I do happen to have the username populating in the grid under field name "ALPHA_SORT"....should it use an existing field in the capturing the logged username, or should I use alternate coding? I have successfully captured the logged username by utilizing the getusername() function in an immediate redirect page (provided by Peter, thank you again), however if I read your message below correctly, that username was not saved anywhere? How would I go about "Recapturing" the logged in username without using another login component?

Thank you in advance for your help again!

-Casey

[clankford]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

Gandhi! Nevermind my friend. I got it to work!!

I looked more in detail of your code and saw that you defined that variable in the section "FIELD_TO COPY FROM'"

This new functionality is huge for me!

Thank you again!

-Casey

[clankford]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

Ok Ghandi, just to revisit part of your previous post, how would I get the page to recapture the logged username if the username is not currently one of the fields in the current grid?

Thanks, Casey

[Peter.Greulich]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

<%a5
? A5ws_GetCurrentUser()
%>

[clankford]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

Thank you Peter. I was thinking that, however where would I place this code? Would this somehow be embedded within the button's "on click" code that I have been working on in this thread?

Thanks again.

-Casey

[GGandhi]

Re: Simple genie or simple code to use a button to update an adjacent field in grid

I have successfully captured the logged username by utilizing the getusername() function in an immediate redirect page (provided by Peter, thank you again)

set that variable to a session variable in that page and that session variable will be available thru out your session and you can enter that info into your grid.