Attachments datacard

Like (0) Share

Report

Posted on 15 Feb 2022 19:46:19 by AuburnMist

239

Hello,

I have a need to reference the attachments data card in one of my formulas, but I can't figure out which syntax is correct, as none of them seem to work. Can someone please tell me how to proceed?

Thank you

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (9)

Answers (2)

PowerRanger 3,458 Super User 2024 Season 1 on 15 Feb 2022 at 21:55:29

Like (0)

Report

Re: Attachments datacard

@AuburnMist I am really sorry to tell but your formular can't work

Plese have a look at the If Syntax: If( Condition1, ThenResult1 [, Condition2, ThenResult2, ... [ , DefaultResult ] ] )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

AuburnMist 239 on 15 Feb 2022 at 21:44:57

Like (0)

Report

Re: Attachments datacard

Thank you for continuing to work on this. When I thought I had it, I actually didn't!

I ended up with this, and it works perfectly.

If(IsBlank(DataCardValue1_1.Text)&(DataCardValue9_1.Text),(DataCardValue7_1.Selected.Value),(DataCardValue6_1.Selected.Value),(DataCardValue4_1.Selected.Value),(DataCardValue8_1.Selected.Value),(DataCardValue10_1.Text),Disabled,Edit) & If(CountRows(DataCardValue25_1.Attachments) = 0, Disabled, Edit)

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on 15 Feb 2022 at 20:21:34

Like (0)

Report
Re: Attachments datacard

@AuburnMist Please consider to change your formular to this pattern

If(Or(IsBlank(DataCardValue1.Text),IsBlank(DataCardValue5.Text)),Disable,Edit)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on 15 Feb 2022 at 20:17:12

Like (0)

Report

Re: Attachments datacard

@AuburnMist Just had a look at your formular....This actually can't work...

Was this reply helpful? Yes No
Verified answer

PowerRanger 3,458 Super User 2024 Season 1 on 15 Feb 2022 at 20:08:57

Like (0)

Report

Re: Attachments datacard

@AuburnMist as i am not at my PC I can't verify what I think should work.

Try this

If(CountRows(Datacardvalue25_1.Attachments) = 0, Blank(), false)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
AuburnMist 239 on 15 Feb 2022 at 20:08:42

Like (0)

Report

Re: Attachments datacard

Please disregard. I found the problem!

I was using DataCardValue instead of ThisItem.

I rewrote the formula and for the attachments, I used ThisItem.Attachments, and my issue is gone.

Thank you

Was this reply helpful? Yes No
AuburnMist 239 on 15 Feb 2022 at 19:59:14

Like (0)

Report

Re: Attachments datacard

Definitely, let me elaborate further;

I am writing a formula in the DisplayMode function of my Submit button.

The Submit button must remain in Disable mode until such a time as all of the fields are filled in. When all the fields are filled in, the button becomes 'enabled' (Edit).

If(IsBlank(DataCardValue1_1.Text),(DataCardValue9_1.Text),(DataCardValue7_1.Selected.Value),(DataCardValue6_1.Selected.Value),(DataCardValue4_1.Selected.Value),(DataCardValue5_1.SelectedDate),(DataCardValue8_1.Selected.Value),(DataCardValue10_1.Text),Disable,Edit)

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on 15 Feb 2022 at 19:50:58

Like (0)

Report

Re: Attachments datacard

@AuburnMist I am asking because datacardvalue25_1.Attachments is actually a Table. So you cant just reference this in Lets say a Label...

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on 15 Feb 2022 at 19:48:09

Like (0)

Report

Re: Attachments datacard

@AuburnMist could you provide some more details. Where do you need to reference the datacard and whats the purpose?

Was this reply helpful? Yes No