I am unable to achieve this with Softr

Custom Coding
,
1

I appreciate the videos created by many that’s helping to certain extent but its not close to achieving what i want to achieve and this a real business case or scenario here in India and almost every application has to have something similar In a Tech language its call Parent Child relationship Example : Consider a Sales invoice of a Manufacturing company or Purchase Order of a Manufacturing company This different from the two videos posted by you and that’s not how the invoicing or procurement is done in India. An invoice has min 2 Parts of information and so is the purchase order and we shall call it a Table : Invoice_Header & Invoice_Item_Details Table PO_Header and PO_Item_Detail Note : I am only considering the important fields Fields like Billing Address, Shipping address etc are important but for the query purpose i am restricting to a few key ones only

Structure of Invoice_Header :

Inv-Id,Inv-Date,Inv-DueDate,Customer-id,Customer-Name,Inv-TotValue,InvTotTax,InvFinalValue

Structure of Invoice_Item_Details :

Inv-Id,Item-Code,Item-Description,Qty,Rate,LineItemValue-LineItemTax,LineItem-TaxableValue

Inv-id is the common field or the linked field between the two tables,

When the User Clicks on the Button Create Invoice a form is opened and the fields in this form are from Table Invoice_Header below that there a List Block the user clicks on the a button Add invoice Items the user adds 4 rows with 4 different item code which are supposed billed in this invoice there is dynamic Total column below for LineItemValue-LineItemTax,LineItem-TaxableValue so incase user is deleting a row or changing the qty the value is changing similarly the fileds in the header block has these dynamic Inv-TotValue,InvTotTax,InvFinalValue Now the user clicks a submit button Save Invoice It is expected that on save One row gets created in Invoice_Header and 4 rows gets created in Invoice_Item_Details at no point it should happen that there is record crerated in Invoice header but not in Invoice_Item_Details

This is achieved in power Apps : https://www.youtube.com/watch?v=b0bYXWiEzmo&t=3932s

2

With Softr, I think you will have to approach this differently. There is no native form for creating a record AND linked records at the same time.

There are a few options, it depends on your data source too (Softr DB or Airtable, or other).

Here is one approach: use a form to create the parent record. On submit, take the user to a page to view this record, then add your child records here using a linked list and hidden fields to join children to parent.

I hope you find a way that works well for you.