Need form to change change prepopulated values depending on previous form submission

I’m new to Airtable.
I want to create a form which has some fields prepopulated. The value in this field will change every day. eg. Initial stock is 28000. 22000 is current stock which is prepopulated to one field on form. 500 are sold. When form is next opened 21500 should appear. Is this possible? Can form pull values from linked base?
Can an airtable form do calculations within the form? eg. 500 sold, 200 given away, 200 written off. 900 to appear in a different field and 900/22000*100% to appear in another field.
Does anyone know of form options which will do the above? Formfacade with formranger addon seems closest solution but not really what I’m looking for.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.