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!!
Solved! Go to 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.
AppSheet well documented. Sometimes it is useful to read them
For exmpl
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โฆ
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
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!
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
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.
I read it but canโt figure out what to select in Referenced Action.
Can you please guide?
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.
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:
Itโs works
Expects: if Data1 is not Number but Text, you can use CONCATENATE()
Did you try this ?
mine is a simple table not a parent child relationship so canโt figure outโฆ
Note: If you have 100s of rows in this table update will take really long.
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
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.
Problem Resolved!!
You have no idea how important this was for my app!! You are a Rockstar Genius!! Thank you so much!! God Bless!!
Please read this
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |