Edit - Add Row

Ask for Help
1

Hi all,

I come again.:slight_smile:

Now I’m adding new quotation using the button at the bottom.

image
image312×623 37.1 KB

Below is the detail of my new entry.

image
image296×621 42.8 KB

I need to do some editing using button at the top as per picture below,

image
image303×621 44.7 KB

I changed the company name to OCBC Bank, and done.

image
image307×615 27.4 KB

I’m using custom action to add row for all changes.
image

My intention is want to keep the old quotation with old details.
Now , it change the old details to the new one and add row as below.

image
image647×550 36.2 KB

I need that the old quotation remain but add new row with new details.

2

You have to check open independent screen for item, add user specific columns for values that gonna be edited, than use text or number entry components to enter new data to these new columns, (use as a placeholder original data to keep track).
Add submit button with action to open new row and set columns with collected values from user specific columns)

3

Is there any possibilities to just tick at existing column for User-Specific a spicture below ?
Independent screen is what like i’m doing right now right?
image

4

You need extra columns , so you don’t overwrite existing data, you wanna keep it right?

5

Yes, just like i edit Data 1 to Data 2.
But I need to keep both using Add Row action.
Data 1:
Quotation Number | Quotation Date | Company | Model
GE-2021-1000-Rev.0 | 10/3/2021 | Air Asia Sdn Bhd | GS-1000

I edit to Data 2:(I change from Model GS-1000 to SS-2000)
Quotation Number | Quotation Date | Company | Model
GE-2021-1000-Rev.0 | 10/3/2021 | Air Asia Sdn Bhd | SS-2000

So the data that I need is:
Quotation Number | Quotation Date | Company | Model
GE-2021-1000-Rev.0 | 10/3/2021 | Air Asia Sdn Bhd | GS-1000
GE-2021-1000-Rev.1 | 10/3/2021 | Air Asia Sdn Bhd | SS-2000

6

You filip data when opening row

7

Flip?

8

You write new data to user specific columns, when you done, open new row and write data form those columns to original ones

9

Do not use edit mode

10

Simply show old values and under put text entry to a coresponding user specific columns

11

:weary:

1 Like
12

You dont actually edit old values, you write new values in new columns, and when done , button will create action to open new row and write new values in original columns because now they are empty, because it is a new row

13

But when to edit, it show nothing since its show different column right?

14

Yes, but you can use original data as a placeholder or put text component above with it

15

Can if it is text entry but what if it is choice component. ?

16

Put just text with original data above

17

It is impossible since user will sometime put different than it should be . Some with space some dont have so its hard to analyse later on

18

Choice will have same feed like original one,

19

Hi @Uzo ,
Hope you doing well.

I found something that easier for me and for your reference as well.

Instead of add more column we can make action add row first. So it’s copy the original data.
And make also add action of link to screen>this item. In the screen set allow edit is fine.

1 Like
20

This will give you a little problem… when user changes his mind not to edit… you will have a duplicated row

1 Like