How to Refresh Data without clicking Edit Save

[TotalSolutions]

I have many rows of data in my Employee Salary table and if I want Appsheet to recalculate the formulas and fetch the updated data from the database for which I have to click on every row then click edit then save to get the updated data. I have many rows its difficult to do it one by one. Is there a way to refresh that data in one shot for all the rows in that table?

Please let me know. Thank You!!

[bonameblisto]

AppSheet well documented. Sometimes it is useful to read them
For exmpl

help.appsheet.com

Bulk Select

When you need to select more than one record at a time in your application

[TotalSolutions]

Thanks for your reply… I read the article you sent me regarding bulk select and it says: You cannot set the value of a column that: Contains an AppFormula and I want that App formula to be executed so that it picks up the updated values…how do i do that? Please let me know…

[bonameblisto]

Ok
You don’t write about autocompute formulas in your app.
Really, in that case you can’t use Bulk Select
But if you creates table view for your data, and swithes on “Enable QuickEdit”, then you can edit data without opening other forms
Like on pic

Or use recomendations on prev post How to Refresh Data without clicking Edit Save - #4 by Rifadm817

[Rifad]

Quick Update System - How to update records in your app with a push of a button you can try this

[TotalSolutions]

Rifadm817:

Quick Update System - How to update records in your app with a push of a button

I am able to update 1 row at a time but I want to update all rows in the table when we click the button.
Please let me know how to do this. Thank You!

[Aurelien]

Hi @Total_Solutions

What about that:

[TotalSolutions]

I want the Dhamaka Points to be updated by running the formulas when I click on the Button.

What I understood is that in the Reference Rows I write: TableName [KeyColumn]

But I did not understand what to put in the Reference Action. I am attaching the snapshot of the options I see.

Please let me know. Thanx

[Rifad]

Rifadm817:

Quick Update System - How to update records in your app with a push of a button

Please have a look at this post carefully Quick Update System - How to update records in your app with a push of a button

Everything you will need is available there.

[TotalSolutions]

I read it but can’t figure out what to select in Referenced Action.

Can you please guide?

[Rifad]

Please have a look at that video. He creates an extra column like [update] and uses an action [update]+1 for the table you need to update. That update action is used as referenced action in your table. I see no update action in your above screenshot.

[bonameblisto]

Now i’m test next scenario:
Table with columns:
ID as UNIQUEID()
Data1 as Number
Data2 as Number with formula [Data1]+10

Because can’t change Data2 using BulkUpdate’s I’m use next:

1. Create Action Plus10 for Data1 with data change as Data1+10
2. Create Action Minus10 for Data1 with data change as Data1-10
3. Create Grouped Action UpdRowPlusMinus as sequence of Plus10 and Minus10
4. Create Action BulkSetOfRows for rows you need select(table[ID],{your conditions})
   or for all as select(table[ID],true)
   with Referenced Action as UpdRowPlusMinus

It’s works
Expects: if Data1 is not Number but Text, you can use CONCATENATE()

[Rifad]

Quick Update System - How to update records in your app with a push of a button

Update All Child Records

You can easily update all the child records from a parent-child relationship inside your app

All you have to do is create a reference action that runs the update action over the [Related Child_Records] column.

Did you try this ?

[TotalSolutions]

mine is a simple table not a parent child relationship so can’t figure out…

[Rifad]

1. Just add another column for Update.
2. Create an action “Update” to set [update] column [Update]+1
3. Create another action to execute an action on a set of rows with referenced action as “Update” with your list of referenced rows.

Note: If you have 100s of rows in this table update will take really long.

[TotalSolutions]

Referenced Action does not have update…It only has Delete, Edit, Add & View Ref. Attached snapshot. How to get update here?

Also what I understood is that in the Reference Rows I write: TableName [KeyColumn]
Table Name is: DPWL
Key Column is: DPWLID
So i have written DPWL [DPWLID]

is that correct?

Please guide. Thanx

[Rifad · Accepted solution]

Kindly try to understand watching that video. You need add extra column to your table and you can call it “update”.

Then create an action to set the value of [update] to [update]+1. This action you can call “update row”

Attach this action instead of edit, delete etc… to you action you created. You will see this action in your referenced action list. Firstly you should create that action to show in your list.

[TotalSolutions]

Problem Resolved!!

You have no idea how important this was for my app!! You are a Rockstar Genius!! Thank you so much!! God Bless!!

[Rifad]

Rifadm817:

• Just add another column for Update.
• Create an action “Update” to set [update] column [Update]+1

Please read this