About Caps

Caps · 09-24-2022

I have two tables:(Procedure table) (Visitation Record table) (Form)(column explanation inside (Visitation Record table))[ProcedureID] - (Enum) list of dental procedures.[Tooth Involved] - Total number of tooth involved[Prodcost1] - (Price) automatic...

Caps · 09-21-2022

I have a table (Procedure) that consist of:[ReportID] - Ref to my Visitation Record table[Prodtc] - (Text) And has the formula = CONCATENATE( " • ", [Procedure Type], " - ₱ ",[Procedure Cost]) and I have a form (Visitation Record table) that consist ...

Caps · 09-18-2022

Hello again everyone!I wrote this in my column [TeethID2] valid_ifIF(IN([ProcedureID2], LIST ("Prcty3", "Prcty4" , "Prcty5" , "Prcty6")),(Dental Chart[TeethID]) - LIST([TeethID]), [TeethID])But it says like this:The purpose of this is that if they se...

Caps · 09-18-2022

Hello again! please help me with this one  My ProcedureID is ref in my Procedure table where my Procedure Cost came from.I just wanted to add some solution in my [Total Procedure Cost] column that if I selected one of these ("Bonding", "Extraction",...

Caps · 09-15-2022

Hello again!  I want to put this also in my [Total procedure cost] column. If these Procedure Types (Extraction, Filling, Bonding, Denture) are selected in my [ProcedureID] (Enumlist), I want it to be automatically multiplied by my [Procedure Cost] ...

Caps · 09-26-2022

Is there another way I can put that expression inside my Visitation table without this result?

Caps · 09-25-2022

Is it possible to get the current value inside a form without saving it? I'm picturing it just passing the specific value calculated inside a column between tables.

Caps · 09-25-2022

I did this in my [try] (Which is like a display) column inside my Visitation Record tableAnd this is what I wrote: It's giving me the result I wanted but this is what it looks like in the form when there's no value selected. It's quite messy, so I'...

Caps · 09-22-2022

[Procedure Type] and [Procedure Cost] belongs to (Procedure table)Relationship between the two tablesEach Visitation row can have many Procedure(Procedure table)(Visitation Record table)

Caps · 09-19-2022

It worked! Thank you so much for always helping me! ur amazing!

My Stats

Caps's Bio

Badges Caps Earned

Recent Activity

getting the value inside a form

Is it possible to get the value in the form even without saving it?

Selected enum automatically reduce enumlist

Selected Enum price automatically multiplied with quantity

Selected EnumList price automatically multiplied with quantity

Re: getting the value inside a form

Re: getting the value inside a form

Re: getting the value inside a form

Re: Is it possible to get the value in the form even without saving it?

Re: Selected enum automatically reduce enumlist