Can note(plain) field's value be used in action?
I know the note(plain) field's content can be written in, but can it be get out and be used by other fields?
From Creator get a record from ZOHO Crm by using the Lead ID
Hi, I know the lead ID of a record created in my ZOHO CRM My Zoho CRM and Zoho Creator accounts are linked I tried this crmResp = zoho.crm.searchRecords("Leads", "(LEADID|=|520729000000065376)"); but get an error {"4832":"Invalid parameter value"} Any advice on how to achieve this ..
Getting the lookup field value in string format only
Hi, I am writing a script where in i need the lookup field value as it is For eg : I have lookup field for Order Number which is pure Numbers (002202023, 039393393 etc) But now when i am using it in script inupt.Order_Number so abrupt value pops up i guess Please guide
how to create a button in a form to open a new form in pop up window.
how to create a button in a form to open a related form in pop up window. pls help.
Is it possible to create a Creator app that pulls events from Zoho?
I want to create an app that pulls accounts from Zoho and events so I can plot check ins on a map. I need to be able to let our outside salesmen see how long it's been since their last customer contact. It appears that I can only create a map that plots data created inside the app from a form? surely this isn't the case. Dan
C5 and Google Maps API... OH MY!
So I've found one video on the internet that shows what I basically am needing to do. I reached out to the author, and found that he would develop it for me if I was so inclined. I would much rather continue my learning of C5 and deluge, so I'd rather find some examples out there and work with them to build my Map. https://www.youtube.com/watch?v=3e7XyIDtP3E ZOHO's support said that their own built in Map cannot do what I'm needing, so I will have to use the Google's Map API. I have a key and am
Takes the temperature from IP Address
Hi All, I am hoping if someone can help me here. I have been struggling how to get the customers IP Address and then transfers the data to the temp field on success of form. I have found a free way to get the weather from IP Address. //Get the user's IP address $user_ip = $_SERVER['REMOTE_ADDR']; //The Data Science Toolkit URL $url = 'http://www.datasciencetoolkit.org/ip2coordinates/'; //Find the user's location from their IP. //*** You need the get_data function from the sample code $raw_geocode
Calendar - making an appointment
Hi Guys I have an app that I use to create appointments - its in calendar view ... This is the issue : Say I make an appointment in two weeks time at 9.30 .... I go to that time ,see that its clear click an add the appointment ... BUT it defaults to current date / time not the selected date and time... Is there some code I can add so that it uses the selected date /time and not the default Now date/time. Can any one give me some clue to fix this please...this super frustrating.. { displayname
Mobile app - Offline mode
Good day, I am developing a form in Zoho Creator. I have a few hidden fields based on the status of the form. However, when I use the Zoho Creator mobile app in offline mode these hidden fields are NOT HIDDEN. Is this a known issue or am I doing something wrong? Thanks.
Can Zoho Creator Groups be nested?
Can the "Groups" be nested? Ref: http://help.creator.zoho.com/Manage-Groups.html In my Creator application I would like to create an hierarchy of access by means of using groups. E.g. employee group has assess to 2 views and manager group has access to the same 2 views and 1 additional view. So that I share with 2 views with the employee group, make manager group a member employee group and only share the 1 view to the manager group rather than having to share all the 3 views to the manager group.
PLEASE add support for self referencing table and tree view in report
Hi, Self-referencing table is a basic feature in a lot of comparable software (Access and Filemaker Pro). It's frustrating to migrate here and be left without the possibility of doing so. Self-referencing table is critical for allowing sub-record (sub-task, sub-milestone, etc.) management. If you have a Task form, you might want to allow your users to structure their work in a task/sub-task way. Zoho Project allow such feature. For this, you need to be able to reference a task to its parent task.
Deluge Script Alert function Not Showing
Hi I have the following deluge script in the On Edit, On Validate section of my form alert ("Testing"); info ("Testing"); The info line works fine the alert doesn't. In the Zoho script documentation I find numerous mention of using the Alert in On Edit On Validate section. Has something changed Thanks Gordon
Themes custimization
Hi there, Its great to see ZC adding more theme to the app, especially the recent icon vertical layouts. But please.... ADD SUPPORT FOR CUSTOM COLORS! We build apps for clients, who already have their own color scheme for logo and such. You need to stop forcing us to use specific colors for headers and font and buttons and etc. Please add in the Theme menu the following customize options: - Header background color - Primary and secondary buttons colors - Link font color Or please at least, let us
Newbie, question about Fetching
Hi, i'm new to Zoho, and have a question about fetching. I'm used to Acces and a bit of VBA, where i'm used to open a form and where i can have a subform based on for example a CustomerID. I've looked into the help files concerning Fetching and stuff but i just don't seem to get it the right path perhaps one of you could help me ? I made 2 forms form A holds Customers, form B holds CustomerContacts. So a customer can have a brother.sister,father,mother as a contactperson. What i want to is make
Filter entries in view by date - how?
Hi i need make view in which there is entries that are today/yesterday old so that entires before yesterday are not showing in how can i make filter in view on current date?
Creator emails dropped by domains with DMARC p=reject or p=quarantine
Is there a way to send DMARC aligned emails from zohocreator? The organizations I work with have strict DMARC policies and I don't believe the emails coming from Creator are aligned. There's not a way to "whitelist" as other articles have suggested. Is there a way to enable DKIM signing for my organizations? For reference, I'm seeing emails coming from 135.84.80.180 sendera180.zohocreator.com 135.84.80.182 sendera182.zohoRECRUIT.com 135.84.80.183 sendera183.zohoRECRUIT.com If there's not a way
Zoho Creator On Premise
Hello. Some questions about Zoho Creator On Premise. 1.How i can download .zar file ? I don't see in options Options > Try On-Premise in my account. 2. Zoho Creator On-Premise comes with an "Evaluation licence" that lasts for 30 days from the date of installation. Do you have test mode for On-Premise version to test my application offline (test connection between On-Premise and another sql db's or ManageAngine Analytics Plus offline vers. etc) 3. I want to connect https://www.zoho.com/appcreator/
Calculate number of business days between two dates
I just wondered if Zoho Creator now supported calculating number of business days between two dates. If yes, could someone please offer some assistance and provide an example script. I know how to workout days between two dates but struggling with business days. If no, can someone provide me an example and instruction on how to write a function, or is the below example from 6 years ago still relevant? https://help.zoho.com/portal/en/community/topic/calculate-number-of-business-days-weekdays Thanks
Display picture in HTML Page
Hi Zoho Team, In my app "Sourcing Database", there is a page HTML that can be access from the report: "View/Modify Products" in order to display in html the info from "Create_Product". I have made the code to display one of the image field but still cannot display it. What did I do wrong? Is it about putting this app public? if so, what will be the risk for the security of this app? And how to arrange the size of this picture in the HTML view? Thanks in advance Julien
Zapier does not register subforms as adding a new record
When I add records through a subform, this does not trigger the Zoho Add Record trigger in Zapier. When I add the record through the original form it works, but this would take a really long time for my purposes. Will this be changed?
Conditional formatting depending on checkbox
Is it possible to conditionally format a field depending on the value of a checkbox? The checkbox fields do not appear in the list when setting the conditional formatting.
, in number field
How is comma in number field not available... basic for 90% of world.
Search records from multiple fields - Like a Google Search
Hello, I would like to be able to have a form with a search feature which can draw from multiple fields on another form. FORM A would be for all the data entry of the records. FORM B would require the search feature, and would be to record usage of the items recorded in FORM A. Is this possible to do, and if so, how would it be done? Thanks in advance! (Im still very new to this whole database thing so I have not alot of ideas how this more complex stuff works) Example: FORM A --- Song Title Artist
Help with subforms fetching
Hi guys can anyone help me. I have a system to control machines where a have 3 forms. First one is a base lookup form that goes: Shift Start Hour Finish Hour Day 6 15 Afternoon 15 0 Night 0 23 Second one is called Shift that goes Date Shift Operator Equipment 25/06/18 Day Joel EX43 And the third one is a subform
Searching for records by date
Is it possible to set a search or filter for records with a date that is NOT in the last N months? I am trying to set it up so that our admin can easily see which records have NOT had an assessment done in the last 6 months. I see that there is an option in the drop-down that says "is not" - but I get the impression that is only for a specific date and not for a date range. Note: assessments are in a sub-form. I am viewing a report for records of the main form with a column for the assessment
Workflow for Updating fields is not working
Hi, I have created one report based on one form wherein i have added an action. This action should be perfomed whenever someone clicks the respective button and the workflow for updating one field of the same form (on which the report is made) should be executed. But this isnt working. Nothing happens when i click that respective button.
PDF File Failing - Record Template
I'm having issues when downloading a Record Template because it has a lot of images coming from a subform. File fails when I resize the image field of the subform editing the HTML on the record template. Do you know a solution to resize images without making the download file to fail? Thanks, Antonio Contreras
Apply one time mathematical operation to all values of a numeric field (all records)
I have a numeric field in a database that holds about one thousand records. I would like to multiply by 1.05 all the values linked to this field in all records. Is there a function that can help me achieved this without having to edit individually the 1000 records? Thanks for your help!
Can a new "customer" be added via a workflow?
I am setting up a database for our volunteers, and I'm wondering if it's possible to create new users in the customer portal via a workflow? What I'm hoping for is that once people submit a volunteer application by filling out an online (published) form on our site, our admin staff can simply click a button in the report to accept this volunteer and have a workflow create a new user profile based on the email they submitted (which would send the new volunteer an invitation email to set up their password).
the eu version of the customer portal is NOT working
Please help we are asking our customers to use the EU version of the customer portal this weekend but the portal seems completely unaccessible (while the app works fine).
Add Record Automatically in Child Form
I've searched everywhere for the answer to what seems like a simple problem but I haven't been able to find it, so please forgive me if it's already been covered. I'm looking for a way for a new record line to be opened upon entering the previous record. Is this possible? My setup is a parent form with information about the day's production and then I have a child form with barcodes/serial numbers of materials used for that day's production. I would like as I type them in for another row to appear
The add record on the new form is not working
Good day, I´m having some issues when applying the add record to a new form to add record from two different forms to create a table summarized. I have a form that has information that comes from the CRM. I have the client, the address and the project number. Let´s say that that client has two different project numbers but for sales management they only use 1. So in creator I made a form to let me enter manually as many projects as I want. Now Im trying to have a single report with the information
Hit the 5000 record update limit, need help restructuring code
I have a list of addresses that have been given an Area field (San Diego, DFW, Chicago, etc.). These areas include all the cities around the metro of those areas. We want to be able to update which cities belong in the areas, so I have a dynamic form that pulls the information and allows us to add or remove cities for the area. It works perfect for smaller areas, but I hit the 5000 record update limit on larger ones due to nested for loops. As much as I have tried, I cannot think of another way to
Script Builder not available when creating pages. Please help.
Hi, When creating new page Free Flow Script option opens and there is no option to switch to Script Builder. Please let me know how to get script builder option working? Thanks
Chained lookup in report
Hi, I have a chained lookups like this: FormA -> FormB -> FormC -> FormD I am wondering how can I built a report where I can show some fields from FormA and some fields from FormD. Thanks
Creator - custom number prefix for units
I was curious what the best way to show a units prefix at the end of a number/decimal field would be? I am looking to add fields for session durations, and right now it works okay with a number but a GREAT quality of life feature or hack would be to allow the field to show a unit similar to how the currency field shows a '$' (or your currency) at the end of it and in reports. Anyone know of a fix for this? Thanks!
Am I right that you cannot add parameters to a For Each Record formula that references a collection?
I have an HTML page that is using the For Each formula, using a collection as the variable. When I use a collection, it would appear that you cannot add the additional parameters, like sort by or range. I wanted to sort this data by date but am not able to and just want to confirm that this is correct. Thanks! Mike
Fetch Records Troubleshooting
I'm at a loss right now. I have Table 1 that lists fields ID, Length, Amount. I am trying to Fetch records into Table 2 when the ID entered into table to is equal to the ID in Table 1 and insert Length and Amount. Here is my code but it doesn't return anything x =Table1[ID == input.ID2]; input.Length2= x.Length; input.Amount2 = x.Amount;
New Page Created Just Hangs and no Deluge Tasks Available
When I create a new page, it hangs and I don't get any buttons on the left such as Insert HTML or any Deluge Tasks. It gives me this but the just shows the animated ellipsis forever. Tried it in Chrome and Safari and same result.
How to limit image size from image field in a record summary?
Hello, I am trying to build a Record Summary template to show a summary of a form which includes several types of fields, including a couple images taken from the mobile app. The size of the image in the summaty varies depending on the phone the picture is taken from. Is there a way to standardize or limit the size of the images in the record summary? Ideally, to have it limited by default in the summary, to be able to generate the report directly? Right now I get huge images in the record summary,
Next Page