Hello, everyone. First of all I have to say that this app is the greatest thing I’ve ever founded on the internet as it has so much potentials for making my work easier and I would like to express my gratitudes for the Devs and Communities. It’s just that I had multiple questions for one thing.
I’m handling a team where each Merchandiser would visit multiple different stores daily and they had a report (formats below) where it needs to be text format so it can be pasted in other apps.
Store Name : ERA Downtown
Store Code : SDIOO101
Store Type : Minimarket
Visit Date : 31/10/2025
Target : 27 Actual : 24
OOS REG :
- Hair Colour Scht 5.32
- Men Facial Acno 100ml
OOS NPD :
First of all I need an editable text component where it can have “Copy to Clipboard” action but the only thing that’s close is the Note component. I need it to be editable because there might be some minor edit needed to be done by my team.
Second : I need the component to be able to toggle dropdown for copying data from Store Name to Visit Date as these data already available in screen.
Third : I need to make the Out of Stock (OOS) Items to be automatically added to the dedicated lines by Dropdown lists. I believe it’s quite similar to “Add to Cart” feature but it’s locked for non-free user.
Fourth and last : I need it to able to calculate how many items that’s Out of Stock. Target (How many items need to be in store) is already predetermined from another data table so I just need it to be able to be copy that using toggle dropdown. The Actual however need to be based from what my team chooses in third point (like if they clicked 3 items from the list means the Actual number need to be -3 from target).
These are my only problems as of now with this app as I’ve been only recently using it for a week. The rest from this app were great. Wish I could get more insights from this app.
Thanks.
You can have a button to do so below the component, if it isn’t too much of a problem to do so.
I’m not sure I get you here. Aren’t you trying to copy the full string here?
Store Name : ERA Downtown
Store Code : SDIOO101
Store Type : Minimarket
Visit Date : 31/10/2025
Target : 27 Actual : 24
OOS REG :
Hair Colour Scht 5.32
Men Facial Acno 100ml
OOS NPD :
Micellar Peel 125ml
I believe you just need a query/relation and use a joined list column to get all Out of Stock items. Pending logic you define in theb 4th point.
So there’s a threshold for each item?
Hi, there. Thanks for your replies. But as I tried myself looking for answers by myself while waiting for replies in this thread I managed to solved 3 of my problems. The only problem is that I can’t referenced the OOS SKUs in this note as it seems like because it’s a Split Text column. Is there any workaround for this?
Split Text column returns an array, which cannot be used in that way. Instead, reference the column that is the source of the Split Text column.
The reason why I’m trying to reference the Split Text column is because I want every items to be in listed in multiple lines instead of a single lines like in the screenshot (which below I referenced the source of the Split Text column).
My first assumption was that if I referenced the Split Text column it would show each items in new lines like in my first example (the bulletin is an optional, with or without is either fine). And it’s not possible to make columns for each items as we’re tracking 30 to 250 items per store.
I’m not sure I follow.
Can you show me what this looks like in the Data Editor? (the source of the Split Text column)
I think I skipped a bit of contexts here.
Before it went to the Note component, I use the Choice component in Form Container so my team can choose the items that’s not available in store.
After the form is submitted, here’s the result of the Choices components.
Then I made the Post-Submit Action to be showing the editable result of the submitted form which would have the Note component to check the Copied text.
The first picture below is the result of current workaround, while the second one is the one I’m trying to achieve (I editted manually to give some ideas).
ah, I see.
Okay, what you can do is keep your Split Text column, then add a Joined List column that targets the Split Text column, and use a new line as a separator (instead of a comma). Then use the Joined List column in the Layout. That should get you what you want.
This worked like charm. Thank you so much.
But if I may ask is there any way to put some bulletin for each items? Not that it’s mandatory because the main issues has been solved. I just want to know if the bulletin is possible in this format.
I think the easiest way to do that would be to pass your original Joined List (that’s written by the Choice component) to a JavaScript column, and use JavaScript to construct the bulleted list.
