I see this question asked a lot, but I don't understand how to get it to work.
I have an equipment management and user-tracking app. The app works well apart from taking a long time to sync when a user moves the location of equipment. For the location of the equipment, the table has 45 columns but only 5 of these need to be updated with new information. The other 40 columns contain duplicated data from other tables using = 'this cell' in excel.
All tables have the same KEY layout in column A, named [asset number] which starts at 0001 and finishes at 2000. There are no adds, only updates to the data.
I believe that I can speed up my app by
I have created a bot.
I need help from this point.
The referenced rows expects a list so I have added SELECT(Equipment Register[Asset number], [Asset number] =[_THISROW].[Asset number])
The referenced action is a bot which for simplicity is
For a record of this table Equipment Register, Set the values of some columns in this row, Current User = "Some Name"
Ultimately I want this to write the data from the location history table but I cannot even get it to change some simple data so I am doing something wrong.
Can someone point me in the right direction?
Many thanks,
@ghost5 wrote:
Ultimately I want this to write the data from the location history table but I cannot even get it to change some simple data so I am doing something wrong.
Can someone point me in the right direction?
This is a long-standing gap. The action needed is "update an existing row in another table using values from this row".
AppSheet's solution to this gap is the INPUT() function. You will immediately notice comments that this feature is in Beta. However, many app creators are using this function in their live apps with no issues. Not all apps have this feature available
Basically, the INPUT function allows for passing of values between actions. Refer to the article on how to use it. It is very simple to use, but, if you still have questions, come back here and let us know.
If you find that INPUT is not available, again let us know and we can help you work through an alternative.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |