Set Null Users Field
Good day, I have a function to create records with deluge insert into, inside the form I have a Users field (Customers), the problem is when the Record is created this field fills automatically with the loginuser info, even setting in the insert into instructions to set this field as null. What should be happening?
Find records for value in Multi Select lookup
Hi There We have a form (Case_Details) which has a Multi Select lookup to another form (Client) On saving a new Case_Details form we want to find any other cases that relate to any of the selected Clients on this new case. I have the following deluge script and the line highlighted bold is not valid for some reason clients = Client[ID in input.Client_Names]; email_body=""; for each c in clients { //find any other cases which are for the selected client matches = (Case_Details[Client_Names.contains(c.ID)
Bug: Insert into deluge script doesn't work on Mobile.
Hi, Insert into deluge script doesn't work on a standard form via the Zoho Creator Mobile App. I have shared the application with support: https://creator.zoho.com/johndobble/bugs/#Page:Standard_Form Please advise. Regards
Duplicate Allowed and Successful - When It Should Not
In testing my application, I have found that ... I have a form with a field that does not allow duplicates (LoadID) and is mandatory. However if I go to the record and select duplicate, the process will succeed and I will have a record with a missing LoadID, as well as the corresponding child records. Why is this? I can think of a handful of potential clients that may find the duplicate feature useful, but as it is, I will have to explain to all that "duplicate" can have unwanted results until such
Reload Dashboard from Iframe
Good day, I have a Dashborad and inside two iframes, one of those iframes I have a record edit, in the record edit On Success I have the following script, openUrl("DashboardUrl", "parent window"); When I update the record nothing happens, but If I use "same window" instead of "parent window" the OpenUrl work inside the Iframe, but I want to load the page in the Main window. There is any alternative to reload the main window Dashboard?
Iframe Record Edit OperUrl
Good day, I have a Page and inside two iframes, one of those iframes I have a record edit, in the record edit On Success I have the following script, openUrl("MyUrl"parent window"); My problem is that when I update the record nothing happens, but If I use "same window" instead of "parent window" the OpenUrl work inside the Iframe, but I want to load the page in the Main window, there is any alternative to do that?
using distinct function
I have a blank multiselect field called 'WO subtotals ' (WO short for Work Orders) I have subform Containing a WO Group field and an Est. Hours Field and a Create New Group Field in each row starting with a value of 1 in the 1st row in the WO Group field each new row will be also be 1 until I select 'Yes" in the Create New Group field of a given row, then that row along with all succeeding rows becomes 2 until I press it again, then it become 3 and so on I want the sum of Est. Hours for each
Show only "active" choices
I am developing a custom employment job board. I have created a webform where the HR department can create a "job posting". In the "job posting" form, HR can select active or not active for the job. When the applicant fills out the application form the "Position applying" field is a lookup field that relates to the job posting form/database explained above. Here is my question: How do I restrict the lookup field for only job postings that are marked "active?"
Fetching and displaying form data
So I have one form with supplier information, like name, location, contact, email...etc. Then I have another form with product information, like a product type (baby clothes, or adult tshirts..etc), a photo, price, and dimensions I related the forms together using a look on the product form, which looks up the suppliers name. So the plan is to goto trade shows, collect supplier information. Then take photos and capture details of all the products they are displaying. So what I need to do after, is
How to get a sum for "Total Points" based on "Points" entered for attendance and show it in the "Total Points" field on the same form.
I am a newby...so bear with me. I have a form called, "Employee Personal Data" for personal employee info. I then have a form called "Employee Attendance Record." On this form I have a field called "Points" to enter .5, 1, 1.5, 2, etc. as points for an absence. Once entered, I want the "Total Points" field on the Employee Attendance Record form to show the running total for the year for that particular person (up to 12 points total). I have a Lookup Field to pick the employee's name from the Employee
if statement at form 'on load' using lookup dropdown as criteria
cant seem to get this to work....please help if(TZ2WOF_PEs.!= "-Select-") { TZ2WOF_Select.deselect(); show TZ2WOF_PEs; TZ2WOF_Select.select.("PEs"); } fyi TZ2WOF_PEs is lookup field in dropdown mode TZ2WOF_Select is a checkbox Thanks in Advance
Stateless Forms Usage - General Questions
There is very little explanation of Stateless Form and how to manage their implementation in real-world application. There are some things I need to do that a basic report just can't do, and I can only guess that a stateless form is the only option, but then I come to find you can't do many basic things with a stateless form. Example, I have a form that gathers fuel purchases in both US and metric means. It stores date, location, odometer, and quantity. I need to be able to present the user with
Lost the ability to add new entries to dropdown linked to another table
Hi We have a form that allows the user to add new entries to another table if there is not an existing record in a dropdown list. But this seems to have gone now. Can someone explain how we can reinstate this please? Thanks
Will Pay for Zoho Specialist
To whom it may concern, I am finding it nearly impossible to complete even the most basic tasks using Zoho. This is clearly a powerful platform but I will never be able to use it without assistance. Will pay to have phone access to a Zoho specialist for one week. Regards
Master Field overriding All rows of Subform field
My form as a 'Master Approval' dropbox ( Pending, Approved, Denied) as does the attached sub form. I'm asking for some help in coding my Master Approval field so that when a new choice is selected it overrides the selection in the Approval fields in each row in favor of the MASTER APPROVAL Selection. Has anyone had experience with this?
Build Custom Report - Access Relational Data??
I hope I'm missing something, but I have an application working great with a number of relationships between forms. Zoho does a great job in creating the underlying default report to include the relational form for access, however when you you want to create a pivot table custom report, you are not allowed to bring in the related table (form) to use these fields for the report. Why can I ONLY choose from forms, and not existing reports, to build another report that is truly meaningful, utilizing
Custom Actions - sequence by Action Name
I've created several custom actions so that when a user is at a row, and they select that row, they can access the Custom Actions. Great. HOWEVER - the custom actions appear in the order that I've created them!!!! How can I make the default sequence be alphabetical by Action Name????
Possible To Easily Persist Data With Application Distribution?
Is there an easy way to persist the data in chosen forms to remain with the application during shares and copies? If a customer is going to have to do some importing upon first obtaining the application to allow for basic operation, this may be a deal-breaker for some. My application has 95% of the "items" a user will need, and all they would need to do is plug in their own price defaults. Their unique items can also be added as necessary. But I want these 30 or so items to be a part of the purchased
How to retrive date stored in table
I have one stateless form which has date field and which is storing in table. I have functionality where for particular ID i ant to retrieve data from database there i am able to retrieve all data but i am not able to retrieve date. How can i do that?
Decision Box On Report
Is there a way to make a decision field type display as a "checkmark" on a report? This seems like such an obvious option to include in basic reports design. It looks great on a form as a checkmark, but on a report listing showing a bunch of "false" and "true" entries is not very appealing when all you want to see is a checkmark, or no checkmark, and in fact it's hard to easily distinguish if it's true or not without hurting your eyes. Am I missing something?
Usage of lookup field. Form1=>2=>3. Can Form 3 get info from Form 1?
Hello Now I'm making an application like below. 1. formEntryAllUser =>Name,Email,Address ...etc basic infomation 2. formEntryLimitedUser =>Lookup to form1,some additional info 3. formEntryInfoOfLimitedUsers =>Lookup to form2,additional info necessary only for limited users Now I've finished creating these forms and reports. I want to use basic information in form 1 like name, email etc in both form and report 3. But in form 3 (there is only lookup to form 2) , I cannot get information
Mass Data update to Form
Hi, I have a form like below where there are three columns like -- county , Fips, Housholds 2013. The first two columns county and fips never change. But the third column Households 2013 will be changed every year. There are around 3,000 rows of data of this form view. For now all of these columns are now connected to several forms by anyway in the entire application. below is the form view screenshot : my question is that what is the best way when I will try to update the Households 2013 column
Using MASS UPDATE to update other Fields in Creator. Or using WorkFlows with Custom Forms.
Using MASS UPDATE to update other Fields in Creator. Or using WorkFlows with Custom Forms. Hi. I need to do a bulk update so that when a field is ticked, another field updates. I.e. "Confirmed Status" is ticked then a text field called "Current" status would be updated with the text of "Confirmed". I have created an app to do this. It does lots of checks and the code works great in a single form as it uses the OnSuccess events and the OnChange events that happen when creating a new entry or editing
How can I set a custom filter for a multi-select checkbox field?
Hi Zoho Experts! I'm trying to create a custom filter/view in a report that relies on information from a field that is a mandatory, multi-select checkbox in the original form. The field is "Season" and the values in the field are "Winter" - "Spring" - "Summer" - "Fall" I need to create a custom filter/view that allows me to see all items that have both a "Fall" and a "Summer" value attributed to them (regardless of Winter and Spring). I am able to create a custom filter for one season, but I am
Programmatically Add (Insert) Child Records Upon Parent Add Event?
Is it possible to programmatically add child records [to subform] on the "add record" trigger of the parent form? For example in a basic order-entry application. There are Orders and OrderDetails. OrderDetails accepts entries of Inventory Items. For example, an order may be of a specific "type". This "type" typically includes 10 of the same Inventory items that meet a certain criteria according to "Class" or other field value. So when this "type" of order is added (initiated), I want to programmatically
Report using zoho creator
Hi, I have created one property application in zoho creator, so i want to take report by monthly wise. For Ex : Jan Feb ......... upto Dec AAA 12,00,000 3,00,000 5,00,000 BBB 23,00,000 12,00,000 9,00,000 Issue is Date Format is nt accepted this type of month value, i have one date formatted column.(Added_Date) Can you please ans for this one .........
Automatically update Zipcode
Hi , I want to update automatically zip-code in fields For ex : Location ------ OMR Zipcode ------ 600003 It's is possible in zoho creator,i think it will take from Google Map or other sources
Add Record, Only Want Some Fields Available Before Submit Button
I'm looking for a clean way that when a user wants to add a new record, a "form" ("report"?) opens up with only the key required fields available for data entry, before the Submit button is displayed. In this application, when a new record is added, the remaining 60% of fields are not required as the data for them is not yet known. I don't want the user to have to scroll through many times to get to the Save button far off-screen at the bottom. Also, along the same lines, if I have a report that
How can I allow another user ability to edit my application (add new forms etc)?
I would like to grant another user permission to edit my application, please tell me how I can do this? Thank you, Bianca.
Convert HTML to PDF with filename
Hi, When using the header option pdf = true in an HTML view is there a way to generate the PDF with a file name other than the name of the view? Any help would be appreciated.
Auto Duplication of Form Entries based on Criteria
Hello, I am currently building an Invoice Program in Zoho Creator due to Zoho invoicing not having everything that we need. I need to include the ability to allow re-occurring invoices which are duplicated every month based on the original invoice. I currently have a tick box which if ticked I would like the system to create additional entries once every month until it is stopped. Is this something that can be done? Is anyone able to give me some advice.
List in sendmail
Hello everyone: I have been using a string variable to "build" the list of email addresses that is used in the To: line of the sendmail task. See portions of code below: if ((peemail != "") && (peemail != null)) { toEmails = toEmails + "," + peemail; } and the To: line: sendmail ( To : toEmails, input.Email1 I can't take credit for this genius bit of coding as Zoho did it for me to resolve a sendmail issue I was having. This has been working for a long time and recently
Fetch, Update, and Schedules
Hello! I have a form that has a drop down called "Status" which I use to filter for reports. I'm using the Schedules feature to send a report of records once daily based on the status field. I'd like to create a second schedule to update the status field shortly after the first report is sent. Is this possible? Thanks Arlan
Formula update
hello, By example i would a number field witch is the subtotal and a formula with TAX and formula with Grand total I would that when my script deluge calculate the SubTotal the TAX and the GrandTotal will be update automaticlly. Is it possible ? thanks you
Display next record +1 on next Add row in SubForn
Hi I'm trying to have the next field to be = Previous record value + 1 so I can start working adding Lines every time the user hits Add new in the Item_Sub Form. Try this but only pass as result = 2 to all new records. x=(row.Number + 1); row.Number=x; I'm completely new on this code trying to learn. Your help will be greatly appreciated.
sharing
hi : i am new to zoho and so using a free version to devlop a small app by it . i have shared my app with a friend ,which appears on his account page as a shared app,but it denys access, is it because of limitation in free version ?, or i miss a setting to let him use it..? please help
Filter of Checkbox Field Not Working in Reports
I have a Form called Fuel Order. On this form I have a checkbox field called "Invoiced" with two options, "Fuel" and "Freight". When I try to generate a Calendar Report showing only selected records, using this logic: "Invoiced" does not contain "Freight" This does NOT work. It shows all records. I think it is a bug. https://monosnap.com/file/Mq5z8WYfxPbqfLPQhrlc9u6g2XiCiG Any help would be greatly appreciated.
What better way for a veterinary consultation record ?
Hello , I need to create a query form for animals. 1- How do I create queries in the customer file so that the history be stored and has good usability mobile? And may I add the service values at each visit ... 2- How to make two date a form fields appear on a calendar ? I need to schedule more than one procedure but could only configure each on a different schedule. Thank you!
In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid
I am having a problem with the following code. QBD_Line_6 this is result from a user selecting from a Lookup field QBD_Type is the field that the Lookup field draws from QBD_Cost is the form that all the data is drawn from Cost_per_Pc is a cost associated with each QBD_Type QBD_Value_Line_6 is the field that the cost should display to the user. if (input.QBD_Line_6 != null) { temp1 = QBD_Cost [QBD_Type == input.QBD_Line_6.toString()]; input.QBD_Value_Line_6 = temp1.Cost_per_Pc; } This code gives
Bug in Creating URL's
Hi! I am getting a REALLY weird problem. I have the exact same email being sent to two different people. On one of them the a URL in a link (generated by Zoho Creator) is different that the other. Just a tiny difference. Why? See here: The Correct Link: https://creator.zohopublic.com/jjmancini/fuelorders-v2/view-perma/Stateless_Carrier_Acceptance_HTML/12345YFYyjw1PECxegqWkRMeGHhMCS0u6dYZ61OtJuUR7axhbawj3qPkyW87JpeEP3pCWrH5M4RW7ubQ84658XPFS06jKt6Qj/Order_ID=555539000012469123&Carrier_Reply=Yes&CarrierSCAC=XPER&Carrier_Contact=555539000004748233
Next Page