How to refer form fields in other application to current application. Both the applications are in the same account.
I need to refer a set of fields in a form in other application in my account. I have written code like this. But it is not accomplishing my requirement. row.Part_Number = FormA.Part[ID == PartID].Part_Number; FormA is the other application. Part is the name of the Form in other application. I need to refer all the fields in Part to my current application. Please suggest a solution for this.
Null Check in FX
Hi, Just created an overtime form for staff, but my Zoho is somewhat rusty after several years. Hours are calculated between a start date:time and end date:time: "Minutes" <((End_Time - Start_Time) / (1000 * 60)).round(2)> "Hours" <(((End_Time1 - Start_Time) / (1000 * 60)).round(2) / 60).round(2)> From these Minutes, I calculate how many hours were worked and if the person is eligible for 1.5xpayment or 2xpayment. "Overtime 1.5" <((Minutes - 450) / 60).round(2)> "Overtime 2" <((Minutes
Shared Users import via Migration Tool
I have shared an application with a user who I need to be able to import records using the Migration tool. The user is unable to select the Application from the list after selecting "Shared Apps". What applications should be included under "Shared Apps" for non Admin users?
Image note displaying when creating PDF from url
I created an HTML view with our Logo Image in the header. It appears when viewing the report, but not when directly creating a PDF from a zoho creator url. The source of the image is from a Zoho creator view <td width="60%"><img src="https://creator.zoho.com/ghsagjv/projects/Genre_LogoView/Image/image-download/1400541422986_GHSAGLogo.png" alt="" /></td> Screen shots are attached, that shows the same HTML page being opened in print view, and coverted directly to pdf. The pdf is created with a small
Deluge Field name moved
I love it! Thanks for moving the deluge field name closer to the display field name!
From Free-Flow Scripting, see: View names and Functions
When I'm in Free Flow scripting, I can use the Refer Fields link to reference forms and fields. That's great but I'd also like to reference: Functions with their parameters View/report names (which I need to reference using share/unshare)
Invalid entries found. Please correct and submit again.
Beginning today, I have begun to get the error message "Invalid entries found. Please correct and submit again." as I am making very minor changes to records in the database. Not all the time, but maybe 1 out of every 10-12 records this will happen. It was a valid record before, and all I am doing is copying one field and putting it into another field. It works most of the time. I have closed and re-opened with no change. When it happens I cannot save the record.
Permalink (Publish) form - unable to customize
First off it's been about four months since I setup a permalink to any form for public access so I realise the interface for this specific instruction set has changed in that time. OK so from my form I select Permalink and in the dialogue I select Publish, to make it public then hit Customize. I'm dropped back to the editor window and am shown a preview which updates as I change fonts, fields sizes, etc within the customization pane on the right side of the browser. The problem is the Publish URL
Functional-based URL strings with lists
In regard to functional-based URL strings at https://help.creator.zoho.com/Functionality-based-URLs.html I have a question about calling a view based on a list, generated from check-boxes on a form. Let's say the criteria is PET and the user can select any of Cat, Dog, Bird, Cow, Snake. How do we call a view based on PET={Cat, Snake} for example? Something like http://creator.zoho.com/admin/users/#View:User_View?PET={Cat, Snake} ?? John M. Whitney
Function Script Disappearing
I have a script to create a concatenated string (thanks Cyril). It works great in workflow under On Add/On Success and On Edit/On Success. What I would like to do is to put this script into a function and just call it in the workflow that way. I tried creating a new function and added the script. I saved it and called it in the workflow. No go when run. Blank. I go back to the script editor and the script is gone except for the bit on top for the string. Tried it a few more times, same result. Also
Questions | Zoho Creator
Hi Team, I have a few questions for you: 1. Similar to Zoho CRM Mail Add-on: How can we have a similar solution for Zoho Creator App so that all inbound and outbound emails can be tracked from inside the Zoho Creator App against the relevant Contacts (Note: "Contacts" will be a custom module inside Z Creator)? 2. We have created a Quote Template inside Zoho Creator. Now through a "Send Email" custom function we want to send that Quote as a PDF attachment to a contact. Is that something we can achieve
Fetch with two form criteria
Hi guys, a fetch question are drive me crazy. I need fetch data in FormA with some criteria from both form (A and B). I try with list or variable without success. Anyone have a idea how develop it? Thanks for any help. Mike Stafflist = (FormA[((Day = input.Day && Staff = input.Staff) && Availability(FormA) <= input.Availibility(FormB)].ID).getall(); Staff:ui.add(Stafflist);
Can't find my database at Zoho Creator after changing Administrator's email and password
Hello! The thing is, I can access the same workspace as I had before, with my new email address and password, but now there's nothing there, can't find my database, the workspace is empty. Any clues? Thanks a lot in advance (I'm so worried now...)!!!
iPhone App won't display reports in calendar view
I cannot get the Creator iPhone App to display a report that is calendar view. It closes the App when you try to open it. I have tried several reports. Works on Android App. Is this an issue?
lookup data showing up as a number
I know I have had this before, but I am having a major brain fart. data from a lookup field is showing up as a number when I try to use that field with the send mail function.
On insert access
Hi, I have created a custom action on the form A, that execute a custom function that insert a new record in a form B: void richiestaApi(string dominio, int registrarID, int operazioneID) { insert into B [ Added_User = zoho.loginuser Dominio = input.dominio Operazioni_disponibili = input.operazioneID Registrar = input.registrarID ] } I have also created a script On insert On access on form B, but it is not executed, even if the new record has been correctly created. If i
View an uploaded file without downloading?
So, once a user uploads a pdf, is it possible for a user to click and view the pdf in a new window, rather than downloading it and then opening?
is it possible to insert a data field into an alert?
I would like to reference a field in an alert box, how do i do that, is it possible?
Subform Fetch/Lookup
I am having a problem setting up a fetch lookup to a form that uses a subform. I have attached some screenshots to help me explain. Here is my main form. The BOM subform section is added as I create the MMR(master mfg record) Once my MMR is setup I will need to create a BPR(batch production record) for each production run that will include everything from the MMR. Here's what I have so far on the BPR form I have the lookup MMR set up & it works to bring in the Product_Name But I get an error when
Color Code Items in Calendar??
Hi Support, Is there a way to color-code items in the Calendar view? We have a client who would like to have this feature. Please advise. Thanks, egressmedia
Function definition
The zc help shows this example for a function. What should the code look like if I'm adding in a 2nd argument? openUrl(“#Form:Add_Meeting_Attendance?meetingid=” + input.id + “”, “popup window”, “height=400,width=550″);
can subform include loginuser and dated posted?
Can either type of subform (the one that is embedded into a field, or the one that connects to a separate form), include columns showing the logged in user and the date?
Combining Multiple Related Data On One View In Creator
I need to combine data from multiple forms on one view, similar to your CRM Accounts view. I need to have a main organization record with sections for contacts, etc. under it. I searched the forums and knowledge base, but cannot find the answer.
Zoho Creator fx formula help
I have values in my forms that are (36" - 914mm) and also (50" - 1270mm) i am trying to create a fx formula that will return the values of these forms so that i get (0.914) and (1.270) if anyone could help it would be much appreciated..
FieldType: Multiselect vs Checkbox
What is the difference between these 2 fieldtypes: 1. Multiselect - and then I can choose dropdown or checkbox 2. Checkbox
Help with some code Please
Hi, Could someone please tell me what is wrong with this code... myUrl1 = ((("https://creatorexport.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/print/"; rec = input.Job_Number; myUrl3 = "/fame=" + rec.ID; myUrl = myUrl1 + "Invoice" + myUrl3; openUrl(myUrl, "new window"); It is in the app new starlight digital which I have enabled for you if you need it. I have a feeling I have done the rec variable wrong but I am not sure. The code is attached to the action on user input of the print
Set Filters for dependent lookup fields
I have a form that contains two lookup dropdowns from two other forms. I need to populate the second lookup based on two fields shared by the the first lookup. I used the SET FILTERS dialog to generate ((((LGA==input.Ward1.LGA)&&(RA==input.Ward1.UID)))). However, the second lookup does not populate at all and only the first part LGA==input.Ward1.LGA gets persisted. Please assist. Thanks.
Scanner Interface
Is there a way to scan a document directly to ZOHO and add user defined terms?
Help - When trying to change Default Permissions for my forms the screen hangs.
In Enterprise addition I am trying to change the permissions on an form to allow public access. When I go to Settings->Users and Permissions->Advanced Sharing Settings. change a setting and then click 'Save' the screen hangs. Can anyone help me on this - is it a browser problem (although I have tried different browsers) and even tried on my Android tablet with the same results. I also occasionally get this when editing a script - dragging insert a function for instance causes the screen to hang.
Q: How to create Unique Index by combing two or more form field together ?
I know ZC only allows only one field in making unique index. Through deluge script, you can combine two or more fields in submit action to restrict dupplication. I know and did the same, but it worked partially for me. My issue is - as ZC consider lower and upper case separately, it allows duplicate entry when the data entered differently mixing lower and upper case though spelling remains the same. I tried upper function in my deluge script, still it didn't worked properly. It only works when
view only field
I have a parts_Used form that I want to show the current on hand quantity of a part. I only want to show the user the current on hand and not allow any changes to the field. Is this possible? The field I'm currently using is a numeric type.
Q: How to customize ZC form field positions and style as required.
1. I am trying to develop an application whose one of the form would be like: 2. I set the form as Two column wide. Lower section contains the sub-form which may be extended many many lines as more and more product variation is added. 3. Accordingly this form may need to be extended multiple screen down, which means Submit button will be placed in a place which will not be convenient and user friendly. 4. Unlike ZC default CSS settings, to make the application more user friendly I want to customize
How can i put my google calendar insde zoho creator?
Can you help me with this? I really need this done.. please
how to hide admin email address?
hi use workflow rules and send email in manner "if this than that" when i tune email sending systems asks me to send email from admin email or to admin email in all cases systems asks me use admin email how can hide admin email from email body i need use admin email only for system needs on other hand - system do not accept using admin email only in bcc field i need hide admin email in from: and in to:/cc: fields.
Potential Misconfiguration in Maximum Number of deluge sendmail Statements
In my database, I have assigned a numeric "group" number to 259 records to control how many emails get sent using the following function: void NOTIFY(int Group_Number) { for each row in parent_database [Group == Group_Number] { sendmail ( To : row.Parent1_Email From : zoho.adminuserid Subject : "sample" Message : "yadda yadda" + thisapp.printout(row.user_key) + "yadda yadda" ) } } The function thisapp.printout(row.user_key)
How to filter report to exclude sub-form dates
I'm trying to create a list that identifies accounts that have no activity in the last 4 weeks. My main Accounts form has a sub-form for Activities, so what I was hoping would work is: show all rows from Accounts [!Activities.Activity_Date in last 4 weeks] but the use of ! to create a negative doesn't work. If I try to use >, it won't filter Accounts that have activity both before and after the 4 weeks. Is there a !> function, or some other means to say "not after" I've tried using other deluge
String and Date Handling from Multiple Fields into One (newb)
I need to do the following and was wondering if anyone could offer some Deluge pointers. I have a form with the following fields: Date (date) Room (drop down with three choices Room 1, Room 2, Room 3) Class Title (single line text) POS Title (single line string with 30 character limit) The task is to convert the Date, Room and Class Title fields into a string that will be fed into the POS title field in a specific format. Here is an example: Input Date: July 1, 2014 Room: Room 1 Class Title: Underwater
Fetch CRM Field from Another Creator Form
How do I fetch a CRM field from another Creator form? Order form has a drop down "Generator" linked to Generator form. Generator form has an Account CRM field. I have an Account CRM field that I want to update in my Order form based on the Account linked to the "Generator" drop down. (For us Generator is an environmental term for a facility that requires service / Account is the company that will pay the bill.)
Radio button add date
Is there a way to automatically add & display the date, in line, when a radio button is checked. My example is in an application for construction progress. I have a check box radio button for when the rough in wiring is complete. I would like to show the date when the box is checked so I know when the work was completed. thanks
Maximum published components limit - for Professional and Enterprise
I currently on the Standard Edition Problem 1 How do I do this, public sharing on the web? https://www.zoho.com/creator/help/application/application-sharing.html#Make_Public_to_all_visitors_over_the_web I don't see the option in my account. Problem 2 I know the maximum published component is 3 for Standard edition. But what is the limit for Professional and Enterprise? Problem 3 I try upgrading my subscription by selecting Professional edition and upgrade, but all that happen is the page submit,
Next Page