Lookup filtering and subform
Hello, could you help me? I've a form (i.e. customer) with subform(i.e. cars). in another form, I need to filter lookup CARS when I choose the CUSTOMER. How can I do it? I already seen the link, but it don't help me. Will place an example for clarity FORM A Customer name Subform Cars (plate, type, color) FORM B Lookup Customer Lookup Car in Form B, if I select the Customer "Mr. White", I would like to see in the lookup Car only the cars of Mr. White. Can I do this with lookup filters? How? Thanks
Bug in getDayOfYear function
I have found an issue with the subject function. For my testing I have the following: The values are: input.Loan_Date = 12-16-2014 16:00:00 input.Claim_Date = 02-16-2015 and I have the following code. input.Number_of_Days = (input.Claim_Date.getDayOfYear() - input.Loan_Date.getDayOfYear()); The result: input.Number_of_Days = -303 I have run a few test data and it seems this bug occurs whenever the year are different. If it's the same year then the getDayOfYear function works Ok. Has someone encountered
Hangs on "Adding..." when inserting new field to form
My items were all working correctly yesterday until mid-day when suddenly adding any new fields to the form (Drop down, Single line, Check box, anything) result in the page simply hanging with "Adding" for the field. If it is a lookup source, it does go through to steps to determine what the source will be and has the same result of the addition simply hanging there... Any suggestions?
Custom Schedules
Hi Guys, I have a requirement to create custom schedules that run every 14 days and every 30 days. It looks to me that I can't do this as the options are daily, weekly, monthly and yearly. Perhaps I'm missing something? Thanks for any assistance!
How do I associate a Customer portal login with an account ID?
I want the database entry form accessed by the customer portal to pre-populate with an account number assigned to the customer logging in ... how do I do this?
Report View
I have my database set up and want to view it by item # in a report view. However, when I look at the report for each item, the rows are so spread apart that the report runs over to 3 pages. I want this to be single spaced so that everything fits on one page. Any idea how to do this?
Creator Icon Images are gone
Dear Zoho, Over the last couple of weeks something must have changed in your Creator backend infrastructure as the majority of the UI images are gone. Images like https://creator.zoho.com/platform/helpdesk/images/app/spacer.gif now report a 404 If I go to the Admin page in order to add technicians the following screen (see attachment) shows up, and it looks bad. Could you please fix this? Thanks, -Jaap
Subform Links in List Report
I have put Multiple SUbforms in my Parent Form but when I access the Report, List style, and i choose to access the Info in the SUbform Via a link in the Report i am no being shown the Data inputed into the fields. I am only getting Field names displayed when the link is clicked. Is there something i can do to have the Data included in the window generated by the Link?
How to learn input.vars or the Record ID within "On Delete" script?
Seems that both OnDelete.Validate, and OnDelete.Success, are unaware of the form's input vars?? The same scripts that work in OnAdd, and OnEdit, don't work when in OnDelete. Seems not even aware of its own record ID, at least not via input.ID. I must be missing something... :-) I have searched the dox and forum. How do I learn at LEAST the record ID, so I can look up the field values via x = <Form>[ID = input.ID]; ? In this our first brush with On Delete, we are updating some record counts successfully
"sharing done with selected users"
I have 3 more opening for users yet I keep getting this message. When I send a invitation the recipient receives the following link and not a invitation. How do I fix this so the recipient receives second invitation below. Invitation # 1 Hi, Check out my ' US-CAT ' application in the below link. https://creator.zoho.com/inovacion/us-cat/login/zc_email=jcolburnus.cat@gmail.com Have a nice day! inovacion Invitation #2 Hello and welcome skutzkeus.cat Thank you for registering with Zoho Services.
Need help defining a reports criteriia
I have a form "Site_Directory" that contains information regarding customers sites - including the managers name, his email, the stores location and location name etc.. Using the customer portal - The manager logs in ( using his email address as a login) - and is presented with a form to enter asset data. Within this form, by using deluge script ( on load) - I can identify which store etc. he belongs to, which helps pre-populate the form called " Asset_Management" where data regarding the stores
Can you allow editing in a multi-text field in a stateless form but not delete previous input in that field?
I have two Forms - one is called New Request, and one is called Request Status (stateless form). Employees will fill out the New Request form when they are requesting something from the Purchasing department. The requests are then emailed to the appropriate Purchaser upon submission. I have placed an Auto Number field in the New Request form, and a corresponding "Request Number" number field in the Request Status form so that upon receiving the request via email, they can enter the Request number
Cant access my forms, blank page shows when trying to load any regular form
all of my forms are showing up blank
URGENT! how to disable export entries for users?
hi need to disable export permissions for all users except account administrator how to make it
How to create a Customer Card?
hello, I'm new to the world zoho. I'm trying to create a database of clients, connecting multiple tables. I would like to create a page: 1) with a drop down menu where you can select the customer by Username; 2) extract, by query, all the necessary information about the client from the join of multiple tables ; 3) print to video information (i.e. photo, name, phone Number etc ...) Can someone help me? thanks a lot Giuseppe
Retrieve data based on each Multiselect selection
hi, I have a multiselect field and I would like to retrieve the value from another view based on each multiselect selection and input it another field View1: Form: when user first selects the 1001 in the multiselect field then a script will retrieve the respective "Subs" value from view1 which is 3000 and input it to "Est.Subs-Selected Fips" and then when user selects next Fips value --1003 -- then the the "Est.Subs-Selected Fips" will be updated to 4000. Could anyone please help me on script ? Thanks
Switch statments
HI I am in need of using Switch statement in deluge script for an application which i build. by switch i refer to this statement in PHP: $i switch $i { case 0: Do something case 1: Do something else } Is there such a statement in deluge? if not, can you add this functionality? Thank you Tal
Kitting or multiple units, stumper
So I have multiple forms: Form1 Form2 Form3 Form4 Form2 contains a 1 to many relationship with Form1 example... in form2 I have UNIT A, which contains multiple Items from Form1 so UNIT A may have ITEM 1, ITEM 2 and ITEM 3, all with different quantities I want to be able to select UNIT A in Form3 and have it create an individual record in Form4 (I think thats what i want to do) for each Item in UNIT A Thanks
can you pass data from one form to another that the first form opened with an open url command?
can you pass data from one form to another that the first form opened with an open url command?
Look up field value different in view than when editing record?
Please take a look at the following screen shot. Highlighted in Red: Request_ID shown in view = 1185428000007018175 - m3steele@gmail44.com - 9 Highlighted in Green: Request_ID in edit record = 1185428000007018240 - - m3steele@gmail44.com - 9 What is wrong, why is this happening? Im not sure if the value is set wrong or what. I know the lookup field is referring to the correct record because of the part " m3steele@gmail44.com - 9" that is also included. These values are not in any other record in
How to fetch date data from completed form
Hi I am very new to this software, and would appreciate some advise I am building an application to log maintenance on a variety of hydraulic and mechanical equipment. I have created the forms, that include all required information fields, including the date that the work was completed. What I would like to do is have a field on the form, that will automatically fill with the date that the last maintenance was completed on. I think the fetch data is how I need to do this, but I am pretty lost trying
Track number of times form completed by each person
Hello, I wonder if anyone out there can help me. The nice guys at Zoho support have tried to help me but unfortunately it doesn't allow me to do what I need. I have two forms: 1. SERVICE USER DETAILS (name, address etc). 2 WELLBEING They are linked through a look-up field on the wellbeing form (last name, first name, DOB). Each service user will complete the wellbeing form a number of times over a period of months/years. Each time they complete the form, I would like it to capture that this
Linking fields and forms
I am creating a client database for my Dog daycare and i am running into a couple problems with linking fields and forms. I have one form called Customer info and this form has fields for name, Dog's name, number, email, Daily Credits and a sub form for vaccination records. MY second form is called Dog account/payment history. This has a look up field for Dog'ss name, a radio button for Checkin/Checkout , a payment field, and a Credit field. I would like to link a couple items: 1. I would like to
CSS HTML Image Holder Align
Hello, I have a CSS holder for an image but I cant align to the center I have the following script: CSS .holder { width: auto; display: inline-block; } .holder img { width: 30%; height: auto; } HTML output = output + "<div class='holder'>"; output = output + "<img src='IMAGE.jpg';/></div>";
using stateless form from data entry
I am using a stateless form for data entry (timesheet application) I would like to attach a file or image of the actual timesheet to each record i create with the stateless form. I know you can add a file with a normal form and copy it to another form when you submit.
How to show report from button onClick event?
Sorry, can't find this in Help. I want to show report for a particular month, selected by user. I create stateless form for month input, with Submit button; all works well. Now, from onClick deluge script, I plan to launch an existing report. What is syntax to do it? Second question: how can I send a parameter (month number) to a report, and how can I use this parameter inside report scripts, what will be a name for this parameter?
Is Hide/Show available for formula fields?
We're desiring to conditionally hide/show a set of fields, 2 of which are formula fields. All is OK except for the formula fields. The editor refuses to save, unless we comment out the 2 formula fields. The error is "Hide function cannot be applied for <fieldname>". And, "Show function cannot be applied..." These 2 fields have the "Show on Form" option selected, because we DO want them to show on the form. ...Unless they are hidden with the set of fields. (I am using the Deluge names for the
Data not properly exporting from ZOHO creator, what can we do?
I am using the free version of Zoho Creator and I want to export the assets list I created; however, a ll the data that is available in edit record, which we have maintained, is not exporting. It is only exporting the summary and is missing the title, purchase price, purchase date, rego, colour, year, notes as well as some blank fields. How can we resolve this issue? Thank you for your assistance.
Error occurred while executing the workflow
I'm getting this error when I execute a function "Error occurred while executing the workflow". The function reads a record and then creates records in several other tables. Does anyone know what error this message indicates?
How do I persist values in lookup field?
I have a timesheet application, where the field "Customer name" is a lookup in Customer table. The customer table will occasionally be wiped and new valus inserted. Unfortunately, this deletes the lookup values in the Timesheet table. How do I keep the lookup values? It is OK that the lookup values is not valid for old records, but new entrys should only use current rows in customer table.
Application Loss of Formatting
Me and several of my users have regularly been loading our creator app but instead get a format-less page. Has anyone else had this problem and know the fix? It happens with explorer, chrome and opera with several different user accounts and computers but never consistently. Sometime a refresh fixes it, sometime not.
Add a date restriction to a Zoho Creator date field?
Here's a quick video that describes my question. http://screencast.com/t/fb3oCO5JCHEc I want to add a restriction on the date field to not be able to choose a date unless it's three days into the future. Any assistance is appreciated!
Unable to hide/show field based on fetch data field
I have two forms: New Request and Request Status. In the New Request form, I have an AutoNumber field, then many other fields, including Request Type. Staff members are to enter info into the New Request form, then based on their requests, an email is sent to the appropriate Purchasing Staff member. Request Status is a stateless form, and I have the Puchasing Staff member entering the AutoNumber that they received from the New Request form email notification into this, which then auto-populates fields,
Tooltip on Forms not working
OK - maybe it's me, but the Tooltip function is not working for me. Is there a secret trick?
CREATOR work offline
In the future you have plans to increasing Creator to work offline?? Sorry for my english and tanks
convert single line field to rich text
After entering more than 10,000 records, I now find my single line field with max of 255 characters is not enough. Is there a way to covert this single line field to a Rich Text Memo field without losing all the already entered data ?
Inserting Comments into Free Flow Scripting
Can't find an answer to this, so hoping it hasn't been raised before. Whenever I attempt to add a comment in free flow, like this: //comment text I get a "null" error. It works in script builder, but I want to be able to do it within form definitions and so forth.
Auto-Fill text box
I am trying to autofill a text box based on what I have chosen in the above lookup drop down box. This is linked to another form. Form 1 - New Request Form - this has the fields Supplier and Manufacturer Code. Supplier is a lookup drop down field which gets its data from Form 2 (Suppliers form). Manufacturer Code is a text box which is supposed to autopopulate. I would like to choose a supplier in the Supplier field and have the Manufacturer Code auto populate in the Manufacturer Code textbox, but
Duplicate application
Hi, I'm trying to duplicate my application (penta-crm-11) but it's not creating another one. Pls suggest. --I have shared application to support.
Is it possible to bring auto alignment inside deluge scripting?
it is very difficult to align when we do free style coding
Next Page