top of page

Fun with Conditional Rules #2 in Knack apps

Here is another installment of how to use conditional rules in Knack database apps. These are very powerful and you can get real creative with them. Here we use them to automatically set the fiscal year in a specific format based on another date value in the record. Check it out.

Interested in my Knack database services? ... Book a call with me here:

If you are a fan of building great apps with Knack, please click the Subscribe button to join my channel, and ring the bell to receive notices on all my new instructional videos. Thanks!

Full Transcript

hello folks I'm back Dave parish and

act builders if you like these videos please

like it on YouTube

subscribe to the channel if you can

but here's today's topic I'm doing

another one of these series I have fun

with conditional rules I just love these

things and there's so many use cases you

can get so creative with these and solve

all kinds of problems or just make

things easier so here's today's

topic let me get this out of the way

close this this is a

project I'm doing for this organization

that's funded by the government

they get Farmers to volunteer I brought

this one up before in Africa

and help farmers in Africa learn more

skills but since it's from the government

they have to report

all kinds of stuff and it's got to be in

a very specific way what I'm dealing

with here is fiscal year they have to

report it as FY 19. and

we didn't want the users selecting

fiscal year because it's actually based

on some other date because if they they

could select the year but there's there

do a lot of them there's 500 right now

uh someone's gonna make an error it's

going to screw stuff up uh that's solved

by a conditional Rule and I'll be right

back and show you how to do it bye

okay let's go for it uh fun with conditional

rules second installment

how to get fiscal year

to get in this format automatically

based on some other field

and these by the way these fun with

conditionals these are going to be

pretty short just trying to give ideas

on how to use these so let's let's go

see how we do this

here's assignment

here's fiscal year okay

now again we didn't want them selecting

fiscal year themselves because it's if

it can be automated it's better there's

not gonna there's gonna be less mistakes

but here's the deal and by the way this

project has a duration of six years

so what we didn't do is just and it's

what it's based on is when they finished

the project they sign a date to it the

actual completed date and that's what

determines what the fiscal year is so

all we did

is we did the range of

of what these are

based on the date and if it was this

18 through 19. it's FY 19 this is just

this value here is a it's it's I

think it's just a simple

text formula or a text field

so each of the six years we said okay

this is the date range and if the actual

completion date

Falls between these dates

that's what it is in terms of the

fiscal year so that puts it in the

format we want I'm going to give you one

more since I'm here also here

I scroll over but I said before they have to

I think they upload this stuff into

some some sort of reporting terminal for

the government

sector of occupation this is there's a

code for what the volunteer is when the

volunteer signs up they select

what they are but we can't have them

select F or P or t they don't know what

that is and we have to have in this

format so this other field

let's look at that

let's let's find that

no I Gotta Go a different

gotta go to the volunteer

and go to sector

sector of occupation this is a multiple

choice this is what

they've choose from

so they can read and understand what it

is but we have to report it as one of

these single letters

so I made another

multiple choice Fields I believe

and it has all the single letters but

then it just has a conditional world

there's nine selections there's gonna be

nine rules if the sector occupation is cooperatives

and associations it's going to be C

if the sector of occupation is

an individual private farmer that's

going to be F and do that nine times

we're able to get

the letter so we can report it how we

got to report it

there it is so

that's all I got

hope to see you guys soon thanks

thank you

8 views0 comments


bottom of page