Variable Declaration Error
Hi,
I have two tables named [Startup] and [Fund]. There is no relationship with the tables. I want to fetch the allotted fund value based on the financial year of the startup from the startup table...
Forum Discussion
I'm not 100% sure what the formula errors specifically are alluding to - but from reviewing your formula they syntax in general looks off. I would suggest trying the following and seeing if it responds differently:
var text FY = [Financial Year];
If ($FY != "",
(GetFieldValues(GetRecords("{6.EX.'" & $FY & "'}", [_DBID_TANSIM_FUND]),8)),
null)
The 2 changes are:
1. Change $FY != null to "", since FY is text you need to compare it to blank text
2. In your query - you have the $FY inside of the '' as if that was the value. Break out the variable from the string by doing '" & $FY & "'
You might also have to do a ToNumber or ToText function around the query as the response from queries is a multi select value that you likely need to convert.
------------------------------
Chayce Duncan
------------------------------
Hi Chayce,
Thanks for responding. I have tried your code. Still, it throws the same error. I have attached an image for your reference. Please advise on this.
------------------------------
Prakash Murali
------------------------------
Are you getting an actual error in your formula anywhere that is leading you to check the formula? That formula checker is a new feature as of this month - and it appears like some kind of a bug when processing variables. I checked it in my environment for a formula that I know 100% works as intended and it is reporting the same issue with the variable that you are seeing.
My assumption is that the error you're seeing in the formula checker is a bug with the feature, not your formula. I would advise saving the formula and seeing if you're getting the intended result in your records and ignoring the formula checker for now.
If you're having issues and just want the error gone - I would gues you'll need to remove the variable declaration like so:
If ([Financial Year] != "",(GetFieldValues(GetRecords("{6.EX.'" & [Financial Year] & "'}", [_DBID_TANSIM_FUND]),8)),null)
------------------------------
Chayce Duncan
------------------------------I'm able to retrieve data when the financial year value is static. It does not show any data if I mention the field [financial year].
This is the formula I used
If ([Financial Year] != "",
(GetFieldValues(GetRecords("{6.EX.'" & "2023-2024"& "'}", [_DBID_TANSIM_FUND]),8)),
null)
------------------------------
Prakash Murali
------------------------------That seems to be something you'll have to work out with your actual data then. The query is working based on your hardcoding - but based on your comment you're passing a value for [Financial Year] that doesn't match up to the values in your fund table. From your screenshot your startup records look like 2022-2023 records - do you not have data for 2022-2023 in your Funds table? Seems like you need to either create new records in the Startup table for 2023-2024 or update the value of Financial Year for them.
------------------------------
Chayce Duncan
------------------------------
