How can I insert an "ADD" button beside Photo attribute?

[abirtanjinadnan]

Hi all,

I want to add an “ADD” button beside the “Photo” entity (screenshot-1) which will be able to take 1 to 7 (multiple) pictures and the pictures will view in the one after another like a Grid view.

How can I do this? Kindly help. (Details in the screenshot)

Thanks

[LeventK]

You need to create a reverse reference with the Photos table (if you don’t have such a table, you need to create) and when you’re filling the form in your screenshot, a NEW button will appear (you can change the name to ADD or whatever you like via locale settings) and then limit the number of reference records for the parent table to 7.

[abirtanjinadnan]

Hi,

I have added
COUNT(Product[Related Photos]) <= 7
query under Add (sys-gen of Product table) -> Beheviour -> Only if this condition is true
This isn’t worked.

Then I have this one,
COUNT(
SELECT(
Product[Related Photos],
[Item code] = [_THISROW].[Item code]
)
) <= 7
also not worked Sir.

Is it possible to hide add button after 7 photos added

[LeventK]

@abirtanjinadnan
You can use below expression in your child table’s Are updates allowed property. Let’s assume that you want to limit the records by 50:

IF(
COUNT(SELECT(Photos[KeyColumn],TRUE))<=7,"ADDS_AND_UPDATES","UPDATES_ONLY"
)

You may change the allowable status as per your needs. Above is just an example. Provided you don’t want the related photos to be even edited and adds only, you can re-phrase the expression:

IF(
COUNT(SELECT(Photos[KeyColumn],TRUE))<=7,"ADDS_ONLY","READ_ONLY"
)

You can remove any expression under system-gen Add as well and return it to TRUE

[abirtanjinadnan]

Hi,

Sorry! It’s not working. I have added this condition in child table “Photos”. (1st picture)
The add button has gone. But if there are less than 7 photos, it’s also not showing add button. (2nd picture)

[LeventK]

Remove any editable_if or show_if conditional expression in your Related Column, system generated add button or similar

[abirtanjinadnan]

Sorry.
Still not working.

Actually, I need to hide add button when the related photos limit goes to 7 (picture-1)

)

[LeventK]

@abirtanjinadnan
Share your app with levent@able3ventures.com as a co-author and I will handle it.

[abirtanjinadnan]

Yes. I have shared.

[LeventK]

Noticed that @abirtanjinadnan. Please do not interact with the app or the editor now.

[LeventK]

@abirtanjinadnan
Can you also please give me EDIT ACCESS for your sheet? Thnx.

[abirtanjinadnan]

Maybe, this is edit access option.

[abirtanjinadnan]

Yes. shared

[LeventK]

@abirtanjinadnan
Please share the gSheet with Edit access as well.

[abirtanjinadnan]

Yes. gsheet shared

[abirtanjinadnan]

Another thing is that when I select a photo for the Product table’s Photo attribute, the search page is showing all the items. I want only the items of that specific product.

[LeventK]

@abirtanjinadnan
Mission accomplished…
You can now remove my edit access from the gSheet and the app.

[khuslid]

LeventK:

a NEW button will appear ( you can change the name to ADD or whatever you like via locale settings )

How?
“NEW” is not one of the texts in localize, and neither an action I can find (to display a different name…)
Any tip here?

[Eloy_Paredes_He]

Hello @abirtanjinadnan
As @LeventK is suggesting. You need to have two tables. One table for the parent entity and another table for the photos child table.
Can you share a screenshot of your tables?

[abirtanjinadnan]

Hi @LeventK and @Eloy_Paredes_Henriqu

Thanks for your suggestions… Actually, my idea was, there is a Product table, where one can add several photos under one product (it can be upside, downside, left of product/ retail box). And photos will be added as related photos, which I have solved from @LeventK 's suggestion. by adding Photos Table.
But I need to select one photo from related photos (virtual column) list which will be added inside Product table as Photo attribute. (which is also solved).

But, when I am adding a Photo in my photo attribute of the Product table, the list is suggesting all photos from Photos table. I want to see only Photos of same labelled (same item code) (screenshot-1)

I am adding my Column/ App screenshots here.

Thanks

[LeventK]

@abirtanjinadnan
For your [Photo] column of your Producst table, you can use a Valid_if:

SELECT(
    Photos[_ComputedKey],
    [Product] = [_THISROW].[Item Code]
)

[OptimiX_XcrY]

Use this tehnique

Limit the number of child entries Questions

Then you would need to add a slice (read_only) and create the second Ref_Rows virtual list for that slice. Hide the original virtual list column when COUNT([Related child records]=1 and show this additional virtual list column. It will hide that “New” button.

[LeventK · Accepted solution]

Regarding the community members, here is the solution:

---

STEP-1 :: READ-ONLY SLICE

---

Summary

A slice is created with READ_ONLY attribute from the Photos Table. Nothing special, no conditional rules, all columns selected. The slice is named as slice_Photos.

---

STEP-2 :: PRODUCT REVERSE-REF COLUMN

---

Summary

[Product] ref column in Photos table is set as isPartOf to show this column as a reverse reference in Product_Form

---

STEP-3 :: VIRTUAL REF COLUMN

---

Summary

In Product table a ref type Virtual Column is created with below expression. This column is named as Limited Photos.

REF_ROWS("slice_Photos", "Product")

---

STEP-4 :: SHOW_IF CONDITION

---

Summary

[Related Photos]

COUNT([Related Photos])<7

[Limited Photos]

COUNT([Related Photos])=7

---

STEP-5 :: INLINE VIEW

---

Summary

System generated Photos_Inline UX view has been copied, renamed as slice_Photos_Inline and Data set to slice_Photos

---

STEP-6 :: PHOTOS FORM

---

Summary

Photos_Form is set to Auto Save and Auto Re-Open

---

STEP-7 :: PHOTO VALIDATION*

---

Summary

A Valid_If condition is set for Photos Table, [Photo] column along with a custom error message to prevent addition of more than 7 photos.:

Valid_If

COUNT([Product].[Related Photos])<7

Invalid Value Error

"Max. 7 photos can be added!"

---

FINAL RESULT

---

Summary

Add button is disabled/removed when there’s 7 child records for the parent table

[abirtanjinadnan]

Thank you so much @LeventK

[abirtanjinadnan]

Can I keep the edit and delete permission for photos after 7 pictures added?

[LeventK]

Yes, definetely you can @abirtanjinadnan

[abirtanjinadnan]

Hi,

Is it possible to hide save/ cancel buttons from this form?

[LeventK]

Nope and why you want to remove them?

[wiilasdnj]

Good information thanks for sharing
vmware