@imrineeman
You might first want to review the required columns in your data source. Sounds like a SharePoint datasource since you mention Title, but even if not...review what is required and make sure it is being supplied when creating a new record.
OnSuccess Action:
UpdateIf('SKU Generator - Database',
ID=New_Form.LastSubmit.ID,
{Serialnumber:
Text(New_Form.LastSubmit.ID, "00000"),
'Catalog Number':
ProjectCodeCardValue.Text & Text(New_Form.LastSubmit.ID,"00000") & TypeCodeCardValue.Text
}
)
Note, the ProjectCodeCardValue.Text and TypeCodeCardValue.Text. This is based on the assumption that these are TextInput controls in your EditForm DataCard. You need to replace them with the appropriate control name.
OR, if the value of ProjectCode and TypeCode are being recorded in your Submit, then you can change the formula to this (assuming those exact column names)
UpdateIf('SKU Generator - Database',
ID=New_Form.LastSubmit.ID,
{Serialnumber:
Text(New_Form.LastSubmit.ID, "00000"),
'Catalog Number':
New_Form.LastSubmit.ProjectCode & Text(New_Form.LastSubmit.ID,"00000") & New_Form.LastSubmit.TypeCode
}
)
BUT - if you are getting a Title required error somewhere, that is a different issue. Make sure you are populating any required columns with your submit and EditForm.
I hope this is helpful for you.
