HI. Im fairly new to Flutterflow but getting stuck when trying to 'save' the data in a form to a firestore db.
It works in most cases but I have some fields which are calculated dynamically using a custom function based on the user inputs in the form. I'm showing the results of these in a text field on the form for information, even though they are numeric as i didnt know where else to put them. I'm trying to send these to a double field in the db (using an action on a sumbit form button) but the text field I have is not available for selection.
I've tried re-referencing the custom formula workflow in the action workflow but i need a different backend query to get the arguments for the custom formula than i need for the rest of the information for the button.
I also have some fields in drop down menus, which are all set as different document reference field types, yet these dropdowns are (in red and) also not available for selection when deifning the variable to send to the db fields which are of the same type.
Any help appreciated thanks.