Import Repetitive Profile

[Dave_Willett]

Is it possible to import into several rows a profile.

Let me explain.

My app creates items individually via suggested values or enum. This works great and is necessary.
At the end of the process there is always a profile to select which may contain several rows. The profile always contains the same values.

CustA - OTHER - EPA - OTHER
CustA - OTHER - QC - OTHER
CustB - OTHER - Road Test - Specialist

With the above example table, If I select CustA I want both rows to be added to my list, each on a separate row.
CustB will be ignored.

Is there a way to do this?

[WillowMobileSys]

Dave_Willett:

Is there a way to do this?

There usually is a way whether its provided by AppSheet or needs to be built.

Think of the profile rows as pre-built child rows just waiting to be “adopted”. In this case you are attaching those child rows when a Customer is selected.

You basically mimic a “Related” rows Virtual Column - but simply swap out the REF_ROWS() function with your own SELECT() that chooses the profile rows for the chosen Customer. These can then be shown in the views in a Inline table - i.e. treated just like a “Related” rows column.

Let us know if you still have questions.