Aug 29, 2022 04:54 AM
I’m new to Airtable, so it’s likely I’m being an idiot over here.
I recently connected the Fintable Extension to integrate banking data; Account Balances and Transactions to a Fintable Base.
I have then synced that Base in to Tables in to my Main Base to use. I have a Table where I have used a Gallery View to host card details and if it’s active, expired, type of account etc, see example…
Now, what I am trying to do, is create an automation that automatically updates the Current Balance Field as soon as that field is updated (based on the Fintable Base Sync).
When creating this Automation, here is what I tried setting up -
However, time and time again I get this error, and I cannot for the life of me figure out why?
Aug 29, 2022 05:01 AM
Hi @Ash_Hallett ,
Welcome to Airtable Community !
You need to click on the gear icon beside the current Balance automation ands choose Dynamic Value then choose the field you need. From what I see here you are trying to pass the “£” as a value to a currency field which will only accept numbers.
If this helps, please mark this as Solution :slightly_smiling_face:
Aug 29, 2022 05:09 AM
Thanks for the response Mohamed, but unfortunately I still get the same error!
Aug 29, 2022 05:14 AM
Please screenshot the field after you have mapped it using the Dynamic value. Is the field you are referencing also a Currency field?
Aug 29, 2022 05:21 AM
Here’s each step, starting with…
Aug 29, 2022 05:24 AM
Sorry I missed it the first time. The Record ID part is wrong. First you need to link the Fintable Act Sync table to the Finance table so that you know which record you need to update. Alternatively, you need to add a Find Records step to get the record id you want to update. After that, you can input this record id in this step
Aug 29, 2022 05:40 AM
Afraid that still doesn’t work.
The find records piece works perfectly, shows me all of the different fields etc in the Fintable Act Sync table, but it still won’t let me run an update record to the Finance table, exactly the same error.
Aug 29, 2022 05:43 AM
The Find Record should run on the table you want to update, i.e. on the Finance table to find the record you want to update.
You need to get the record id of the record you want to update. Which record do you want to update? Based on what should Airtable update that record?
Aug 29, 2022 05:44 AM
The same thing happens.
I’m just trying to get the Current Balance from Fintable Acct Sync, and update the Finance table field - Current Balance.
So whenever the Finance Table Acct Sync field - Current Balance - updates, then the Finance table field - Current Balance - will update
Aug 29, 2022 05:46 AM
Please post screenshots of both tables and mark the RECORD that is being updated in Fintable Acct Sync with the corresponding RECORD in Finance table
Aug 29, 2022 05:48 AM
You are mentioning Fields, the problem is not the fields, its the Record. You have X number of records (rows) in FinTable Acct. Sync. and you have X number of records in Finance table.
To make this easier, you are updating row (record) number 1 in Fintable, which row (record) in Finance table should be updated? All of them?
Aug 29, 2022 05:51 AM
Apologies for the incorrect language, that must cause confusion, sorry.
Here’s the two screenshots, so I want to grab the highlighted data from here…
And put it in the highlighted area here…
Aug 29, 2022 05:52 AM
Ok, so what is the relation between those 2 rows? Do they both have the same value in the primary field “Name” for example?
Aug 29, 2022 05:53 AM
Correct, they’re both exactly the same Name
Aug 29, 2022 05:54 AM
Ok great. Then you need to add that in the Find Records action. Are you able to find the correct record using this action?
Aug 29, 2022 05:55 AM
So I’m telling it to Find the Name?
Aug 29, 2022 05:56 AM
Yes, because this is the record you need to update. In order to be able to do that, you need to Find the record ID, which will be one of the results of the Find step.
Aug 29, 2022 05:57 AM
Here’s what I’ve got so far…
Aug 29, 2022 05:58 AM
You should change the “Find records based on” to “Condition” instead of “View”
The Condition will be Name is, then choose Dynamic value from the gear icon, and choose the field Name from the trigger step
Aug 29, 2022 06:04 AM
It won’t let me… Current Balance is greyed out